Adjustments Issue: Unable To Approve Tax Adjustments For Invoices
(Doc ID 1969831.1)
Last updated on OCTOBER 04, 2022
Applies to:
Oracle Receivables - Version 12.1.3 and later Information in this document applies to any platform.
Symptoms
On : 12.1.3 version, Transactions Related
Unable to Approve Adjustments for invoices. This only happens when the line balance is adjusted to zero and only the tax amount is left.
ERROR ---------------------- APP-AR-11526: arp_process_adjustment.update_adjustment exception ORA-20001: Adjustment cannot be more than available invoiced line amount
Steps to Reproduce: 1. Create an invoice with 3 lines and location based tax. Line Amount Tax Amount Line 1 1500 75 Line 2 225 11.255 Line 3 400 20
2. Login with user having no Adjustment Approval Limits 3. Create an adjustment for line1 for -1500. 4. Create an adjustment for Tax, line1 for -75.
5. Login with user having Adjustment Approval Limits
Responsibility: Receivables Manager Navigation: Control > Adjustments > Approve Adjustments
Approve the line adjustment first. Now approve the tax adjustment. System throws error
Business Users are not able to approve tax adjustments that are in Waiting for Approval Status.
WORKAROUNDS =========== If the users are set with approval limits, then the adjustments are created in approved status without any issue. This happens only when the user does not have approval limit and creates the adjustment in Waiting for Approval Status and later another user with approval limits try to approve the adjustment.
Changes
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!