Blog / Category
Purchasing
11 articles in this category
Create PO Change Order in Oracle Cloud – Add Project Info To Existing PO Line Using SOAP request
This blog describes the sample request for creating Change Order in Oracle Cloud for the existing Purchase Order. This Change Order is to add project details in…
Query For PO Acceptance Details
SELECT DISTINCT pha.vendor_id, hou.name “Organization”, pha.segment1 “po number”, pla.line_num “po line num”, (TRUNC (pha.creation_date – TO_DATE (’01-01-1900′,…
Expected Shipments in PO
Below is the query for getting expected shipments in Oracle Purchasing. SELECT reqh.type_lookup_code, reqh.requisition_header_id po_header_id, rsl.requisition_l…
How to programmatically close PO using PO_ACTIONS API
How to programmatically close PO using PO_ACTIONS API PO_ACTIONS.CLOSE_PO is the API used to programmatically close/final close Purchase Order. We have to pass…
Security Hierarchy functionality Setups and Flow in Oracle Purchasing
Using Security Hierarchies Security hierarchies let you control who has access to certain documents. For example, you can create a security hierarchy in which o…
Contract Purchase Agreement Creation Process in R12.2
Definition: Contract Purchase Agreements in Oracle EBS You create contract purchase agreements with your suppliers to agree on specific terms and conditions wit…
BPA With Allow Price Override and Price Limit Functionality – R12.2
Allow Price Override and Price Limit in BPA Case 1: Checking Allow Price Override Step 1 – Create and Approve BPA: Responsibility: Purchasing. NAV: Purchase Ord…
Substitute Receipts in Oracle Purchasing – R12.2
Substitute Receipts This option can be used when we can receive the substitute item. Means we can receive item B, where as we ordered item A. Firstly for this w…
Blind Receipts in Oracle Purchasing – R12.2
&nbs…
BPA – Blanket Purchase Agreement with Cumulative Pricing
Cumulative Pricing in Blanket Purchase Agreement Cumulative: Price Breaks will be applied to the cumulative quantity on all released shipments for the item. Ste…
PO Workflow Error – Document Manager Failed with Error Number 3 while processing Standard Purchase Order XXXXXX
Reset a Purchase Order Statuses From In Process or Pre-Approved To Incomplete/Requires Reapproval Title: Document Manager Failed with Error Number 3 while proce…