My Oracle Support Banner

R12: Journal Import (GLLEZL) From WEBADI /Launch Journal Wizard Fails With Error "LEZL0029: Only data for ledgers with a matching chart of accounts and calendar can be imported". (Doc ID 558889.1)

Last updated on JANUARY 11, 2024

Applies to:

Oracle General Ledger - Version 12.0 to 12.1 [Release 12.0 to 12.1]
Oracle Applications Desktop Integrator - Version 12.0 to 12.1 [Release 12 to 12.1]
Information in this document applies to any platform.
Oracle General Ledger - Version: 12.0 to 12.1
This problem can occur on any platform.

Symptoms

Journal Import (GLLEZL) fails with error  "ORA-1403"  when uploading  and importing journals from Webadi (Web Applications Desktop Integrator)
This happens when users try to upload and import data using Journal Wizard as well.

Journal import log shows
glllgr() 04-MAR-2008 16:02:05
LEZL0029: Only data for ledgers with a matching chart of accounts and calendar can be imported.

<x glllgr() 04-MAR-2008 16:02:05

<x gllcje() 04-MAR-2008 16:02:05

Error in: glllgr
Function return status: 0
Function Err Message: INVALID LEDGER
Function warning number: -1
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01403: no data found

Steps to reproduce the issue:
1.Log into Desktop Integrator
2.Create document using General ledger- Journals Integrator
3.Enter details. Select Upload and Import
Or
1.Log into General Ledger
2.Launch Journal Wizard
3.Enter Details . Select Upload

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
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.