GL Import for Consolidation ends in Error : failure to malloc memory for control->sources (Doc ID 1531017.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

When attempting to import consolidated data the following error occurs.

ERROR
-----------------------
Function Err Message: failure to malloc memory for control->sources[0].batches[367732].headers
Function warning number: -1
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01403: no data found

Number of Journal Lines to Process at Once = 1000 (changed it from 25000)
GL: Number of Accounts In Memory :2500 (it was null before)

Set GL Journal Import : Separate Journals by Accounting Date to Yes
There are  10 millions+ lines for the date so changing the "GL Journal Import: Separate Journals by Accounting Date to Yes" profile will not work.

Script to check such details: 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have a ledger for consolidation,with type primary.
2. Import journals from the other ledger. Run journal import and get error

Changes

Cause

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