AutoInvoicing Failing with Credits Process When a Receipt Needs to be Reversed (Doc ID 2014747.1)

Last updated on OCTOBER 19, 2016

Applies to:

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

Symptoms

AutoInvoicing fails with the following error, when a credit is processed, where a receipt will be reversed.

APP-AR-11526: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line
begin arp_process_returns . process_application_list ; EXCEPTION WHEN !
APP-AR-11526: 5069629/ar/src/autoinv/raacsa.lpc 101

Error in FND log:

ar.plsql.get_doc_seq .begin get_doc_seq ()+
ar.plsql.get_doc_seq get_doc_seq: SEQ : N
ar.plsql.get_doc_seq get_doc_seq: p_document_name :CWI Credit Card
ar.plsql.get_doc_seq get_doc_seq: p_application_id :222
ar.plsql.get_doc_seq get_doc_seq: p_sob_id :2021
ar.plsql.get_doc_seq .begin get_doc_seq ()+
ar.plsql.get_doc_seq create_misc: Receipt Number is null
ar.plsql.get_doc_seq create_misc: Error(s) occurred. Rolling back and setting status to ERROR
ar.plsql.get_doc_seq API error count 1
ar.plsql.get_doc_seq Please enter a receipt number.
ar.plsql.get_doc_seq API EXCEPTION: arp_process_application.activity_application(misc_receipt creation))User-Defined Exception
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log APP-AR-294140: Please enter a receipt number.
ar.plsql.get_doc_seq EXCEPTION: arp_process_application.activity_application
ar.plsql.arp_legal_entity_util.Is_LE_Subscriber ActivityApp: ARP_PROCESS_APPLICATION.ACTIVITY_APPLICATION : ORA-20001: APP-AR-294140: Please enter a receipt number.
ar.plsql.arp_legal_entity_util.Is_LE_Subscriber ActivityApp failed
ar.plsql.arp_legal_entity_util.Is_LE_Subscriber EXCEPTION : arp_process_returns.process_application_list : User-Defined Exception
ar.plsql.raacsa raacsa(): arp_process_returns.process_application_listUser-Defined Exception
ar.plsql.arp_etax_util.global_document_update.begin arp_etax_util.global_document_update()+
ar.plsql.arp_etax_util.global_document_update trx_id = 68233
ar.plsql.arp_etax_util.global_document_update req_id =
ar.plsql.arp_etax_util.global_document_update action = DELETE
ar.plsql.arp_etax_util.global_document_update zx_global_document_update called for 68233

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