My Oracle Support Banner

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

Last updated on APRIL 02, 2019

Applies to:

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


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.


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 Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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