Unable To Collect GL Diagnostics (Doc ID 1668376.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version 12.2 and later
Oracle E-Business Suite Diagnostics - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

In Oracle General Ledger, 12.2 version, the Oracle General Ledger (GL) Duplicate Rows diagnostic ends in error.

ERROR
-----------------------

GL_CONSOLIDATION_S Sequence
ERROR - ODX-0251: Unable to find stored variable "SQL_GL_CONSOLIDATIONS_S".
ACTION - If the XML file for this test was delivered by Oracle Support Services, contact the support representative for assistance
Unable to collect GL Diagnostics

The  sequence GL_CONSOLIDATION_S  exists.

Changes

Install/upgrade to 12.2

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms