Troubleshooting Account Generator Errors in 11i and R12 Receivables (Doc ID 264766.1)

Last updated on OCTOBER 21, 2016

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.
Form:ARXTWMAI.FMB - Transactions
Form:ARXRWMAI.FMB - Receipts


Symptoms

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:

  1. 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.

  2. 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

 

Cause

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