ORA-01789 Unable To Perform GL Drilldown For Cost Management Source

(Doc ID 2186177.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Cost Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Subledger Accounting

Unable to perform GL Drilldown for Cost Management Source

We are unable to perform Line drilldown from GL to Cost Management Source, Inventory Category.

Getting the below issue:
 
ERROR
-----------------------
ORA-01789: query block has incorrect number of result columns.

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