Showing posts with label Reports. Show all posts
Showing posts with label Reports. Show all posts

Friday, July 20, 2018

Oracle Reports Flex mode and Confine mode

Flex mode and Confine mode

Confine mode:
On: child objects cannot be moved outside their enclosing parent objects.
Off: child objects can be moved outside their enclosing parent objects.


Flex mode:
On: parent borders “stretch” when child objects are moved against them.
Off: parent borders remain fixed when child objects are moved against
them.

Saturday, March 10, 2018

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

If the RDF Report is failing with Fatal PL/SQL Error.

Reasons could be either of the below three

1) Formula column is returning Null value
2)Data type variable is returning more than expected size of variable.
3) Data type of variable are mismatching.