Interactive Oracle Report Template

Question

I have several similar interactive reports. I want to have some kind of template to which all reports will be bound. For example, each report must have a button, and it is tedious to add a button to each new report. If I want to change something in the general part of all reports, I will need to look through all the reports and apply complex changes.

Answer 1

There is no ideal solution for you, but here are some of them that can be made to simplify the creation of new reports:

• When creating a new interactive report (IR) area in an application, you can start by copying an existing IR in the same application. This gives you the ability to simultaneously copy any related items and buttons.

• You can create a template page (I usually call it a skeleton page to avoid confusion with the concept of Apex templates) with a typical set of components: IR area, standard buttons, elements, processes. To create a new report, create a new page as a copy pages of the skeleton, and then change it as necessary.

None of these problems are related to your second problem: if you later decide that all IR regions should have a new “Foo” button, you will have to change each one individually. You might consider an approach that uses the Apex Builder APIs to create these buttons, but if you did (I’ve done in the past) you would not get Oracle support!