Search Results rev_upg_ad_par




Overview
Explore in AI Chat

Overview

PA_BILL_REV_XLA_UPGRADE is an Oracle EBS upgrade utility package owned by the APPS schema. Its purpose is to migrate pre-existing billing and revenue accounting transactions into the subledger accounting model introduced with the XLA (Subledger Accounting) architecture. Prior to Release 12, event and distribution data for Projects billing and revenue was stored in legacy tables that did not carry the full accounting representation required by the new accounting engine. This package performs the batch conversion of that historical data so that upgraded Projects transactions can be represented uniformly in the XLA data model.

The package is an upgrade-only object. It is not part of normal runtime business processing; it is executed once, during the Release 12 upgrade cycle, to populate transaction and distribution records that predate the subledger accounting cutover. Its procedures are structured around parallel worker processing, indicating that it was designed to be driven by the AD parallel upgrade driver against large transaction volumes.

Key Procedures and Functions

  • GL_IMP_UPG_AD_PAR — An AD-parallel coordinator entry point for converting general ledger import reference data associated with Projects billing and revenue. It accepts worker-partitioning parameters that allow the upgrade to divide work across concurrent workers.
  • REV_UPG_AD_PAR — The parallel driver for the revenue and billing upgrade path. It establishes the worker context and invokes the actual row-level upgrade logic over the assigned transaction range.
  • UPGRADE_TRANSACTIONS — The core row-range upgrade routine. It receives start and end ROWID boundaries plus a batch identifier, and returns the number of rows processed, forming the unit of work executed by each parallel worker.
  • REV_UPG_MC_AD_PAR — The parallel driver for the multi-currency variant of the revenue upgrade. It mirrors REV_UPG_AD_PAR but targets multi-currency customer revenue distributions.
  • UPGRADE_MC_TRANSACTIONS — The multi-currency counterpart to UPGRADE_TRANSACTIONS, processing the assigned ROWID range of multi-currency transactions and returning the row count processed.
  • CON_UPGRADE_TRANSACTIONS — The concurrent-program-callable entry point. As noted in the source header, it is called from a concurrent program and serves as the externally invocable driver for the upgrade.

Tables Accessed

The package reads and writes several groups of tables. Legacy billing and revenue sources include PA_CUST_REV_DIST_LINES_ALL, PA_DRAFT_REVENUES_ALL, PA_CUST_EVENT_RDL_ALL, PA_EVENTS, PA_EVENT_TYPES, and PA_REV_AE_LINES_TMP, which hold customer revenue distributions, draft revenue, event, and revenue accounting entry staging data. Multi-currency equivalents accessed include PA_MC_CUST_RDL_ALL, PA_MC_CUST_EVENT_RDL_ALL, and PA_MC_DRAFT_REVS_ALL.

Project and organizational context is obtained from PA_PROJECTS_ALL, HR_ORGANIZATION_INFORMATION, and PA_IMPLEMENTATIONS_ALL, the latter supplying implementation-level accounting configuration. General ledger integration data is read from GL_IMPORT_REFERENCES and GL_JE_HEADERS to associate upgraded transactions with their journal references. PA_PRIM_REP_LEGER_TMP serves as a temporary staging table for primary reporting ledger information used during conversion.

Usage Notes

PA_BILL_REV_XLA_UPGRADE is invoked during the Release 12 upgrade process rather than in day-to-day operation. The primary external entry point is CON_UPGRADE_TRANSACTIONS, which is exposed through a concurrent program; the remaining procedures are called by the AD parallel upgrade driver and by worker processes spawned during the upgrade. In EBS 12.1.1 and 12.2.2 the package exists in the APPS schema for upgrade support and is not referenced by other packages. Custom code should not call these procedures outside an upgrade context, because they assume a consistent migration state and operate on legacy data structures that are otherwise superseded.