My Oracle Support Banner

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 APRIL 30, 2024

Applies to:

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


 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'




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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