XLAACCUP error : arp_xla_extract_main_pkg.get_glr_ccid Error ORA-01426 when RECEIVABLE_APPLICATION_ID > 2**31 (Doc ID 2637218.1)

Last updated on APRIL 07, 2025

Applies to:

Symptoms

After successfully applying a receipt to an invoice where both are in foreign currency (gain/loss from exchange rate differences need to be calculated), the error below occurs when create accounting:

ar.xla.plsql.get_glr_ccid 2 EXCEPTION OTHERS in arp_xla_extract_main_pkg.get_glr_ccid Error :ORA-01426: numeric overflow

The issue occurs for some lines in the table AR_RECEIVABLE_APPLICATIONS_ALL because the field RECEIVABLE_APPLICATION_ID > 2147483648=2**31 (and the same occurs in ar_distributions_all the field source_id).

The statement:

select ard.code_combination_id
into l_ccid
from ar_distributions_all ard
where ard.source_table = 'RA'
and ard.source_type = p_gain_loss_identifier
and ard.source_id = p_ra_id;

g_glr_ccid_cache_tab(p_ra_id) := l_ccid;

raises the error:

XLA-95103: An internal error occurred. Please inform your system administrator or support representative that: An internal error has occurred in the program XLA_00222_AAD_xxxxxxx ORA-01426: numeric overflow.

NOTE: The issue does not occur if using receipt/transaction in domestic currency.

Cause

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