Showing posts with label FND_CONCURRENT. Show all posts
Showing posts with label FND_CONCURRENT. Show all posts

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: