Oracle

Call 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 More

Calculate 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