Search Results so_line_attributes_int_pk

Overview

The SO_LINE_ATTRIBUTES_INTERFACE table is a critical data interface within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically for versions 12.1.1 and 12.2.2. It functions as a staging table designed to hold supplementary attribute data for sales order lines during the order import process. Its primary role is to facilitate the integration of sales order information from external systems, such as legacy applications or e-commerce platforms, into the core Oracle Order Management tables. Data is populated into this interface table, typically via custom programs or the Order Import concurrent program (OE_ORDER_PUB_PROCESS_ORDER), before being validated and transferred to the base transaction tables.

Key Information Stored

The table stores extended attributes for imported order lines that are not part of the core line definition in the primary interface table. Based on the provided metadata, its structure is anchored by a composite primary key. The key columns are essential for uniquely identifying and processing each interface record and linking it to its corresponding header and line in other interface tables. The documented primary key columns are:

• ORIGINAL_SYSTEM_REFERENCE: The unique identifier from the originating external system for the sales order header.
• ORDER_SOURCE_ID: A code identifying the source system or channel from which the order originated.
• ORIGINAL_SYSTEM_LINE_REFERENCE: The unique identifier from the originating system for the specific order line, which the user explicitly searched for. This column, in conjunction with the header reference, ensures each line attribute set is matched to the correct imported line.

While the specific attribute columns are not detailed in the excerpt, this table commonly holds data for flexible fields, descriptive elements, or custom line-level information required by the business but not captured in the standard line interface columns.

Common Use Cases and Queries

The primary use case is the bulk import of complex sales orders with rich line-level metadata. A common operational query involves checking for interface errors or pending records before running the Order Import process. For example, to find all attribute records for a specific imported order source and reference, one might use:

SELECT * FROM oe.so_line_attributes_interface WHERE order_source_id = 1000 AND original_system_reference = 'ECOM-12345';

Another critical pattern is joining this table to the main line interface table (SO_LINES_INTERFACE) to validate or report on the completeness of imported data, using the key columns as the join condition:

SELECT sli.original_system_line_reference, slai.* FROM oe.so_lines_interface sli, oe.so_line_attributes_interface slai WHERE sli.original_system_reference = slai.original_system_reference AND sli.order_source_id = slai.order_source_id AND sli.original_system_line_reference = slai.original_system_line_reference AND sli.interface_line_id = 9876;

Related Objects

The table has a direct relationship with the primary line interface table, SO_LINES_INTERFACE. The documented primary key (SO_LINE_ATTRIBUTES_INT_PK) on ORIGINAL_SYSTEM_REFERENCE, ORDER_SOURCE_ID, and ORIGINAL_SYSTEM_LINE_REFERENCE implies a foreign key relationship to corresponding columns in SO_LINES_INTERFACE. This ensures referential integrity, meaning every record in the attributes interface must correspond to a valid line in the lines interface. The main processing entity for this data is the Order Management API, specifically the OE_ORDER_PUB_PROCESS_ORDER procedure within the OE_ORDER_PUB package, which reads, validates, and cleans data from this and related interface tables.