Results for “op_cntr_hdr”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OP_CNTR_HDR is the contract header table in the Oracle Process Manufacturing Logistics (GML) module, holding the master record for each contract maintained within Process Manufacturing. It is owned by the GML schema and is marked VALID in the ETRM 12.2.2 dictionary, consisting of 51 documented columns. The table functions as the parent entity for contract detail lines and price effectivity records, providing the descriptive, currency, discount, and value-aggregate attributes that govern a contract before its line-level components are considered.

From a dimensional modeling perspective, the ETRM metadata classifies OP_CNTR_HDR as satellite-leaning based on its foreign key structure. This is a heuristic suggestion rather than a mandated design: the table carries a small number of stable foreign key references (two to GL_CURR_MST and one to OP_TEXT_HDR) alongside a large number of descriptive and attribute columns, which is characteristic of a satellite dependent on a contract business key rather than a pure transactional hub or a link table.

Key Information Stored

The surrogate primary key is CONTRACT_ID, enforced by the OP_CNTR_HDR_PK index. The business-key candidate is CONTRACT_NO, enforced by the unique index OP_CNTR_HDR_U1; CONTRACT_NO is the user-facing contract identifier used in operational and reporting lookups. Among the most operationally significant columns are:

• CONTRACT_DESC1 and CONTRACT_DESC2 — short descriptions of the contract header.
• COMMENTS — free-form notes attached to the contract.
• CONTRACT_CURRENCY — the transactional currency, foreign keyed to GL_CURR_MST.
• BASE_CURRENCY — the base (functional) currency, also foreign keyed to GL_CURR_MST.
• EXCHANGE_RATE and MUL_DIV_SIGN — the conversion rate and the multiply/divide indicator governing currency conversion.
• ORDER_DISCOUNT — the discount applied at contract order level.
• VALUE_ORDERED — the aggregated ordered value for the contract header.
• PRESALES_ORD_ID — reference to the originating presales order.
• TEXT_CODE — foreign key to OP_TEXT_HDR for attached text/notes.
• DELETE_MARK and IN_USE — status and concurrency indicators maintained by the application.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — the extensible descriptive flexfield (DFF) segments for customer-specific data.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical scenarios include contract header listings by currency, identification of contracts with outstanding ordered value, and cross-module reporting that joins header attributes to contract detail lines. A standard lookup by business key uses CONTRACT_NO:

• SELECT h.CONTRACT_ID, h.CONTRACT_NO, h.CONTRACT_DESC1, h.CONTRACT_CURRENCY, h.VALUE_ORDERED FROM GML.OP_CNTR_HDR h WHERE h.CONTRACT_NO = :contract_no AND h.DELETE_MARK = 0;
• Joining detail lines: SELECT h.CONTRACT_NO, d.* FROM GML.OP_CNTR_HDR h, GML.OP_CNTR_DTL d WHERE h.CONTRACT_ID = d.CONTRACT_ID;
• Reporting by currency: SELECT CONTRACT_CURRENCY, SUM(VALUE_ORDERED) FROM GML.OP_CNTR_HDR WHERE DELETE_MARK = 0 GROUP BY CONTRACT_CURRENCY;
• Price effectivity linkage: SELECT h.CONTRACT_NO, p.* FROM GML.OP_CNTR_HDR h, GML.OP_PRCE_EFF p WHERE h.CONTRACT_ID = p.CONTRACT_ID;
• DFF reporting filters on ATTRIBUTE_CATEGORY and the ATTRIBUTE1–30 segments for custom extensions.

Because the table carries DELETE_MARK, all queries should generally filter on DELETE_MARK = 0 to exclude logically deleted rows.

Related Objects

The following objects are materially related through documented foreign key relationships:

• GL_CURR_MST — referenced twice, via OP_CNTR_HDR.CONTRACT_CURRENCY and OP_CNTR_HDR.BASE_CURRENCY.
• OP_TEXT_HDR — referenced via OP_CNTR_HDR.TEXT_CODE for attached textual content.
• OP_CNTR_DTL — child table joined by CONTRACT_ID; holds contract detail lines.
• OP_PRCE_EFF — child table joined by CONTRACT_ID; holds price effectivity records.