Customer Credit Snapshot Report
Introduction This Post illustrates steps required to Report will fetch and display all customer credit card snapshot details in excel format in Oracle EBS R12. Data Defination <?xml [...]
Call Oracle package in Oracle BI Publisher 10g
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. [...]
PDF Password Protection in BI Publisher
Go to File->Info->Properties>Advanced Settings and follow the Screen shot A and Screen shot b Screen shot A In the Custom Tab add one XDO as xdo-pdf-open-password and in [...]
BI Publisher Report with Excel Template
Step1:Concurrent Program Create a Concurrent Program with Exceutable File Name as XDODTEXE Step:2 Data Xml Template Create a Data Xml Template for the Query Step:3 Data Definitions Create a Data [...]
Displaying subtotal and grand total based on the group column in BI Publisher Template
For Example Display the sub total values based on Account code and show grand total end of the report. The report has only one group (G_ACCT) and group columns like [...]