My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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


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 ()+
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



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.