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

 

Recommended Posts

Start typing and press Enter to search