Introduction
This Post is about Oracle BI Publisher is just a reporting tool. From which we can download excel, CSV, XML, RTF, PDF reports. In which we can use only SQL statement, not PL/SQL. But, we came across the scene to call pl/sqlpackage in OBIP.
Outline1: Call the O package in OBIP by Data template SQL.
Outline 1: Crete OBIP report
Outline 2: data template create in dataset using below SQL.
<dataTemplate name=”AIRReport” description=”Industrial_MIS_Automation” dataSourceRef=”BNP_RPTLIVDB_APEXRPS” Version=”1.0″ defaultPackage=”pkg_sbfs_report_log”>
<dataQuery>
<sqlStatement name=”STMT1″><![CDATA[SELECT INDUS FROM DS_SBFS_MNTHLY_DATA_ANALYSIS]]></sqlStatement>
</dataQuery>
<dataTrigger name=”beforeReportTrigger” source=”pkg_sbfs_report_log.Report_log(‘138′,’START’)” />
<dataStructure>
<group dataType=”varchar2″ name=”G_STMT_1″ source=”STMT1″>
<element dataType=”varchar2″ name=”INDUS” value=”INDUS” />
</group>
</dataStructure>
<dataTrigger name=”afterReportTrigger” source=”pkg_sbfs_report_log.Report_log(‘138′,’END’)” />
</dataTemplate>
Summary
This Post described How to Call Oracle package in Oracle BI Publisher 10g. From which we can download excel, CSV, XML, RTF, PDF reports. In which we can use only SQL statement, not PL/SQL in Oracle EBS R12.
Got any queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions