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 24, 2017

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:XLAACCPB - Create Accounting
EXECUTABLE:ARACCPB - Submit Accounting
EXECUTABLE: XLAACCUP - Accounting Program
Report: ARXRECON.RDF - AR Reconciliation


Symptoms

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms