Search Results adjustment_register

Overview

ARRX_C_ADJ is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Receivables. Its documented purpose is to implement the Adjustment Register report, a standard Oracle Receivables concurrent program that produces a listing of adjustments applied against transactions for a given period and reporting context. The package encapsulates the report's driver logic, accepting a large, fixed set of positional report parameters and returning the standard concurrent manager status values (errbuf and retcode). The internal header comment ($Header: ARRXCADB.pls 120.5 2005/10/30 04:25:19 appldev ship $) indicates the file has been stable since release 12.0, which explains its presence unchanged in both 12.1.1 and 12.2.2. The "ARRX" prefix follows the Receivables reporting convention, and the "C" designation denotes that this is a report implementation package.

Key Procedures and Functions

The ETRM metadata documents a single procedure:

• ADJUSTMENT_REGISTER — the entry point executed by the Receivables Adjustment Register concurrent program. It receives the concurrent manager's standard OUT parameters (errbuf and retcode) followed by roughly forty positional VARCHAR2 arguments that define the report's reporting level, reporting context, ledger (SOB) and chart of accounts identifiers, the balancing segment low/high range, GL date range, currency type range, adjustment date range, transaction due date range, transaction type range, adjustment type range, and document sequence name/number range. Two trailing arguments provide a debug flag and a SQL trace flag, both defaulting to 'N'. The remainder of the argument list is reserved with NULL defaults, providing forward compatibility for additional report parameters without changing the program's signature. The procedure is responsible for resolving these arguments, driving the report query, and returning success or failure to the concurrent manager.

Tables Accessed

The ETRM extract for this object does not enumerate the base tables referenced through APPS synonyms. Based on the report's functional scope, ARRX_C_ADJ reads adjustment and transaction data from the Receivables transactional tables — principally the adjustment, transaction, customer, and accounting distribution entities that supply adjustment numbers, dates, types, associated transaction identifiers, and GL distributions. The reporting-level, ledger, and chart-of-accounts parameters drive the organization and accounting flexfield filtering applied to those tables. Because the package is documented as a report implementation rather than as an API, its access is read-oriented; it is not classified as an interface or public API and does not perform transactional DML on behalf of callers. No packages are documented as referencing ARRX_C_ADJ, confirming that it is a leaf module invoked only by its concurrent program definition.

Usage Notes

ARRX_C_ADJ is normally invoked indirectly: the Adjustment Register concurrent program (registered in Receivables) supplies the parameter values collected from the submission form, and the concurrent manager calls ADJUSTMENT_REGISTER with errbuf and retcode. It is not intended for direct invocation from custom PL/SQL, and its API classification is OTHER, so it should not be treated as a supported programmatic interface. The debug and SQL trace arguments support diagnostics during report troubleshooting. Because all parameters are positional and untyped VARCHAR2 values, any direct call — which Oracle does not support — must observe the exact argument order documented above. The reserved trailing parameters default to NULL and should be left as such. Customizations should be directed at the underlying report definition rather than at modifying the package body, which is an Oracle-owned "ship" file subject to replacement during patching in both 12.1.1 and 12.2.2.