Blog / Category
PO
9 articles in this category
Find Purchase Order from Requisition
Query to find Purchase Order from a Requisition Using SQL Introduction / Issue In Oracle E-Business Suite (EBS), the Procure-to-Pay (P2P) process begins with cr…
UPDATE PO SHIPMENT LINE USING API
UPDATE PO SHIPMENT LINE USING API Objective: The intent of this document is to understand how we can update or split the PO Shipment line using API Scenario: Cu…
Script used to fetch important details about blanket purchase order (PO) approvals status
Use-Case: This SQL query is used to fetch important details about blanket purchase order (PO) approvals. It pulls information like approval actions, dates, revi…
Query to get number of PO created
This query will fetch you the number of Purchase Orders created in month. The input parameter passed is from date and to date. This will group the number of PO…
PO SHIPMENT LINE UPDATE USING API
PO SHIPMENT LINE UPDATE USING API Objective: The purpose of this document is to provide a comprehensive guide on how to update or split Purchase Order (PO) ship…
Script for getting PO SLA Details
SELECT DISTINCT pap.last_name || ‘, ‘ || pap.first_name AS “BUYER”, prh.segment1 AS “REQUISITION”,  …
Script to extract Goods Received Date for Suppliers along with Invoice and PO Information
select (select hou.name from apps.hr_operating_units hou where organization_id = (select org_id from apps.ap_invoices_all apa where apa.vendor_id = ap.vendor_id…
Script to Update Preparer/ Requester in Requisitions using API
Get data to be modified from customer and load it into a staging table. Use this table in the below script to update Preparer/ Requester for PO Requisitions. DE…
Calculate PO Balances
— Query to retrieve customer PO details SELECT obha.order_number, obha.sold_to_org_id, obha.cust_po_number, obha.header…