Search Results op_cust_con




Overview
Explore in AI Chat

Overview

The OP_CUST_CON table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the central repository for storing detailed contact information associated with customers. Its primary role is to maintain a master list of customer contacts, enabling the linkage of specific individuals to business transactions such as sales orders and price lists. This table is fundamental for ensuring accurate communication and relationship management within the supply chain and order fulfillment processes of Process Manufacturing.

Key Information Stored

The table's structure is centered around uniquely identifying a contact and associating them with a specific customer and address. Based on the provided metadata, the key columns include:

  • CONTACT_ID: The unique primary identifier for each contact record, enforced by the OP_CUST_CON_PK constraint.
  • CONTACT_NAME: The name of the individual contact.
  • CUST_ID: A foreign key linking the contact to a specific customer master record in the OP_CUST_MST table.
  • ADDR_ID: A foreign key linking the contact to a specific address record in the SY_ADDR_MST table.

The combination of CONTACT_NAME and CUST_ID is also enforced as a unique key (OP_CUST_CON_U1), preventing duplicate contact entries for the same customer.

Common Use Cases and Queries

This table is primarily accessed to retrieve contact details for transactional documents and reporting. A common use case is populating the "Ship To" or "Bill To" contact on sales orders and price lists. Typical queries involve joining with related master tables to create meaningful contact lists or to validate data during transaction entry.

Sample Query: Retrieve all contacts for a specific customer:
SELECT cont.contact_name, addr.address_line1
FROM gml.op_cust_con cont,
gml.sy_addr_mst addr
WHERE cont.cust_id = :p_customer_id
AND cont.addr_id = addr.addr_id(+)
ORDER BY cont.contact_name;

Sample Query: Identify contacts referenced in open sales orders:
SELECT oh.order_number, cont.contact_name
FROM gml.op_ordr_hdr oh,
gml.op_cust_con cont
WHERE oh.contact_id = cont.contact_id
AND oh.order_status = 'OPEN';

Related Objects

The OP_CUST_CON table has significant integration points, as evidenced by its foreign key relationships. It is a parent table to several key transactional entities:

  • Parent Tables: OP_CUST_MST (customer master) and SY_ADDR_MST (address master).
  • Child Tables: The CONTACT_ID column is referenced as a foreign key in major transactional tables, including OP_ORDR_HDR (Sales Order Headers), OP_ORDR_DTL (Sales Order Lines), OP_PRSL_HDR (Price List Headers), and OP_PRSL_DTL (Price List Lines). This design ensures contact integrity across the order-to-cash cycle.

Direct queries or data fixes on OP_CUST_CON must consider these dependencies to maintain referential integrity within the GML module.