My Oracle Support Banner

Unable To GL Drilldown ORA-01789: Query Block Has Incorrect Number Of Results Column FRM-40505 (Doc ID 2409791.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


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:
ORA-01789: query block has incorrect number of result columns..

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


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

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