R12 EBS General Ledger ECC Incremental Load Is Erroring: ORA-00907: missing right parenthesis
(Doc ID 3044314.1)
Last updated on AUGUST 30, 2024
Applies to:
Oracle Enterprise Command Center Framework - Version 12.2.8 and laterOracle General Ledger - Version 12.2.8 and later
Information in this document applies to any platform.
Symptoms
Running program: GLECCDLCP: General Ledger Command Center Data Load for an incremental load and it is erroring.
The associated program ECCRUNDL: ECC Run Data Load shows the following error in the log:
GL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset gl-aa for job xx,xxxx
exception details:
java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
exception details:
java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
STEPS TO REPLICATE THE ISSUE
-------------------------------------
1) Using Oracle EBS General ledger.
2) Navigate to Reports > Request > Standard.
3) Query and submit program: GLECCDLCP: General Ledger Command Center Data Load.
4) Note the error in the log and the associated ECCRUNDL program logs.
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 |