Search Results oks_int_line_stg_temp




Overview
Explore in AI Chat

Overview

OKS_INT_LINE_STG_TEMP is a temporary staging table owned by the OKS schema within the Service Contracts module of Oracle E-Business Suite. It functions as an interface staging area for capturing and processing service contract line-level data before validation and insertion into the production contract tables. The "_TEMP" suffix indicates that rows are transient: records are loaded, validated through concurrent programs, and then purged or migrated to permanent OKS tables such as OKS_K_LINES and OKS_K_HEADERS.

Based on a heuristic Data Vault classification mined from foreign key structure, this object is modeled as a standalone entity. It references PON_OFFER_COMMITMENTS through its COMMITMENT_ID column, but no other tables in the documented schema depend on it via FK constraints, which is consistent with a staging or landing table pattern rather than an integrated hub or link. The table contains 54 documented columns in ETRM 12.2.2, with physical identity in OKS at OKS.OKS_INT_LINE_STG_TEMP.

Key Information Stored

The table captures both header correlation keys and full line-level contract detail:

Common Use Cases and Queries

The primary use case is populating and auditing the interface load for service contract lines. Typical queries filter interface rows by status, or reconcile staged amounts against production records:

  • Listing unprocessed lines: SELECT * FROM OKS.OKS_INT_LINE_STG_TEMP WHERE STATUS_CODE IS NULL OR STATUS_CODE = 'ERROR';
  • Correlating lines to headers: SELECT h.HEADER_INTERFACE_ID, l.LINE_NUMBER, l.LINE_TYPE FROM OKS_OKS_INT_HEADER_STG_TEMP h, OKS.OKS_INT_LINE_STG_TEMP l WHERE h.HEADER_INTERFACE_ID = l.HEADER_INTERFACE_ID;
  • Auditing committed lines against PON_OFFER_COMMITMENTS using COMMITMENT_ID.
  • Reviewing pricing and tax totals prior to contract activation.

Related Objects

  • PON_OFFER_COMMITMENTS — Referenced via COMMITMENT_ID for commitment linkage.
  • OKS_K_LINES / OKS_K_HEADERS — Destination production tables receiving staged rows.
  • OKS_INT_HEADER_STG_TEMP — Header staging table joined on HEADER_INTERFACE_ID.
  • OKS_K_LINE_DETAILS — Extended line attributes populated after interface validation.
  • OKS_BILLING_SCHEDULES — Derived billing schedules from invoicing rules on the line.