Worksheet Run in Discoverer Plus 11g Results In ORA-00600. Runs Fine In Discoverer Desktop 11g (Doc ID 2222915.1)

Last updated on FEBRUARY 10, 2017

Applies to:

Oracle Discoverer - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Goal

A worksheet (report) that runs fine in Discoverer Desktop is failing in Plus 11g with the error:

The sql generated by Desktop is different than that generated by Plus. When Plus SQL is run directly in the database the same error is returned.

Created the report again from scratch in Plus, but as soon as the totals are added the same error occurs.


 

Solution

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