Consolidation Program (GLCCON) Fails with the Error " ORA-00923" When the Consolidation Mapping has 15 Segments
(Doc ID 2713423.1)
Last updated on JULY 18, 2023
Applies to:
Oracle General Ledger - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
User has upgraded from 11i to 12.2.8. After upgrade consolidation program is failing with the
below error. Consolidation mapping was done for 15 segments and the program was working fine in 11i
Error
=======
>> glcmai.stmt1()
CCON0031: glcmai() - Pass 1 SQL error:
ORA-00923: FROM keyword not found where expected
Steps to reproduce:
==================
Log into General ledger
Navigate to Consolidation Workbench
Run Consolidation
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 |