Search Results pa_adjustments




Overview
Explore in AI Chat

Overview

PA_ADJUSTMENTS is a core Oracle Projects PL/SQL package owned by the APPS schema. It encapsulates the business logic that governs expenditure adjustment processing within Oracle E-Business Suite, providing the application programming interface through which raw cost items, burdened cost items, and related transaction components are adjusted, reversed, reclassified, split, or transferred. The package serves as the central mechanism for maintaining the integrity of project expenditure data whenever a transaction must be corrected after it has been distributed and accounted. It is classified under the API classification OTHER, indicating that it functions primarily as an internal engine rather than a formally published public API, although it is invoked extensively by other Oracle Projects components.

The status of the package is VALID in both release 12.1.1 and 12.2.2, and its documentation identifies 41 procedures and functions. Because the package coordinates cost recalculation, audit trail creation, and relationship between original and reversing items, it is fundamental to the accuracy of project cost reporting, invoicing, and capitalization.

Key Procedures and Functions

The documented procedures fall into several functional groups:

  • Validation and audit: CHECKSTATUS, VERIFYORIGITEM, COMMENTCHANGE, and INSAUDITREC support verification of an item's eligibility for adjustment and capture an audit record of the change, preserving the adjustment history.
  • Cost recalculation: RECALCREV, RECALCCOSTREV, RECALCRAWCOST, RECALCINDCOST, and RECALCCAPCOST recalculate the various cost layers — raw cost, burdened or indirect cost, and capitalized cost — following an adjustment or reversal.
  • Reversal and backout: BACKOUTITEM, BACKOUTMRCITEM, and REVERSERELATEDITEMS reverse a posted item and any related items, returning the expenditure to a pre-distribution state.
  • Item manipulation: SETNETZERO, HOLD, RECLASS, SPLIT, TRANSFER, and ADJUST perform the substantive adjustments, including reclassification between expenditure types, splitting or transferring amounts between tasks or projects, and placing items on hold.
  • Invoice-related logic: GETINVID and INVSTATUS retrieve the associated invoice and its status for supplier cost adjustments.

Tables Accessed

The package reads and writes through APPS synonyms against several transactional tables. PA_EXPENDITURE_ITEMS_ALL is the primary table manipulated, holding the expenditure items being adjusted. AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICES_ALL, AP_INVOICES, AP_INVOICE_DISTRIBUTIONS, AP_CHECKS_ALL, AP_INVOICE_PAYMENTS_ALL, AP_SELF_ASSESSED_TAX_DIST_ALL, and AP_SYSTEM_PARAMETERS provide supplier cost, payment, and tax context. PA_COST_DISTRIBUTION_LINES and PA_COST_DISTRIBUTION_LINES_ALL store the resulting distribution lines, while GMS_AWARDS_ALL, PA_BILL_RATES_ALL, and PA_COMPENSATION_RULE_SETS supply award, billing, and compensation rule information. CE_BANK_ACCOUNTS supports payment-related processing. PA_UTILS is referenced for shared utility routines.

Usage Notes

PA_ADJUSTMENTS is referenced by 15 other packages, including PA_EXPENDITURE_ITEMS_PKG, PA_TRANSACTIONS, PA_TRX_IMPORT, PA_COST_PLUS, PA_CALC_OVERTIME, PA_EXP_COPY, PA_INVOICE_ACTIONS, PA_TASK_UTILS, PA_MU_BATCHES_V_PKG, PA_PROJECTS_MAINT_PVT, PA_NL_INSTALLED, and the Grants Management packages GMS_ENCUMBRANCE_ITEMS_PKG and GMS_ENC_ADJUSTMENTS. It is therefore invoked indirectly from Oracle Projects forms, concurrent programs such as expenditure processing and adjustment runs, and custom extensions. Because it is API-classified as OTHER, direct calls from custom code should be undertaken only with caution and full understanding of its internal dependencies.