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 MAY 15, 2018

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!

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