Completing an Oracle RDF report in Warning status using SET_COMPLETION_STATUS

There was a requirement in one of the RDF report that I worked on. We have to end the report concurrent program in warning status with appropriate message if there is no output for the provided input.

So here is how I have achieved it. I have used the function – SET_COMPLETION_STATUS in FND_CONCURRENT in after report trigger to stop the bursting program from triggering. Here are the details of the function:

Comparison between XML Publisher and Oracle Reports

In Oracle Reports, a single executable RDF file contains the data source, layout, business logic, and the language-specific prompts. However, BI Publisher separates these components into different layers. Following are some of the key limitations of Oracle Reports that are overcome by BI Publisher: