Search Results po_price_diff_interface_n1

Overview

PO.PO_PRICE_DIFF_INTERFACE is an open-interface table in the Oracle Purchasing (PO) schema that stores price differentials for rate-based contingent labor lines. In Oracle EBS 12.1.1 and 12.2.2, it serves as the staging area through which external pricing data — holiday, overtime, weekend, and standard rate multipliers — is loaded before being validated and applied to requisition lines, purchase order lines, blanket lines, or blanket price breaks. The table is classified as belonging to the PO_PRICE_DIFFERENTIAL business entity and resides in the APPS_TS_INTERFACE tablespace, reflecting its transient, interface-oriented nature rather than its role as a permanent transactional store.

Based on the documented foreign key structure, the heuristic Data Vault classification for this object is standalone, suggesting it be modeled as an independent hub or staging artifact rather than as a link or satellite tied to a parent hub through declared constraints. The primary key is PO_PRICE_DIFF_INTERFACE_PK1, enforced by the unique index PO_PRICE_DIFF_INTERFACE_U1 on PRICE_DIFF_INTERFACE_ID.

Key Information Stored

The table carries twenty documented columns. The most operationally significant are:

• PRICE_DIFF_INTERFACE_ID — the surrogate primary key and sole business-key candidate, uniquely enforced by PO_PRICE_DIFF_INTERFACE_U1.
• ENTITY_ID — the identifier of the requisition line, PO line, blanket line, or price break to which the differential belongs; it references PO_REQUISITION_LINES_ALL.requisition_line_id, PO_LINES_ALL.po_line_id, or PO_LINE_LOCATIONS_ALL.line_location_id.
• ENTITY_TYPE — a VARCHAR2(30) discriminator accepting values such as 'REQ LINE', 'PO LINE', 'BLANKET LINE', and 'PRICE BREAK'.
• PRICE_TYPE — the rate category (STANDARD, HOLIDAY, OVERTIME, WEEKEND), sourced from FND_LOOKUP_VALUES.lookup_code under lookup_type 'PRICE DIFFERENTIALS'.
• PRICE_DIFFERENTIAL_NUM — the user-facing differential number.
• MULTIPLIER, MIN_MULTIPLIER, and MAX_MULTIPLIER — the applied multiplier and, for blankets only, its permitted bounds.
• ENABLED_FLAG — indicates whether the differential is active.
• INTERFACE_HEADER_ID, INTERFACE_LINE_ID, and INTERFACE_LINE_LOCATION_ID — the grouping keys that associate the staged row with its parent interface header, line, and line location.
• PROCESS_STATUS, PROCESS_CODE, and PROCESSING_ID — control columns driving and tracking concurrent processing of the interface row.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

The dominant use case is bulk loading contingent-labor price differentials from external systems prior to import. Reporting typically targets unprocessed or failed rows. A representative query identifies stalled records:

• SELECT price_diff_interface_id, interface_header_id, entity_type, price_type, process_status FROM po.po_price_diff_interface WHERE process_status IS NULL OR process_status = 'ERROR';
• All differentials for a specific source document: SELECT * FROM po.po_price_diff_interface WHERE interface_header_id = :header_id ORDER BY interface_line_id;
• Blanket-bound differentials with range constraints: SELECT price_differential_num, multiplier, min_multiplier, max_multiplier FROM po.po_price_diff_interface WHERE entity_type = 'BLANKET LINE' AND enabled_flag = 'Y';

Because PO_PRICE_DIFF_INTERFACE_N1 through N4 index INTERFACE_HEADER_ID, INTERFACE_LINE_ID, INTERFACE_LINE_LOCATION_ID, and PROCESSING_ID respectively, the preceding predicates are index-supported. Rows are purged after successful import, so queries usually scope to PROCESSING_ID or PROCESS_STATUS.

Related Objects

• PO_INTERFACE_ERRORS — references this table via PRICE_DIFF_INTERFACE_ID, capturing validation failures for rejected differential rows.
• PO_REQUISITION_LINES_ALL — source of ENTITY_ID values when ENTITY_TYPE is 'REQ LINE'.
• PO_LINES_ALL — source of ENTITY_ID values for 'PO LINE' and blanket lines.
• PO_LINE_LOCATIONS_ALL — source of ENTITY_ID values for price breaks and line locations.
• FND_LOOKUP_VALUES — supplies PRICE_TYPE codes under the 'PRICE DIFFERENTIALS' lookup type.
• PO_HEADERS_INTERFACE and PO_LINES_INTERFACE — companion interface tables joined through INTERFACE_HEADER_ID and INTERFACE_LINE_ID during concurrent import.