Inserting into database table in XML Data Template

Skray

Summary

Inserting into database table in XML Data Template

Content

I am using XML Publisher reports for Oracle EBS concurrent program.

Previously, when I used Oracle Reports rdf, for complex queries I created a custom database table and inserted data into this table (by breaking down the query in smaller blocks) in the Before Report trigger, and in the main query I simply queried from this custom table. Subsequently in the After Report trigger I purged the table.

Can something similar be done when writing queries in XML Data Template (XML Publisher > Data Definitions > Data Template), i.e. insert/u[date into a database table first

Thanks

Sanjay

YGUTTIKONDA

Sanjay,

Yes BI Publisher supports the use of triggers , there are some decent samples in the below links

http://www.quest4apps.com/xml-report-from-xml-data-template/

https://docs.oracle.com/cd/E10415_01/doc/bi.1013/e12187/T421739T434255.htm

Hope this helps ..

Regards,

Yugandhar