DFF Spreadsheet Upload Error ORA-01403: no data found Unknown je_source_name ORA-00942: table or view does not exist (Doc ID 2901263.1)

Last updated on OCTOBER 17, 2022

Applies to:

Symptoms

On : 11.13.21.10.0 version, Journals and Intercompany

When attempting to import journals having DFF, the following error occurs.

ERROR
-----------------------
The import process ends in error and the logs show

Multiple sheet import logs error:
Error in: gllcje.gllaid
Function return status: 0
Function Err Message: Internal Error: Unknown je_source_name
Function warning number: -1
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01403: no data found
  
sqlerrp: sqlerrd: 0 235 0 0 0 538976288
sqlwarn: sqltext:
*****************************************************SHRD0044: The process is logging off the database and exiting.

gluccf_c source_name:Spreadsheet:

OR

Single sheet import logs error

Error in: gllsec
Function return status: 0
Function Err Message: error in sqlerr
Function warning number: -1
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: -942 sqlerrml: 40
sqlerrmc:
ORA-00942: table or view does not exist

sqlerrp: sqlerrd: 0 1 0 426 0 538976288
sqlwarn: sqltext:
*****************************************************SHRD0044: The process is logging off the database and exiting.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Have more than 10 DFFs of the character type defined for Journal Lines
2. Populate the Create Journal Sheet and enter 10 or more DFFs
3. Submit and import with validation

Cause

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