My Oracle Support Banner

Transactions Workbench: Line Level Adjustment On Invoice Causing Incorrect Line Level Balances (Doc ID 1391125.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.
Form:ARXTWMAI.FMB - Transactions


Query or Enter an invoice, Save and Complete.

Create a line level adjustment for a specific transaction line, allocates the adjustment amount incorrectly to all the lines instead of the specified line.  This happens only when the adjustment is created with status 'Waiting for Approval' ie. adjustment amount is outside approval limits and then approved later by another user.

Line level balances are correct if the adjustment is created with status 'Approved' ie. adjustment amount is with in the limits.

Steps to Reproduce:

Transaction Source setup:
Source: Manual-Consult
Generate Line Level Balances = Y

1.Created invoice# 505274 with 2 lines, 100$ and 200$
2.Created line level adjustment for Line#1 for $25.00 with status 'Waiting
for approval'.
3.Then approve the adjustment by logging as as another user.

Line level balances in ra_customer_trx_lines_all shows :

amount_due_original amount_due_remaining acctd_amount_due_remaining
100                          108.33                          108.33
200                          216.67                          216.67

Line level adjustment is prorating adjustment amount to both the lines instead of
applying to Line 1. Expectation is that the adjustment amount should be applied against
Line#1 and not all the lines.


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.