Thursday, April 3, 2014

Oracle Report Error - REP-1401: '': Fatal PL/SQL error occurred.

This post is related to Oracle Reports in Oracle EBS Version 11.5.5 to R12+.

Sometimes when you run a report you encounter the below errors:-

REP-1401: '': Fatal PL/SQL error occurred.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error: 

The most common reason for the above error is:-
No return value in one of your functions defined in the report definition.

Solution:-
Ensure that all the functions defined in the report definition has a return value. Also ensure that there is return value outside the             'if condition' statements

No comments: