Search Results jai_om_oe_so_lines

Overview

The JAI_OM_OE_SO_LINES table is a core localization extension table within the Oracle E-Business Suite (EBS) for the Asia/Pacific region. It functions as a child table to the standard OE_ORDER_LINES_ALL table, storing country-specific transactional attributes required for legal and tax compliance in supported jurisdictions. Its primary role is to augment the standard Oracle Order Management functionality with localization data, ensuring that sales order processing adheres to regional statutory requirements without modifying the base application tables. This design is consistent with Oracle's localization strategy for EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its foreign key relationships, which indicate the nature of the data it holds. The primary key column, LINE_ID, typically corresponds to the LINE_ID from OE_ORDER_LINES_ALL, creating a one-to-one relationship with the standard sales order line. Critical localization columns include TAX_CATEGORY_ID, which links to the JAI_CMN_TAX_CTGS_ALL table to determine the applicable tax classification for the line item. The columns SPLIT_FROM_LINE_ID and SHIPMENT_SCHEDULE_LINE_ID maintain referential integrity with the parent order line for advanced fulfillment scenarios. The HEADER_ID column ensures the localization record is correctly associated with its sales order header.

Common Use Cases and Queries

The primary use case is the generation of localized tax reports and statutory invoices. For instance, a query to extract the complete sales order line data with its associated tax category for a specific order would join this table with the standard tables. A common reporting pattern is:

• SELECT oel.line_number, oel.ordered_item, jl.tax_category_id, jctc.tax_category_code FROM oe_order_lines_all oel, jai_om_oe_so_lines jl, jai_cmn_tax_ctgs_all jctc WHERE oel.line_id = jl.line_id AND jl.tax_category_id = jctc.tax_category_id(+) AND oel.header_id = :p_header_id;

Another critical scenario is during the order import process, where custom programs must populate this table with localization data derived from the source system to ensure complete and compliant order records in EBS.

Related Objects

JAI_OM_OE_SO_LINES is centrally connected to several key EBS objects, as documented by its foreign keys. Its primary relationship is with the standard OE_ORDER_LINES_ALL table, joined on the LINE_ID, SPLIT_FROM_LINE_ID, and SHIPMENT_SCHEDULE_LINE_ID columns. It also has a mandatory link to OE_ORDER_HEADERS_ALL via the HEADER_ID column. For tax determination, it references the localization tax master table JAI_CMN_TAX_CTGS_ALL through the TAX_CATEGORY_ID column. These relationships ensure that every localized sales order line is anchored to a valid transactional line and header, with a defined tax profile.