Search Results get_ipv

Overview

POA_EDW_VARIABLES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Procurement Operational Analytics (POA) Extract, Transform, and Load (ETL) layer feeding the Enterprise Data Warehouse (EDW). Its stated purpose is to expose a centralized set of "variable" values — dates, currencies, rates, and status flags — that the procurement fact collection views (FCVs) require when populating supplier performance and purchase order distribution fact tables. By isolating these derivation rules in a single package, Oracle ensures that the multiple FCVs used by the POA dashboards and the Oracle Procurement and Spend Analytics reporting model apply identical business logic. The object carries an API classification of OTHER, indicating it is an internal implementation utility rather than a public, customer-callable API. The package is documented as VALID in both EBS 12.1.1 and 12.2.2 and has no direct dependencies beyond SYS.STANDARD, confirming it relies almost entirely on its own PL/SQL logic and standard supplied packages.

Key Procedures and Functions

The ETRM metadata documents thirteen procedures and functions. Their names describe the business values they resolve for the ETL layer rather than the mechanics of retrieval:

• INIT — initialization routine, likely invoked at the start of an extraction run to establish package state or session-level defaults.
• GET_REQ_APPROVAL_DATE — returns the requisition approval date used as a timeline milestone in procurement cycle-time reporting.
• GET_ACCEPTANCE_DATE — returns the date on which goods or services were accepted.
• GET_GOODS_RECEIVED_DATE — resolves the receipt date for received quantities.
• GET_CHECK_CUT_DATE — returns the check cut date, a payment milestone relevant to spend and payment-cycle analysis.
• GET_INVOICE_CREATION_DATE — supplies the invoice creation date used in invoice-to-payment metrics.
• GET_INVOICE_RECEIVED_DATE — returns the date the invoice was received, supporting receipt-to-invoice cycle measurement.
• GET_SUPPLIER_APPROVED — returns an indicator of supplier approval status for supplier performance fact rows.
• APPROVED_BY — identifies the approver associated with the approval decision.
• GET_IPV — returns an invoice price variance value used in cost and savings analysis.
• GET_GLOBAL_CURRENCY_RATE — supplies the currency conversion rate applied when reporting amounts in the global reporting currency.
• GET_UOM_CONV_RATE — returns the unit of measure conversion rate needed to normalize quantities across differing UOMs.

No parameter lists are documented in the ETRM metadata, so only the purpose of each routine is described here.

Tables Accessed

The documented metadata does not enumerate any base tables referenced through APPS synonyms; no table-level dependency information is recorded for this package. Its only listed dependency is SYS.STANDARD, confirming that the package is logic-centric, performing date derivation, rate lookup, and status evaluation without directly declaring table access at the package level. In practice, such variable packages typically encapsulate queries against procurement entities, but the ETRM record does not identify them, so no specific table list can be asserted.

Usage Notes

POA_EDW_VARIABLES_PKG is referenced by five other packages: the POABV_EDW_PO_DISTRIBUTIONS_FCV, POABV_EDW_SUPPLIER_PERFORM_FCV, POA_EDW_PO_DISTRIBUTIONS_FCV, POA_EDW_PO_DIST_F_C, and POA_EDW_SUPPLIER_PERFORM_FCV collection views and their generated code. This confirms it is invoked indirectly through the POA EDW fact collection layer rather than by end-user forms. It is typically executed within the Procurement and Spend Analytics ETL concurrent programs and any custom extraction routines that reuse the seeded POA views. Because it is an internal APPS-owned utility, it should not be called directly by customer extensions without validating compatibility across patch levels.