Search Results ar_unposted_item_upg




Overview
Explore in AI Chat

Overview

AR_UNPOSTED_ITEM_UPG is a PL/SQL upgrade package owned by the APPS schema in Oracle E-Business Suite Receivables. Its purpose is to perform one-time data migration and remediation during an upgrade into an Oracle EBS 11i-to-12.x release path, specifically targeting unposted (unposted and/or cash-basis) transaction data that could not be carried forward cleanly by standard upgrade scripts. The package is classified under the "OTHER" API category, meaning it is not a public, callable business API but an internal upgrade utility. In EBS 12.1.1 and 12.2.2 it retains a VALID status in the data dictionary, but it is not intended for ongoing transactional use.

The package addresses the accounting conversion challenge introduced when moving to the 11i/12.x cash-basis accounting model. Under the pre-upgrade model, Receivables could hold receivable items and credit memos whose cash-basis accounting entries had not yet been generated. During the upgrade, the new subledger accounting (SLA) and distribution structures require these open items to be re-evaluated and their distribution amounts populated so that future posting, and cash receipt application, produce correct accounting. AR_UNPOSTED_ITEM_UPG performs that re-evaluation.

Key Procedures and Functions

  • UPGRADE_11I_CASH_BASIS — Upgrades pre-existing cash-basis accounting for unposted receivable items. It identifies affected transactions and generates or repairs the base distribution amounts required by the new cash-basis model, ensuring that items that were unposted at the time of upgrade have consistent accounting before further processing.
  • UPGRADE_11I_CM_CASH_BASIS — Performs the equivalent conversion for credit memos. Credit memos follow a distinct accounting flow from standard invoices, so a separate routine reconciles cash-basis distributions for credit memo transactions that were unposted prior to the upgrade.

Both routines operate on data already staged by the upgrade process and rely on the global temporary tables (RA_AR_GT, AR_BASE_DIST_AMTS_GT) to hold working sets during execution. Neither procedure is designed to be re-run repeatedly against live production data.

Tables Accessed

The package reads and writes the core Receivables transaction and accounting tables, including RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL, and AR_RECEIVABLE_APPLICATIONS / AR_RECEIVABLE_APPLICATIONS_ALL, to locate the unposted items and their applications. Accounting data is managed through AR_DISTRIBUTIONS_ALL, RA_CUST_TRX_LINE_GL_DIST_ALL, and the temporary base-distribution table AR_BASE_DIST_AMTS_GT. Adjustment data is handled via AR_ADJUSTMENTS_ALL. Setup and reference data are read from AR_SYSTEM_PARAMETERS / AR_SYSTEM_PARAMETERS_ALL, FND_CURRENCIES, and PSA_TRX_TYPES_ALL. The upgrade also references DBMS_SQL for dynamic processing and PLITBLM, the standard EBS PL/SQL table-index utility.

Usage Notes

AR_UNPOSTED_ITEM_UPG is invoked by the Oracle Receivables upgrade driver during the 11i-to-12.x upgrade, not by end-user forms or by custom application code. It is referenced by no other package and is not a candidate for incorporation into custom extensions. Because the procedures modify accounting distributions in place, they should never be executed manually against production data outside the supported upgrade run. In 12.1.1 and 12.2.2 the package remains VALID and available for support-driven re-execution should an upgrade anomaly be identified, but the supported approach is to route such cases through Oracle Support or the relevant Receivables upgrade patches.