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:
Oracle Fusion General Ledger Cloud Service - Version 11.13.22.04.0 and laterInformation in this document applies to any platform.
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:
- Have more than 10 DFFs of the character type defined for Journal Lines
- Populate the Create Journal Sheet and enter 10 or more DFFs
- Submit and import with validation
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 |