R12: ECC GL Dashboard Is Not Displaying Any Data; GLECCDLCP: General Ledger Command Center Data Load's Child Request: "ECCRUNDL: ECC Run Data Load" Contains Error: java.sql.SQLException: ORA-01467: sort key too long
(Doc ID 3011157.1)
Last updated on MARCH 22, 2024
Applies to:
Oracle Enterprise Command Center Framework - Version 12.2.7 and laterInformation in this document applies to any platform.
GLECCDLCP: General Ledger Command Center Data Load
ECCRUNDL: ECC Run Data Load
Symptoms
GL ECC Dashboard is not displaying any data for ledgers.
The Screen shows the Ledger Parameter as Multiple even after selecting specific responsibility.
Logged in with a specific General Ledger responsibility. The related Data Access Set given for the responsibility is related to the specific Ledger.
Even the Data Access is given to a specific Ledger, the GL ECC Dashboard is not showing any data related to the Ledger.
"GLECCDLCP: General Ledger Command Center Data Load" is completed and also the related ECC Data Load Job child request too, "ECCRUNDL: ECC Run Data Load". But still, there is no data displayed.
After executing GL ECC Data load "GLECCDLCP: General Ledger Command Center Data Load", the child request "ECCRUNDL: ECC Run Data Load" contains the below error:
Parameter [name:pSystemId, value:EBS]
Parameter [name:pAppShortName, value:gl]
Parameter [name:pDataSetKey, value:]
Parameter [name:pLoadType, value:FULL_LOAD]
Parameter [name:pLang, value:]
Parameter [name:pTraceFlag, value:FALSE]
Parameter [name:pLogLevel, value:ERROR]
...
ERROR ..DataLoadControllerServiceImpl - job failed with error code:There is an error while trying to ingest data for this load rule GL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset gl-aa for job xx
There is an error while trying to ingest data for this load rule GL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset gl-aa for job xx exception details:
java.sql.SQLException: ORA-01467: sort key too long
...
From output of EBS Enterprise Command Center (ECC) Analyzer (Doc ID 2587090.1), observed Database Version 19c.
The issue can be reproduced at will with the following steps:
1. Go to General Ledger Super User
2. Click General Ledger Command Center
3. Click Account Analysis Dashboard
4. Click Period Activities by Chart of Accounts
5. From General Ledger Super User: View > Requests
6. Run GLECCDLCP: General Ledger Command Center Data Load
7. Child requests triggered: ECCRUNDL: ECC Run Data Load
Changes
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 |
Changes |
Cause |
Solution |
References |