Search Results purchase_price




Overview
Explore in AI Chat

Overview

POA_BIS_SUPPLIER_PERFORMAN_EFC is a summary table owned by the PO (Purchasing) schema in Oracle E-Business Suite, residing in the APPS_TS_SUMMARY tablespace. Its name and column set identify it as a Business Intelligence System (BIS) supplier performance aggregate. The "_EFC" suffix denotes "Euro Fixed Currency": according to the object documentation, the table holds supplier performance data expressed in the original set of books currency, captured prior to the euro switch. It therefore serves as a historical, pre-euro-conversion staging or archival aggregate for procurement supplier performance reporting, preserving amounts, purchase prices, and conversion rates as they existed under the legacy currency regime.

The object is documented with a status of VALID and carries an FND Design Data entry (PO.POA_BIS_SUPPLIER_PERFORMAN_EFC). Its storage parameters (PCT Free 10, APPS_TS_SUMMARY) are typical of aggregated reporting tables rather than high-transaction OLTP tables. Under the heuristic Data Vault classification mined from its foreign key structure, this table is modeled as a standalone object — it references only FND_SECURITY_GROUPS and is not itself referenced, suggesting it functions as an isolated snapshot or aggregate rather than a central hub within a linked schema.

Key Information Stored

The documented schema contains seven columns. The most significant are:

  • PURCHASE_PRICE (NUMBER) — the purchase price recorded for the supplier performance measurement, and the specific attribute the user searched for. It is the core measure of procurement cost captured in this aggregate.
  • AMOUNT (NUMBER) — the monetary amount associated with the performance record, typically the extended or total spend figure.
  • CURRENCY_CODE (VARCHAR2, 15) — the currency in which AMOUNT and PURCHASE_PRICE are denominated; because of the pre-euro context, this identifies the original set of books currency before conversion.
  • RATE (NUMBER) — the currency conversion rate applied, enabling restatement of the legacy-currency figures.
  • SET_OF_BOOKS_ID (NUMBER) — identifies the set of books (ledger) under which the performance data was recorded, a key accounting dimension.
  • SHIP_TO_ORGANIZATION_ID (NUMBER) — the ship-to organization, providing the organizational dimension for the performance record.
  • SECURITY_GROUP_ID (NUMBER) — the security group identifier, the sole documented foreign key, referencing FND_SECURITY_GROUPS.

No surrogate primary key or unique index is documented in the provided metadata. Business-key candidates are limited by the absence of a documented unique constraint; in practice the dimensional combination of SET_OF_BOOKS_ID, SHIP_TO_ORGANIZATION_ID, CURRENCY_CODE, and SECURITY_GROUP_ID would be the natural grouping key for an aggregate of this type. The absence of a documented single-column primary key reinforces the heuristic classification as a standalone aggregate rather than a hub.

Common Use Cases and Queries

This table supports historical supplier performance and procurement spend reporting for the pre-euro era. Typical uses include auditing purchase prices by ship-to organization, reconciling legacy-currency amounts to converted values using RATE, and reconstructing supplier performance reporting as it was presented before the euro switch.

A representative query retrieving the searched attribute with its dimensions:

  • SELECT PURCHASE_PRICE, AMOUNT, CURRENCY_CODE, RATE, SHIP_TO_ORGANIZATION_ID, SET_OF_BOOKS_ID FROM PO.POA_BIS_SUPPLIER_PERFORMAN_EFC WHERE CURRENCY_CODE = :p_currency;
  • Aggregation by organization: SELECT SHIP_TO_ORGANIZATION_ID, SUM(AMOUNT) total_amount, AVG(PURCHASE_PRICE) avg_price FROM PO.POA_BIS_SUPPLIER_PERFORMAN_EFC GROUP BY SHIP_TO_ORGANIZATION_ID;
  • Currency restatement: SELECT AMOUNT * RATE restated_amount FROM PO.POA_BIS_SUPPLIER_PERFORMAN_EFC WHERE CURRENCY_CODE = :legacy_currency;

Because the table sits in APPS_TS_SUMMARY and holds pre-euro data, it is primarily consulted for historical trending and audit rather than current-period procurement analysis.

Related Objects

The documented dependency data is sparse. The table references no database object and is referenced only by the APPS synonym POA_BIS_SUPPLIER_PERFORMAN_EFC. Its sole documented foreign key is:

  • FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID, controlling row-level security access to the performance records.
  • POA_BIS_SUPPLIER_PERFORMAN_EFC (APPS synonym) — the application-level synonym through which EBS reporting and forms resolve the base PO table.

Related objects that would typically be associated in a supplier performance reporting context — including sets of books (GL), ship-to organization definitions (HR/INV), and supplier master data — are implied by the SET_OF_BOOKS_ID and SHIP_TO_ORGANIZATION_ID columns, though no explicit foreign keys to those entities are documented. The most reliable related object from the provided metadata remains FND_SECURITY_GROUPS.