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

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Nav=>Transactions=>Transactions
Query or Enter an invoice, Save and Complete.
Actions=>Adjust

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.

Cause

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