Results for “tax_exemption_number”

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

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:

• LINE_INTERFACE_ID — Surrogate identifier for the staging line row; primary identity candidate.
• HEADER_INTERFACE_ID / HEADER_INTERFACE_ROWID — Correlate each line to its parent interface header record.
• LINE_INTERFACE_ROWID — Alternate row locator used during bulk interface processing.
• LINE_NUMBER / LINE_TYPE — Positional and type classification of the contract line.
• ITEM_ID / ITEM_ORGANIZATION_ID — Inventory item and organization references for serviceable products.
• LINE_REFERENCE — External reference to source contract or template defining the line.
• STATUS_CODE — Interface processing state (for example, pending, error, or processed).
• START_DATE / END_DATE — Effective period for the contract line.
• PRICE_LIST_ID / UNIT_PRICE / SUBTOTAL — Pricing and monetary totals for the line.
• TAX_AMOUNT / TAX_EXEMPTION_CONTROL — Tax handling attributes carried through to billing.
• BILL_TO_SITE_USAGE_ID / SHIP_TO_SITE_USAGE_ID — Customer site context for the line.
• COMMITMENT_ID — Foreign key to PON_OFFER_COMMITMENTS, linking the line to purchasing commitments.
• PAYMENT_TERMS_ID / INVOICING_RULE_ID — Billing and payment configuration.

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.