Search Results insert_reverse_actions

Overview

ARP_PROCESS_ADJUSTMENT is an internal PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its primary business function is to process and persist adjustments applied to Oracle Receivables transactions and their associated payment schedules. Adjustments in Receivables represent reductions or increases to an open receivable balance that are not themselves payments — for example, write-offs, credit memo reclassations, discounts, or promotional allowances. Rather than performing these mutations through direct table manipulation, the Oracle Receivables application logic routes them through this package so that approval controls, accounting distributions, activity tracking, and cover (chargeback-related) processing remain consistent with the stated accounting model.

The package is classified under the ETRM metadata as API classification "OTHER," indicating that while it exposes program units, it is not intended as a fully supported public interface. It functions as a core internal processing engine that other Receivables packages build upon. It is recorded as VALID in the APPS schema and may be shipped with a wrapped or obfuscated package body ("show dependent code" behavior in ETRM).

Key Procedures and Functions

The documented ETRM metadata lists eight program units within this package:

• INSERT_ADJUSTMENT — Creates a new adjustment record against an eligible transaction or payment schedule, applying the calculated adjustment amount and any associated approval or distribution logic.
• UPDATE_ADJUSTMENT — Modifies an existing adjustment, typically before it has been approved or posted to accounting.
• UPDATE_APPROVE_ADJ — Handles adjustment approval, updating the adjustment's authorization state and recording the reviewer action where approval limits apply.
• TEST_ADJ — A validation routine that checks whether a proposed adjustment is permissible given the current state of the transaction, its payment schedule, and any system parameters.
• REVERSE_ADJUSTMENT — Reverses a previously applied adjustment, restoring the affected receivable balance to its prior state and generating the corresponding reversing accounting entries.
• INSERT_REVERSE_ACTIONS — Records the activity or action history entries associated with a reversal, preserving an audit trail on AR_ACTIVITY_DETAILS.
• VALIDATE_INV_LINE_AMOUNT_COVER — Validates the invoice line-level amount that can be covered by an adjustment, supporting covered receivables and chargeback scenarios.
• CAL_PRORATED_AMOUNTS — Calculates prorated adjustment amounts, distributing an adjustment across lines, distributions, or schedules proportionally.

Parameter lists are intentionally not published in the ETRM excerpt and are not reconstructed here.

Tables Accessed

The package operates against a broad set of Receivables and Oracle general ledger reference tables (via APPS synonyms):

• AR_ADJUSTMENTS — The primary target table holding the adjustment rows that this package inserts, updates, and reverses.
• AR_PAYMENT_SCHEDULES — The schedule-level view of the receivable balance that must remain synchronized with each adjustment.
• AR_ACTIVITY_DETAILS / AR_ACTIVITY_DETAILS_S — Store the activity audit records produced when adjustments or reversals occur.
• AR_APPROVAL_ACTION_HISTORY / AR_APPROVAL_USER_LIMITS — Support the approval workflow invoked by UPDATE_APPROVE_ADJ.
• AR_DISTRIBUTIONS, AR_RECEIVABLE_APPLICATIONS, AR_REC_TRX_LE_DETAILS, AR_RECEIVABLES_TRX — Govern the subledger accounting lines and receivable transaction types generated by adjustments.
• AR_SYSTEM_PARAMETERS, AR_LOOKUPS, AR_VAT_TAX, FND_CURRENCIES, GL_PERIOD_STATUSES — Provide configuration, reference, tax, currency, and period-open status checks.
• OZF_CLAIMS — Links adjustments to claims/deductions processing.

Usage Notes

ARP_PROCESS_ADJUSTMENT is not called directly by end users. It is invoked by higher-level Receivables packages, including ARP_INSERT_ADJ_COVER, ARP_UPDATE_ADJ_COVER, ARP_PROCESS_APPLICATION, ARP_PROCESS_CHARGEBACK, AR_ADJUST_PUB, AR_ADJUSTAPI_PUB, and AR_ADJVALIDATE_PVT. The Receivables Adjustments form and adjustment-related concurrent programs ultimately reach it through these entry points, and Oracle Payables/Receivables integration flows for chargebacks and claims pass through it as well. Custom code should preferentially call the public APIs (AR_ADJUST_PUB / AR_ADJUSTAPI_PUB) rather than this internal package, since it is subject to change and its signature is not committed as a supported interface.