My Oracle Support Banner

Accounting Error: Reversed Receipts fails Accounting Program (XLAACCUP ) with error: The following REVERSAL events could not be processed (Doc ID 1073836.1)

Last updated on JULY 13, 2020

Applies to:

Oracle Receivables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
EXECUTABLE:ARACCPB - Submit Accounting
EXECUTABLE: XLAACCUP - Accounting Program
Report: ARXRECON.RDF - AR Reconciliation


Unable to close a period due to 2 unprocessed reversal receipts showing on XLAACCUP - Accounting Program log file.

Here is an example:

The following REVERSAL events could not be processed. The event/process status is U/U:
Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
Event 84731 of ledger 2021
Event 84430 of ledger 2021

Review of the problem receipts show the following:

  1. Receipt payment schedule shows actual_date_closed and gl_date_closed are incorrect for receipt
  2. Review of receipt shows reversal row in AR_CASH_RECEIPT_HISTORY_ALL.gl_date is less then the maximum application gl_date (AR_RECEIVABLE_APPLICATIONS_ALL.gl_date)
  3. Review of receipt shows reversal row in AR_CASH_RECEIPT_HISTORY_ALL.trx_date is less then the maximum application apply_date (AR_RECEIVABLE_APPLICATIONS_ALL.apply_date)
  4. Review of xla_events.EVENT_TYPE_CODE shows duplicate RECP_REVERSE  and one of the events is posted.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps
 5. Datafix

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.