Unable to run Create Accounting for Transaction - Credit Memos or Credit Memo Applications : Online Accounting Hangs (Doc ID 2150862.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle Receivables - Version 12.1 and later
Information in this document applies to any platform.
XLAACCUP : Accounting Program

Symptoms

When attempting to run Create accounting, the following error occurs in Accounting Program 
message p_msg_name = XLA_AP_TECHNICAL_ERROR

Accounting program log file shows
arp_xla_extract_main_pkg.load_header_data_ctlgd ()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+
EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_ctlgd
Error :User-Defined Exception
EXCEPTION OTHERS in arp_xla_extract_main_pkg.extract
Error :User-Defined Exception
Technical problem : Error encountered in product API for extract

The debug from online accounting shows that accounting is stuck at
 xla.plsql.XLA_00222_AAD_S_000002_PKG.EventClass_157 SQL - FETCH line_cur

 

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