Search Results pa_process_rev_adj

Overview

PA_BILLING_PROCESS_PKG is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Projects (PA) billing family of programs and is classified by ETRM as an "OTHER" API rather than a formally published open interface. Its functional purpose is to drive the generation of revenue adjustments and draft revenue for project billing. Specifically, the package supports the mass processing of revenue and adjustment records across a range of projects, serving as the procedural engine behind the concurrent billing and revenue generation logic in Oracle Projects.

The package exposes a single documented procedure, PA_PROCESS_REV_ADJ, which consolidates the revenue processing and adjustment workload into one callable entry point. The package header also declares two package-level globals: PA_DEBUG_MODE, initialized from the PA_DEBUG_MODE profile option (defaulting to 'N'), and G_REQUEST_ID, initialized from fnd_global.conc_request_id. These globals indicate the package is designed to run in a concurrent-program context and to emit diagnostic output when debugging is enabled.

Key Procedures and Functions

The ETRM metadata documents one procedure: PA_PROCESS_REV_ADJ. Its declared purpose is to process revenue and revenue adjustments for projects. The procedure accepts a project identifier together with a from-project and to-project range, a mass-generation indicator, and an accounting-through date. This signature shows the procedure supports both single-project and range-based (mass) processing, and that it respects an accounting cut-off date that bounds which transactions are eligible for revenue recognition or adjustment.

The mass-generation flag distinguishes on-demand, single-project processing from batch processing across a defined project range, allowing the same code path to be reused by different concurrent program modes. The accounting-through date parameter ensures that only expenditures, events, and funding data up to that date are considered, which is consistent with Oracle Projects' period-based revenue recognition model. No other procedures or functions are documented in the metadata, and callers should treat PA_PROCESS_REV_ADJ as the sole supported entry point.

Tables Accessed

The package reads and writes a broad set of Oracle Projects billing, revenue, and project-definition tables through APPS synonyms. Revenue and draft revenue persistence is handled through PA_DRAFT_REVENUES and the distribution tables PA_CUST_REV_DIST_LINES and PA_CUST_EVENT_REV_DIST_LINES, which store customer revenue distributions and event-based revenue distributions respectively. Billing configuration is drawn from PA_BILLING_ASSIGNMENTS and PA_BILLING_EXTENSIONS, which define how projects and tasks are billed and any extension attributes used during processing.

Source transactions and events are read from PA_EVENTS and PA_EXPENDITURE_ITEMS / PA_EXPENDITURE_ITEMS_ALL, providing the billable and revenue-generating detail. Project and task context comes from PA_PROJECTS, PA_PROJECTS_ALL, PA_PROJECT_TYPES, and PA_TASKS. Funding information is retrieved from PA_SUMMARY_PROJECT_FUNDINGS, which is essential for determining revenue limits and funding-driven adjustments. DUAL is referenced for simple scalar evaluations.

Usage Notes

PA_BILLING_PROCESS_PKG is typically invoked indirectly through Oracle Projects concurrent programs and billing-related forms rather than called directly by end users. Custom code should call PA_PROCESS_REV_ADJ only when replicating standard revenue-generation behavior, and should respect the accounting-through date to avoid recognizing revenue in the wrong period. Because the package relies on fnd_global.conc_request_id and the PA_DEBUG_MODE profile, it is intended for concurrent execution; direct invocation from a form may not populate these globals correctly. The metadata records no dependent packages referencing this package, so it should be treated as a lower-level internal utility rather than a public integration API.