Error while Applying Adjustment /Credits to a Transaction APP-AR-11526: arp_process_adjustment.insert exception ORA-20001 (Doc ID 2664589.1)

Last updated on NOVEMBER 11, 2021

Applies to:

Oracle Receivables - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

1. Using the Approval Limits form, create approval limits for your user for an
adjustment type.
(R) Setup->Transactions->Approval limits

2. Create or find an activity type of adjustment where the GL Account source
is set to Activity GL ACCOUNT.
In this case, when you create the adjustment, it will use the account defined
on the receivables activity and not the revenue that was on the invoice.
(R) Setup->Receipts->Receivables Activity

3. Create an invoice with in-advance invoicing (or in arrears) and accounting
rule like 3 month rule.
Save and complete the Transactions.

4. Reopen the Transaction form and Query your Transaction.
Actions->adjust. Create adjustment using the previous activity (GL Account)
You will get the errror 'Error: APP-AR-11526: arp_process_adjustment.insert exception ORA-20001: You cannot enter an adjustment against this transaction because it has a balance of unearned revenue. Use the revenue accounting feature to earn that revenue and then process with your adjustment'