Last updated on MAY 02, 2017

Applies to:

Symptoms

On : 12.1.1 version, Journal Import

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

changed some profile values, but still get the same error.

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

Suggested to set GL Journal Import : Separate Journals by Accounting Date to Yes
In 31.12.2011 there are10.670.651 lines so changing the "GL Journal Import: Separate Journals by Accounting Date to Yes" profile will not work

select je_batch_id,je_header_id, sum(accounted_dr), sum(accounted_cr), ledger_id, accounting_date, group_id from GL_CONS_INTERFACE_652393
group by je_batch_id,je_header_id,ledger_id, accounting_date, group_id ;



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
have a ledger for consolidation,with type primary.
import journals from other ledger .When we run journal import we gets the attached error.
changed the profile option ' GL: Number of Records to Process at Once' from25.000 to 1000. But not worked.

In 31.12.2011 there are10.670.651 lines so changing the "GL Journal Import: Separate Journals by Accounting Date to Yes" profile will not work


No value, column which may help to split the journal for accounting_date 31/12/2011

Changes

Cause