Search Results ar_upg_psa_dist_pkg




Overview
Explore in AI Chat

Overview

AR_UPG_PSA_DIST_PKG is an upgrade utility package owned by the APPS schema in Oracle E-Business Suite Receivables. Its name reflects its purpose: migrating distribution records associated with the deprecated Public Sector Applications (PSA) receivables model into the standard Oracle Receivables and Subledger Accounting (XLA) structures. The package header carries the revision tag $Header: ARPSAUPS.pls 120.0 2006/08/16, confirming that it was written as a one-time data conversion utility rather than a runtime business API. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling session, which is characteristic of upgrade and patch driver scripts run by the APPLSYS/APPS administrative account.

Because the procedures operate on batches of financial distribution rows, the package exists to preserve the accounting integrity of historical transactions after the upgrade, ensuring that adjustments, receipt applications, miscellaneous cash distributions, and transaction distributions are all relocated into the correct 11i/12.x tables and that the corresponding XLA accounting entries are generated or corrected.

Key Procedures and Functions

The documented package exposes four procedures, all sharing an identical upgrade-driver signature (table owner, table name, script name, worker id, number of workers, batch size, batch id, and action flag). This signature supports parallel, restartable execution coordinated by the AD upgrade driver.

Each procedure accepts the batch control parameters so that the upgrade driver can invoke them concurrently across multiple workers and resume from a given batch id, using the action flag to distinguish validation from execution modes.

Tables Accessed

The package reads from the PSA staging tables PSA_MF_TRX_DIST_ALL, PSA_MF_ADJ_DIST_ALL, PSA_MF_RCT_DIST_ALL, and PSA_MF_MISC_DIST_ALL, which hold the pre-upgrade distribution data. It writes to the standard Receivables distribution and transaction tables: AR_DISTRIBUTIONS_ALL, AR_DISTRIBUTIONS_S, AR_ADJUSTMENTS_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPT_HISTORY_ALL, AR_MISC_CASH_DISTRIBUTIONS_ALL, RA_CUSTOMER_TRX_ALL, and RA_CUST_TRX_LINE_GL_DIST_ALL. Accounting output is placed in the XLA tables XLA_AE_HEADERS and XLA_AE_LINES. All are accessed through APPS synonyms.

Usage Notes

AR_UPG_PSA_DIST_PKG is not an application-facing API and is not called from Receivables forms or standard concurrent programs. It is invoked by the Oracle Applications upgrade driver during a release upgrade, typically through a worker-based script that supplies the batch parameters. It is referenced by one other package, indicating a dependent upgrade utility in the same conversion chain. Custom code should not call this package outside of an upgrade context, as its logic assumes a transitional data state that does not exist in a steady-state 12.1.1 or 12.2.2 environment.