Last updated on OCTOBER 15, 2012
Applies to:Oracle Reports Developer - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
When attempting to run/deploy one particular report
the following error occurs.
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
The beside 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.
None, just take a working reports from 10gR2 and compile it in 11g, there are no compilation errors
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