Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Inserting into database table in XML Data Template — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Inserting into database table in XML Data Template

Received Response
14
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!