Unable To GL Drilldown ORA-01789: Query Block Has Incorrect Number Of Results Column FRM-40505

(Doc ID 2409791.1)

Last updated on JUNE 11, 2018

Applies to:

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

Symptoms

On : 12.2.5 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..


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Cost Management
2. Navigation Path: SLA >
3. Run Create Accounting - Cost Management
4. Go to Journals > View Transactions > Click Drilldown.
5. Error raises up

Changes

 

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