Search Results pa_costing




Overview
Explore in AI Chat

Overview

PA_COSTING is a core Oracle Projects PL/SQL package owned by the APPS schema. It encapsulates the logic responsible for creating, adjusting, and reversing cost distribution lines (CDLs) generated from project expenditures. In Oracle EBS 12.1.1 and 12.2.2, cost distribution lines represent the accounting rows that map a project expenditure item to the General Ledger via Subledger Accounting (XLA). PA_COSTING exists to centralize the generation and reversal of these CDL records so that expenditure processing, adjustments, and external transaction imports all produce consistent accounting lines.

The package is classified as an internal Projects utility rather than a public, fully documented API. Its status is VALID in ETRM, and it is referenced by eight other application packages, including PA_ADJUSTMENTS, PA_EXP_COPY, PA_NL_INSTALLED, PA_TRANSACTIONS, PA_UTILS2, and PA_XLA_SWEEP_TXN_PKG. This dependency footprint confirms its role as a low-level building block invoked by higher-level expenditure and adjustment flows.

Key Procedures and Functions

  • CREATENEWCDL — Creates a new cost distribution line for an expenditure item. It is the primary routine called when new project costs must be staged for accounting.
  • CREATEEXTERNALCDL — Builds cost distribution lines for externally sourced transactions, supporting integration scenarios where costs originate outside standard Projects processing.
  • CREATEREVERSECDL — Generates the reversing cost distribution line used to negate a previously generated CDL, typically during adjustment or reversal processing.
  • REVERSECDL — Executes the reversal of an existing cost distribution line, ensuring the original accounting entry is offset correctly.
  • IS_ACCOUNTED — A function that determines whether a given cost distribution line or expenditure item has already been accounted, used to prevent duplicate accounting entries.

These five documented routines together cover the create, reverse, and status-check lifecycle for cost distribution lines.

Tables Accessed

PA_COSTING reads and writes through APPS synonyms to the following tables:

The dependency list also references SYS and STANDARD, which are typical of compiled PL/SQL packages.

Usage Notes

PA_COSTING is not intended for direct invocation by end users or standalone customizations. It is invoked indirectly by standard Oracle Projects processes, including expenditure processing, adjustment generation (PA_ADJUSTMENTS), external cost import (PA_EXP_COPY), and the XLA sweep utility (PA_XLA_SWEEP_TXN_PKG). In 12.1.1 and 12.2.2, the subledger accounting flow relies on PA_COSTING routines to prepare what XLA ultimately posts to GL. Custom extensions should call the supported public APIs rather than PA_COSTING directly, since its signature and behavior are not guaranteed across patches. Developers investigating missing or duplicate accounting entries commonly inspect this package’s logic, as it governs whether a CDL is created or recognized as already accounted.