Troubleshooting Account Generator Errors in 11i and R12 Receivables
Last updated on OCTOBER 21, 2016
Applies to:Oracle Receivables - Version 126.96.36.199 and later
Information in this document applies to any platform.
Form:ARXTWMAI.FMB - Transactions
Form:ARXRWMAI.FMB - Receipts
Account Generator fails, in the Transactions or Receipts workbench. Failure can occur while creating Manual transactions/receipts or whether using Invoice/Receipt API or automated processes such as AutoInvoice and AutoLockbox.
Following are some examples of errors:
- While creating an Adjustment against a transaction:
APP-AR-11526: arp_process_adjustment.insert_adjustment exception: ORA-20001: Account Generator is unable to derive information for one of more of the following accounts: COA: 101, Orig CCID: 3158, Sub CCID: 1093. Please contact your system administrator.
- While applying a Receipt, the following show 3 distinct sample errors:
APP-AR-96024: Account Generator is unable to derive information for one or more of the following accounts: COA: 50249; ORIG CCID:1040; SUB CCID: 1064.
ARP_PROCESS_APPLICATION.RECEIPT_APPLICATION ORA-20001: Account Generator is unable to derive information for one or more of the following accounts: COA: 50249; Orig CCID:1040; Sub CCID: 1332. Please contact your system administrator.
FRM-40734: Internal Error: PL/SQL error occurred when writing off receipt balance in application screen.
DEBUG file shows: reverse_action: EXCEPTION: arp_process_application.activity_application
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