Search Results po_rcv_charges

Overview

PON.PON_PRICE_ELEMENT_TYPES is a Sourcing (PON) module reference table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the master definition of price element types — the classification records that govern how individual price elements are qualified, priced, allocated, and mapped to cost and invoice accounting constructs. Price elements themselves are the atomic cost or price components (freight, duty, surcharges, discounts, handling) attached to sourcing documents, quotations, and negotiation lines. The type record defines the behavioral template that each element instance inherits.

The table is owned by the PON schema and is documented with sixteen columns. Two unique indexes are defined: PON_PRICE_ELEMENT_TYPES_U1 on (PRICE_ELEMENT_TYPE_ID, ZD_EDITION_NAME), and PON_PRICE_ELEMENT_TYPES_U2 on UPPER("PRICE_ELEMENT_CODE"), confirming that the price element code is unique within the operating context. The primary key constraint is PON_PRICE_ELEMENT_TYPES_PK on PRICE_ELEMENT_TYPE_ID.

From a dimensional modeling perspective, the FK topology — many dependent tables referencing this one, with no upward foreign keys out of this table — suggests a hub-leaning classification in Data Vault terms. That is a modeling heuristic, not a physical characteristic: the table behaves as a durable business-key registry for price element types.

Key Information Stored

The surrogate primary key is PRICE_ELEMENT_TYPE_ID, a system-generated identifier referenced by all dependent tables. The principal business-key candidate is PRICE_ELEMENT_CODE, enforced uniquely through a function-based index on its uppercase form; this is the value users recognize in setup and integration payloads.

• TRADING_PARTNER_ID — associates the type with a trading partner, enabling supplier- or partner-specific element definitions.
• PRICING_BASIS — the calculation basis applied when the element is priced.
• ALLOCATION_BASIS — governs how the element's value is apportioned across lines or quantities.
• ENABLED_FLAG — activation status controlling whether the type is selectable.
• SYSTEM_FLAG — distinguishes seeded Oracle types from user-defined types; seeded rows are typically not deletable.
• INVOICE_LINE_TYPE — maps the element to an invoice line classification for downstream payables and matching.
• COST_COMPONENT_CLASS_ID — links the element to a cost component classification for cost build-up.
• COST_ANALYSIS_CODE and COST_ACQUISITION_CODE — cost accounting codes used in landed-cost and acquisition analysis.
• ZD_EDITION_NAME — the edition column supporting the multi-edition (ZD) data model in 12.2.x.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit columns.

Common Use Cases and Queries

Typical uses include validating price element setup, driving negotiation and RFQ pricing logic, and reconciling cost components in landed-cost reporting. A common lookup joins the type to its element instances:

• SELECT t.price_element_code, e.price_element_id FROM pon.pon_price_element_types t, pon.pon_price_elements e WHERE e.price_element_type_id = t.price_element_type_id;
• Filtering active definitions: WHERE enabled_flag = 'Y' AND system_flag = 'N' to isolate user-defined types.
• Joining to PON_PRICE_ELEMENT_TYPES_TL to retrieve translated names and descriptions for multilingual reporting.

Related Objects

• PON_PRICE_ELEMENTS — references this table via PRICE_ELEMENT_TYPE_ID; holds the element instances.
• PON_PRICE_ELEMENT_TYPES_TL — the translation table, joined on PRICE_ELEMENT_TYPE_ID.
• PO_COST_MST — cost master referencing the type for component classification.
• PON_FPK_DELETED_PRICE_ELEMENTS — tracks deleted elements by type.
• PON_LARGE_NEG_PF_VALUES — stores related negative price factor values.
• PON_BID_PRICE_ELEMENTS_INT and PON_AUC_PRICE_ELEMENTS_INT — interface tables for bid and auction price elements.
• PON_INTERFACE_ERRORS — captures interface failures keyed by price element type.