Receipts Workbench Issue: Automatic Receipt Batch Creating Unapp Receipt With -1 Appended To Receipt Number (Doc ID 1516106.1)

Last updated on FEBRUARY 09, 2016

Applies to:

Oracle Receivables - Version 12 to 12.0.7 [Release 12.0]
Information in this document applies to any platform.

Symptoms

1. Automatic receipt batch creating unapp receipt with -1 appended to receipt number
    a. Duplicate entity row in xla_transaciton_entity
    b. Extra row has -1 at the end of the transation_number
    c. Transaction Number in ar_payment_schedules_all has -1 at end of number
    d. Receipt number in header record does not have -1 at the end of the number.

2. Due to code <Bug 8619287> REW: ROOTCAUSE: REC CREATED WITH -1 APPENDED TO RECEIPT# AND RCT IS UNAPP STATUS, some receipts were created in UNAPP state and not applied to the invoice.
While trying to fix the original unapplied receipts, run another autoreceipt process and duplicate receipts were created and closed out the invoices.

Because of this, not able to reverse the receipts, because no event is created for these receipts in SLA.

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