Search Results oks_int_header_stg_temp




Overview
Explore in AI Chat

Overview

OKS_INT_HEADER_STG_TEMP is a Service Contracts (OKS) staging table that holds contract header data during interface processing in Oracle EBS 12.1.1 and 12.2.2. It serves as the inbound landing zone for contract headers before validation and transfer into the base contract tables. The table is owned by the OKS schema and is classified as VALID. It contains 80 documented columns in the 12.2.2 physical schema.

From a Data Vault modeling perspective, this table can be treated as a standalone staging structure. The heuristic classification is standalone, meaning no resolved parent-child link structure is derived from its foreign key metadata. Operationally, it functions as an interface table rather than a normalized entity, so its lifecycle is tied to concurrent programs that read, validate, and purge staging rows.

Key Information Stored

The primary surrogate identifier is HEADER_INTERFACE_ID, which uniquely identifies each staging row. HEADER_INTERFACE_ROWID provides a row reference used by interface processing logic. Business-key candidates include CONTRACT_NUMBER and its qualifier CONTRACT_NUMBER_MODIFIER, along with SOURCE and DOCUMENT, which together identify the origin and source reference of the interface record.

Common Use Cases and Queries

Typical use cases include monitoring inbound contract loads, diagnosing interface errors, and auditing staged contract headers before submission to the Service Contracts mainline tables. A common pattern is to count rows by interface status:

  • SELECT INTERFACE_STATUS, COUNT(*) FROM OKS.OKS_INT_HEADER_STG_TEMP GROUP BY INTERFACE_STATUS;
  • SELECT HEADER_INTERFACE_ID, CONTRACT_NUMBER, INTERFACE_STATUS FROM OKS.OKS_INT_HEADER_STG_TEMP WHERE INTERFACE_STATUS = 'ERROR';
  • SELECT h.CONTRACT_NUMBER, c.COMMITMENT_ID FROM OKS.OKS_INT_HEADER_STG_TEMP h JOIN PON_OFFER_COMMITMENTS c ON h.COMMITMENT_ID = c.COMMITMENT_ID;

Reporting use cases include reconciling contract interfaces by source and document, validating currency and pricing attributes, and confirming customer party assignment prior to contract activation.

Related Objects

The documented foreign key links COMMITMENT_ID to PON_OFFER_COMMITMENTS. Additional related objects in the standard Service Contracts interface flow include the corresponding contract line staging table, the base contract header tables used after transfer, and the concurrent programs that populate and consume this staging table. Significant relationships include:

  • PON_OFFER_COMMITMENTS — joined on COMMITMENT_ID.
  • OKS_INT_LINES_STG_TEMP — line-level staging companion to the header interface.
  • OKS_HEADERS_ALL — target contract header table after successful processing.
  • OKS_CONTRACTS_ALL — base contract records linked to processed headers.
  • HZ_CUST_ACCOUNTS and HZ_PARTIES — resolved through CUSTOMER_PARTY_ID for party validation.
  • Service Contracts interface concurrent programs — readers and validators of staged rows.