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: Currently…
Read MoreScript 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, revision numbers, PO amounts, and checks if…
Read MoreQuery 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…
Read MorePO 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) shipment lines using the relevant API. This includes a detailed explanation of the API endpoints, required and optional parameters, data structures, and sample requests and responses. The goal is to enable developers and system integrators to efficiently and accurately manage PO shipment lines within their applications line using API. Scenario: To achieve the goal of splitting the existing PO shipment lines into multiple lines via an API in Oracle, here’s a step-by-step outline of the process. This will include the general approach and considerations needed for splitting the shipment lines as described Currently below is the PO shipment line available in oracle, we would like to split the first shipment as 2 lines and second shipment line as 3 lines. PO Number PO Line Number Item Number Shipment Line number Org Quantity Promised Date Need by Date 100001 1 ABC1 1 USA 50 01-JUL-2022 100001 2 DCG2 2 USA 50 01-JUL-2022 Sample Data File to be prepare and load in to staging table PO_NUMBER…
Read MoreScript for getting PO SLA Details
SELECT DISTINCT pap.last_name || ‘, ‘ || pap.first_name AS “BUYER”, prh.segment1 AS “REQUISITION”, (SELECT …
Read MoreScript 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 order by creation_date …
Read MoreScript 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. DECLARE l_msg_data…
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