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.