Adjustments Issue: Unable To Approve Tax Adjustments For Invoices
Last updated on AUGUST 25, 2017
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
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.
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.
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.
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 hundreds of Community platforms