Search Results so_lines_interface_pk

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

Overview

SO_LINES_INTERFACE_ALL is the Oracle Order Entry (OE) open interface table that stages imported order line information prior to validation and insertion into the permanent order tables by the Order Import concurrent program. It resides in the OE schema with a status of VALID and, in Oracle EBS 12.2.2, carries 198 documented columns. Each row represents a single order line awaiting processing, including its pricing, shipping, service, and scheduling attributes, and carries control columns (INTERFACE_STATUS, ERROR_FLAG, GROUP_ID, OPERATION_CODE) that govern how Order Import treats the record.

Because the interface table is populated from external or feeder systems and holds descriptive, mutable attributes tied to a parent order line key, the heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning. A satellite model would place the line identifiers in a parent hub or link and the descriptive and dependent columns in one or more satellites keyed by load date.

Key Information Stored

The primary key is SO_LINES_INTERFACE_PK, defined on the composite of ORIGINAL_SYSTEM_REFERENCE and ORIGINAL_SYSTEM_LINE_REFERENCE. In addition, unique index SO_LINES_INTERFACE_U1 (as documented for 12.2.2 on ORIGINAL_SYSTEM_REFERENCE, ORDER_SOURCE_ID, ORIGINAL_SYSTEM_LINE_REFERENCE) serves as the business-key candidate, uniquely identifying a source line across order sources. The most significant columns include:

• ORIGINAL_SYSTEM_REFERENCE and ORIGINAL_SYSTEM_LINE_REFERENCE — identification of the source order and line, forming the primary key and business key.
• LINE_NUMBER, LINE_TYPE, ORDER_SOURCE_ID, ORDER_CATEGORY — line grouping and classification.
• INVENTORY_ITEM_ID and INVENTORY_ITEM_SEGMENT1–20 — the ordered item and concatenated segment flexfield values.
• ORDERED_QUANTITY, UNIT_CODE, SELLING_PRICE, PRICE_LIST_ID — quantity, unit of measure, and pricing reference.
• TERMS_ID and TERMS_NAME — payment terms for the line, the column the user searched for under the context of RA_TERMS_B.
• SHIP_TO_SITE_USE_ID, SHIP_TO_CONTACT_ID, SHIP_ADDRESS1, WAREHOUSE_ID, SHIP_METHOD_CODE — shipping and fulfillment routing.
• INTERFACE_STATUS, ERROR_FLAG, OPERATION_CODE, GROUP_ID — Order Import control and error tracking.

Common Use Cases and Queries

Typical uses involve monitoring pending imports, troubleshooting validation failures, and reconciling source data before it reaches OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL. A common query identifies lines awaiting processing:

SELECT ORIGINAL_SYSTEM_REFERENCE, ORIGINAL_SYSTEM_LINE_REFERENCE, ORDER_SOURCE_ID, LINE_NUMBER, INVENTORY_ITEM_ID, ORDERED_QUANTITY, INTERFACE_STATUS, ERROR_FLAG FROM OE.SO_LINES_INTERFACE_ALL WHERE INTERFACE_STATUS IS NULL OR ERROR_FLAG = 'Y' ORDER BY ORIGINAL_SYSTEM_REFERENCE, LINE_NUMBER;

Because TERMS_ID references RA_TERMS_B, analysts frequently join to confirm the payment terms on staged lines:

SELECT l.ORIGINAL_SYSTEM_REFERENCE, l.ORIGINAL_SYSTEM_LINE_REFERENCE, l.TERMS_ID, t.NAME FROM OE.SO_LINES_INTERFACE_ALL l, RA_TERMS_B t WHERE l.TERMS_ID = t.TERM_ID;

Reporting patterns include error dashboards grouped by GROUP_ID, batch reconciliations against SO_HEADERS_INTERFACE_ALL, and pre-import validation extracts for pricing and shipping defaults.

Related Objects

The table participates in several documented foreign-key relationships:

• SO_HEADERS_INTERFACE_ALL — SO_LINES_INTERFACE_ALL.ORIGINAL_SYSTEM_REFERENCE references the parent imported order header.
• RA_TERMS_B — TERMS_ID references the payment terms definition, directly relevant to the RA_TERMS_B search.
• RA_RULES — ACCOUNTING_RULE_ID and INVOICING_RULE_ID reference accounting and invoicing rule definitions.
• SO_AGREEMENTS_B — AGREEMENT_ID links the line to the governing sales agreement.
• SO_PRICE_LISTS_B — PRICE_LIST_ID references the price list applied to the line.
• RA_SITE_USES_ALL — SHIP_TO_SITE_USE_ID references the ship-to site use.
• PON_OFFER_COMMITMENTS — COMMITMENT_ID links to sourcing commitments.
• MTL_CUSTOMER_ITEMS — CUSTOMER_ITEM_ID references the customer item definition.
• SO_LINE_DETAILS_INTERFACE — a detail-level interface table referencing this table on ORIGINAL_SYSTEM_REFERENCE and ORIGINAL_SYSTEM_LINE_REFERENCE.

These relationships confirm that SO_LINES_INTERFACE_ALL functions as a staging satellite bounded by imported order headers and enriched through dependent reference tables such as RA_TERMS_B.