Split by count excel report in Oracle BI Publisher 10g
Objective: To create a template to split records in excel sheet in Oracle BI Publisher 10g. Solution: Template Creation – EXCEL Step 1: Open the Excel. (See below image) Step…
Read MoreCall Oracle package in Oracle BI Publisher 10g
Objective: To call Oracle package in Oracle BI Publisher 10g. Scenario: Oracle BI Publisher is just a reporting tool. From which we can download excel, csv, xml, rtf, PDF reports.…
Read MoreCalculate PO Balances
— Query to retrieve customer PO details SELECT obha.order_number, obha.sold_to_org_id, obha.cust_po_number, obha.header_id, obha.org_id, TO_DATE (obha.attribute16,’YYYY/MM/DD HH24:MI:SS’) po_last_calc_date, …
Read More