Oracle Reports (MOSC)

MOSC Banner

Need help to complete XML Publisher Report output with WARNING based on value derived in Data Query

edited May 27, 2016 5:06AM in Oracle Reports (MOSC) 1 commentAnswered

Hi All,

     In XML Publisher Report, can we complete output with WARNING based on value derived from Data Query (written in XML Data Definition). I believe, we could do it, if we have query in Before Report trigger, that will allow us read data from query to global variable and validate the global variable in after report trigger and complete program with warning using  fnd_concurrent.set_completion_status. But in my case, I have written queries in Data Definition(.XML file), so is there any why to read result set came from dataQuery and achieve my requirement?

Thanks in advance for your inputs.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center