Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Inserting into database table in XML Data Template
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
Answers
-
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
0