My Oracle Support Banner

R12: XLA: Accounting Program Ends in Error: An internal error has occurred in the program XLA_AE_JOURNAL_ENTRY_PKG.AdjustMpaLine. ORA-01422 (Doc ID 2494657.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Payables - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

When running Create Accounting, Accounting Program ended with the following error.

ERROR
--------------
An internal error has occurred in the program XLA_AE_JOURNAL_ENTRY_PKG.AdjustMpaLine. ORA-01422: exact fetch returns more than requested number of rows.
An internal error occurred. Please inform your system administrator or support representative that:

Due to this issue, users cannot create accounting for the transactions, then cannot close accounting period.


The issue can be reproduced at will if users instance has the following condition and first time to run create accounting:
1. The sequence values "XLA_EVENTS_S" and "XLA_AE_HEADERS_S" are close.

Current sequence values can be confirmed by this query
select sequence_name, last_number from dba_sequences where sequence_name in ('XLA_EVENTS_S', 'XLA_AE_HEADERS_S');

2. User setup MPA(Multi Period Accounting).






Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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