Introduction
Customer has given a requirement to develop the report in OBIP. While developing it, the developer came to know two datasets of SQL queries required to complete the report. Developer has to generate the report with the single dataset of SQL queries, Instead of using two datasets of SQL queries.
Solution:
To develop OBIP report using Data template SQL Queries.
Step 1: Create OBIP report
Step 2: Create data template SQL Queries and place it into data model in OBIP.
Step 3: Data Template SQL Query.
Step 4: XML data generation.
Step 5: Excel Template.
Note: By this method, we can call package or procedure inside the dataset. It will reduce no. of dataset use in it.
Summary
This Post described Data template in Oracle BI Publisher 10g in Oracle EBS R12.
Got any queries?
Do drop a note by writing us at contact@doyensys.com or use the comment section below to ask your questions.
