Search Results p_adjusted

Overview

PA_EFC_BIL is a PL/SQL package body owned by the APPS schema in Oracle EBS 12.1.1 and 12.2.2. It belongs to the Oracle Projects (PA) module and supports the processing of project billing and revenue data within the EFC (Enterprise Funding and Costing) and multicurrency billing context. The package encapsulates logic for reconciling funded, billed, accrued, and adjusted revenue amounts at the project, task, and agreement level. Its primary role is to compute summary amounts used by revenue and invoice generation flows, particularly where funding records across baselines, drafts, and multicurrency customer revenue distributions must be evaluated together.

The API classification recorded for this package is OTHER, indicating that it is an internal utility package rather than a public, externally supported API. It is not referenced by any other documented packages, suggesting it is invoked directly by higher-level billing or revenue programs, or by custom extensions, rather than serving as a shared dependency across the application.

Key Procedures and Functions

The package exposes four documented procedures:

• GET_B_UB_REV_INV_AMTS — Retrieves baselined and unbaselined amounts, billed amounts, and accrued revenue amounts for a given project, task, and agreement. As shown in the source excerpt, it queries funding records to derive baseline and draft totals and computes accrued revenue from draft revenue items. It also exposes an adjusted amount output that reflects the difference between billed and accrued revenue; the internal variable pl_adjusted corresponds to the p_adjust_amt output parameter. The presence of p_adjusted in searches reflects the naming convention used for the adjusted amount output in this procedure.
• UPDATE_ADJUSTED_AMOUNT — Persists or recalculates the adjusted amount derived from billing and revenue comparisons, ensuring that the stored adjusted value remains consistent with the underlying funding and revenue records.
• SUM_MC_CUST_RDL_ERDL — Aggregates multicurrency customer revenue distribution line (RDL) and estimated revenue distribution line (ERDL) amounts for billing and reporting purposes.
• SUM_MC_CUST_RDL_ERDL2 — A variant of the multicurrency aggregation routine, providing an alternate summation path (for example, across a different grouping of customer, project, or agreement dimensions).

Tables Accessed

The package reads and writes the following documented tables, all accessed through APPS synonyms:

• PA_PROJECT_FUNDINGS — Source of baseline and draft funding amounts, grouped by budget type code.
• PA_PROJECT_FUNDINGS_EFC and PA_SUMMARY_PROJ_FUNDINGS_EFC — Used for funded and summary funding values in the EFC context.
• PA_DRAFT_REVENUES_ALL and PA_DRAFT_REVENUE_ITEMS — Supply accrued revenue amounts used to compute adjusted values.
• PA_DRAFT_INVOICES_ALL and PA_DRAFT_INVOICE_ITEMS — Supply billed amounts for reconciliation against revenue and funding.

Usage Notes

PA_EFC_BIL is typically invoked during project billing and revenue adjustment processing, including concurrent programs that generate draft invoices and draft revenue, and is commonly called from custom PL/SQL extensions that require baseline versus unbaselined funding comparisons for a project, task, and agreement combination. Because it is classified as OTHER and is not referenced by other documented packages, implementers should treat it as an internal, unsupported routine. Direct calls should be validated against the target 12.1.1 or 12.2.2 patch level, since the header version (120.2.12020000.2, dated 2012) reflects maintenance delivered through the 12.2 code line. The adjusted amount output, referenced in practice as p_adjusted, is central to reconciliation between billed and accrued revenue and should be consumed with attention to the revenue limit flag that governs how amounts are constrained.