Search Results oracle_purchasing




Overview
Explore in AI Chat

Overview

PA_COMMITMENTS_V is an APPS-owned database view that is delivered as an override of the standard Projects commitment view of the same name. Within the JA (Asia/Pacific Localizations) product family, this view replaces the Projects version of PA_COMMITMENTS_V in order to include non-recoverable taxes in the commitment amounts presented to Oracle Projects, Oracle Purchasing, and Oracle Payables. Documented in ETRM for both 12.1.1 and 12.2.2, the object has a status of VALID and is implemented entirely in the APPS schema.

The view consolidates requisition, purchase order, and invoice commitment data into a single, horizontally structured result set. The ORACLE_PURCHASING literal embedded in the view definition identifies the source system for the requisition rows, while the accompanying column values describe the project, task, expenditure organization, vendor, and expenditure attributes associated with each commitment line. Its principal role is to provide a Projects-facing commitment feed whose amounts reflect the local tax treatment required for Asia/Pacific implementations.

Underlying Base Objects

The documented dependency list for this view spans both synonyms and PL/SQL packages. The data-oriented sources are PA_PROJ_REQ_DISTRIBUTIONS_V (requisition commitments), PA_PROJ_PO_DISTRIBUTIONS_V (purchase order commitments), PA_PROJ_AP_INV_DIST_V (invoice commitments), and the package-specific aliases CST_PROJMFG_CMT_VIEW, PA_PJM_PO_COMMITMENTS_TMP, and PA_PJM_REQ_COMMITMENTS_TMP. In the excerpted definition, the requisition branch is driven by PPRD (the requisition distribution view), exposing PROJECT_ID, TASK_ID, REQ_NUMBER, REQ_DISTRIBUTION_ID, REQUISITION_HEADER_ID, ITEM_DESCRIPTION, EXPENDITURE_ITEM_DATE, REQ_LINE, APPROVED_FLAG, NEED_BY_DATE, EXPENDITURE_ORGANIZATION_ID, VENDOR_ID, VENDOR_NAME, EXPENDITURE_TYPE, EXPENDITURE_CATEGORY, REVENUE_CATEGORY, UNIT, UNIT_PRICE, QUANTITY, and ACCT_EXCHANGE_RATE.

Functional behavior is supplied by several packages. JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT supplies the non-recoverable tax component, keyed by source system, distribution identifiers, currency indicator, unit, quantity, and accounting exchange rate; JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR supplies the functional currency flag. PA_BURDEN_CMTS.GET_CMT_COMPILED_SET_ID and PA_BURDEN_CMTS.GET_CMT_BURDENED_COST compute the burden compiled set and burdened cost for each commitment. The remaining documented packages — PA_CMT_UTILS, PA_FUNDS_CONTROL_UTILS, PA_MULTI_CURRENCY, PA_PJC_CWK_UTILS, and AP_INVOICES_PKG — support commitment utilities, funds control, currency conversion, and invoice processing logic invoked elsewhere in the complete view body.

Key Columns

  • PROJECT_ID / TASK_ID — Project and task identifiers used to tie each commitment to Projects structures.
  • Source identifiers — REQ_NUMBER, REQ_LINE, REQ_DISTRIBUTION_ID, and REQUISITION_HEADER_ID identify the originating requisition document and distribution.
  • EXPENDITURE_ITEM_DATE — Date used for commitment aging and burden calculation, and passed into the burden and tax routines.
  • EXPENDITURE_ORGANIZATION_ID / EXPENDITURE_TYPE — Determine the applicable burden schedule and costing treatment.
  • VENDOR_ID / VENDOR_NAME — Supplier against whom the commitment is held.
  • AMOUNT — The commitment amount, computed as PPRD.AMOUNT plus the non-recoverable tax returned by JAI_PA_COSTING_PKG.GET_NONREC_TAX_AMOUNT; this is the defining enhancement of the override.
  • Burdened cost — Returned by PA_BURDEN_CMTS.GET_CMT_BURDENED_COST, applying the same tax-inclusive base amount.
  • UNIT / UNIT_PRICE / QUANTITY — Quantity and pricing attributes of the distribution line.
  • Currency indicator — Derived from JAI_PA_COSTING_PKG.GET_FUNC_CURR_INDICATOR, distinguishing functional from foreign currency treatment.

Common Use Cases and Queries

Typical uses include project commitment reporting, funds checking, and reconciliation of commitment balances where non-recoverable tax must be recognized. DBAs also query the view definition to investigate differences between the localized and standard versions.

To inspect requisition-sourced commitments for a project:

  • SELECT project_id, task_id, req_number, vendor_name, expenditure_type, amount, quantity
  • FROM apps.pa_commitments_v
  • WHERE project_id = :p_project_id;

To total tax-inclusive commitment amounts by expenditure type, aggregate the AMOUNT column directly, since the non-recoverable tax is already embedded. To compare the localized view against the standard Projects definition, query DBA_VIEWS or DBA_DEPENDENCIES for the APPS.PA_COMMITMENTS_V object and review the referenced packages, particularly JAI_PA_COSTING_PKG and PA_BURDEN_CMTS.