Unable To GL Drilldown ORA-01789: Query Block Has Incorrect Number Of Results Column FRM-40505
(Doc ID 2409791.1)
Last updated on SEPTEMBER 19, 2019
Applies to:Oracle Cost Management - Version 12.2.5 and later
Information in this document applies to any platform.
*** checked on relevance on 16/JUL/2019 ***
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