Search Results oe_price_atts_iface_all




Overview
Explore in AI Chat

Overview

The OE_PRICE_ATTS_IFACE_ALL table is a multi-organization (multi-org) interface table within the Oracle E-Business Suite (EBS) Order Management (ONT) module. Its primary role is to serve as a staging area for data that will ultimately populate the OE_ORDER_PRICE_ATTRIBS table. This table is a critical component of the Order Management pricing interface, facilitating the bulk import of pricing attribute data from external systems or legacy applications into the core EBS transactional tables. As a multi-org table, it contains data for all operating units and uses the standard MOAC (Multi-Org Access Control) security model. Its design supports high-volume data loading processes, enabling efficient integration and data migration workflows for pricing information associated with sales orders.

Key Information Stored

The table stores transactional interface records for order pricing attributes. While the provided metadata does not list specific columns, the table's purpose indicates it holds data necessary to create records in OE_ORDER_PRICE_ATTRIBS. Based on its function and foreign key relationship, key columns typically include a unique interface record identifier (e.g., INTERFACE_LINE_ID), the associated order source identifier (ORDER_SOURCE_ID), and columns mapping to the attributes in the target table. These would include identifiers for the pricing context, attribute, and the specific value being applied. The table also contains standard interface control columns such as PROCESS_FLAG and ERROR_MESSAGE to manage the status of interface records, along with CREATION_DATE and CREATED_BY for auditing.

Common Use Cases and Queries

The primary use case is the programmatic loading of pricing attribute data via concurrent programs or custom PL/SQL scripts that call the standard Order Management import APIs. A common operational query is to monitor pending interface records for processing or to diagnose errors. For example:

  • To identify unprocessed records: SELECT * FROM ont.oe_price_atts_iface_all WHERE process_flag = 'PENDING' AND org_id = :p_org_id;
  • To review failed interface records with errors: SELECT interface_line_id, error_message FROM ont.oe_price_atts_iface_all WHERE process_flag = 'ERROR';

Data is typically inserted into this table from flat files or an external system staging table, after which the standard Order Management interface import program is run to validate the data and create the final OE_ORDER_PRICE_ATTRIBS records.

Related Objects

This interface table has direct dependencies within the Order Management schema. As documented in the provided metadata:

  • OE_ORDER_SOURCES: The table contains a foreign key where OE_PRICE_ATTS_IFACE_ALL.ORDER_SOURCE_ID references OE_ORDER_SOURCES. This validates the source of the order (e.g., "Order Entry", "Oracle Configurator", "Web Orders") for the incoming pricing attribute data.
  • OE_ORDER_PRICE_ATTRIBS: This is the definitive target transactional table. The interface table's sole purpose is to populate this object, which stores the final pricing attribute assignments for sales order lines.
  • Standard Order Management Interface Programs: Concurrent programs and underlying PL/SQL APIs (often within the OE_HEADERS_IFACE_* or OE_LINES_IFACE_* packages) control the validation and transfer of data from this interface table to its target.