My Oracle Support Banner

Transactions Workbench Issue: AR_RECEIPT_API_PUB.APPLY_IN_DETAIL Populates Balances Incorrectly When a Receipt is Applied to an Invoice with a Line Level Adjustment (Doc ID 1903952.1)

Last updated on JULY 19, 2019

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.


The AR_RECEIPT_API_PUB.Apply_In_Detail API populates balances incorrectly, when a Receipt is applied to an Invoice with line level adjustment.
The Invoice is created in R12 and not an upgraded Invoice.

Steps to Reproduce:
1. Batch Source is created without Generate Line Level Flag.
2. Create an Invoice for 550, with 2 lines, and do a -100 line level adjustment.
3. Create an Invoice for 400, with 1 lines, and do a -100 line level adjustment.
4. Create a Receipt for 1000.
5. Use AR_RECEIPT_API_PUB.Apply_In_Detail and apply to these 2 Invoices using a loop.
6. See that the Line Level Balances are incorrect in ra_customer_trx_lines_all.

Where as if the similar is done from the front end (UI), then the balances are stamped correctly.
1) Invoice is created for 550$
2) Create an adjustment for -100$ against this document at Summary Level.
3) Creat a receipt, and applied the receipt for $2 against the invoice using the UI, then the line level balance is stamped correctly.




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
 5. Identify Possible Data Corruption
 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.