My Oracle Support Banner

Import Allocation Fails With ORA-01403: no data found For A Large Number Of Journal Lines (Doc ID 2330886.1)

Last updated on JUNE 02, 2020

Applies to:

Oracle Fusion General Ledger Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Capture Transactions-Define Allocations and Period Entries

When attempting to Run General Allocations for a rule that generates 38000 lines and after fixing manually the Unbalance Error (known rounding issue for Allocation Formula) the Import Journal child process ends in Warning. The log shows the message below. This process works perfectly fine (including the manual journal unbalanced fix) for files with fewer lines.

<x gllcnt() 27-OCT-2017 18:51:26

Error in: gllcnt
Function return status: 0
Function Err Message: set_of_books_id mismatch
Function warning number: -1
sqlcaid: sqlabc: 0 sqlcode: 1403 sqlerrml: 25
ORA-01403: no data found

sqlerrp: sqlerrd: 0 4 0 0 0 XXXXXXXX
sqlwarn: sqltext:
*****************************************************SHRD0044: The process is logging off the database and exiting.

gluccf_c source_name:Unknown:

>> gllerr() 27-OCT-2017 18:51:26

The issue can be reproduced at will with the following steps:
1. Have the Allocation Rule Set that will generate a very large number of journals lines (f.e. 38000)

2. Have the Allocation Rule validated and deployed.

3. Run Generate Allocation for this rule.

4. Since the Allocation has a Formula block, the Generate Allocation ends in error or Unbalance (EU02) (Known issue).

5. The customer uses the fix journal line to balance the journal batch.

6. Submits the Journal Import from ADFDi excel template.

The issue has the following business impact:
Due to this issue, users cannot Import all journals lines at ONCE when running these allocation rule, after fixing the known unbalanced rounding issue for allocation formula.


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.