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 later
Information in this document applies to any platform.

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

	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

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