Rep-1401 and ORA-00936 Running in 11g an Upgraded Report which is using a Hint with Syntax --+ (Doc ID 1423500.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Symptoms

When attempting to run/deploy one particular report the following error occurs.


ERROR
-----------------------
REP-1401 'A Fatal PL/SQL error occurred in program unit <name>'.
without further details if the Report runs using the Reports Server.

But if the same report is run using Reports Builder
Then besides the REP-1401 it will show the error ORA-00936, Missing Expression.


The issue can be reproduced at will with the following steps:
1. compile this migrated report from 10g in 11g and notice there are No error
2. Run the report in Reports Server 11g using the same database connection as in 10g
3. Test the same report in Reports Builder to get more details on the error

What is Working
============
The same report runs fine using a Reports Server 10g.
Running the PLSQL  program unit were the error is detected  outside Reports (i.e sql*plus), it works without issue.

Changes

Upgrade reports from 10gR2 and compile it in 11g.

Cause

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