Search This Blog

Query behind the PO Release -> Tools -> View Document

Query behind the PO Release -> Tools -> View Document

In Oracle ebs R12 we have some reports like the above. 

form name: POXPOERL

view name: PO_RELEASE_XML  

 SELECT text FROM all_views WHERE view_name = 'PO_RELEASE_XML';

We can select the text for the view.  Run the query, if there is any error on our report, by running the query for that release or po id. we can find out the error.