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 29, 2020
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!