Search Results op_cntr_hdr_u1

Overview

The OP_CNTR_HDR table is the central repository for contract header information within Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML). It serves as the master record for defining and managing commercial agreements, such as purchase or sales contracts, that govern the procurement or supply of goods. As a header table, it stores the overarching terms and conditions applicable to a contract, which are then detailed and executed through associated line-level tables. Its existence is critical for enforcing pricing, sourcing, and fulfillment rules within the manufacturing and logistics modules.

Key Information Stored

The table's primary identifier is the system-generated CONTRACT_ID, which is enforced by the OP_CNTR_HDR_PK primary key. A unique business identifier, the CONTRACT_NO, is also maintained under the OP_CNTR_HDR_U1 key. Key descriptive and financial attributes are stored, including currency information. As indicated by the foreign key relationships, the table holds columns for CONTRACT_CURRENCY and BASE_CURRENCY, both referencing the GL_CURR_MST (Currency Master) table to define the transactional and accounting currencies for the contract. Additionally, a TEXT_CODE column links to the OP_TEXT_HDR table, allowing for the attachment of extensive legal or descriptive notes to the contract header.

Common Use Cases and Queries

This table is fundamental for contract inquiry, reporting, and integration. Common operational scenarios include validating contract details before creating purchase orders or sales orders, generating contract summary reports for management, and auditing contract terms. A typical query to retrieve basic contract information alongside its currency codes would be:

• SELECT h.contract_no, h.contract_id, h.contract_currency, c1.currency_code, h.base_currency, c2.currency_code FROM gml.op_cntr_hdr h, gl_curr_mst c1, gl_curr_mst c2 WHERE h.contract_currency = c1.currency_code(+) AND h.base_currency = c2.currency_code(+);

Another frequent use case involves joining to its detail tables to analyze full contract coverage, such as listing all contracts with their associated line items: SELECT h.contract_no, d.line_id, d.item_id FROM gml.op_cntr_hdr h, gml.op_cntr_dtl d WHERE h.contract_id = d.contract_id.

Related Objects

The OP_CNTR_HDR table has several key dependencies, as outlined in the metadata. It is the parent table for critical transactional entities. The OP_CNTR_DTL table stores the line-level details (items, quantities) for each contract, linked via CONTRACT_ID. The OP_PRCE_EFF (Price Effectiveness) table references the header, enabling the application of contract-specific pricing rules. For descriptive text, it depends on OP_TEXT_HDR. For currency validation and descriptions, it references the GL_CURR_MST table twice, for both the contract and base currencies. These relationships form the core data model for contract management in GML.