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 PO line and…
Read MoreSELECT 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′, ‘DD/MM/YYYY’)) + 2) as “PO creation Date”, aps.vendor_name “Supplier Name”, apss.vendor_site_code “Supplier site”,…
Read MoreBelow is the query for getting expected shipments in Oracle Purchasing. SELECT reqh.type_lookup_code, reqh.requisition_header_id po_header_id, rsl.requisition_line_id po_line_id, rsl.req_distribution_id po_distribution_id, reqh.segment1 po_number, msi.segment1 AS item_code, rsl.item_description, rsh.shipment_num, rsl.line_num shipment_line_number, rsl.quantity_shipped expected_receipt_qty,…
Read MoreHow 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 P_ACTION parameter value as ‘CLOSE’/’FINALLY CLOSE’ depending…
Read MoreUsing Security Hierarchies Security hierarchies let you control who has access to certain documents. For example, you can create a security hierarchy in which only you and other buyers in…
Read MoreDefinition: Contract Purchase Agreements in Oracle EBS You create contract purchase agreements with your suppliers to agree on specific terms and conditions without indicating the goods and services that you…
Read MoreAllow Price Override and Price Limit in BPA Case 1: Checking Allow Price Override Step 1 – Create and Approve BPA: Responsibility: Purchasing. NAV: Purchase Orders——–Purchase Orders. Create a Blanket…
Read MoreSubstitute 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 we…
Read MoreBlind Receiving This type of receipting allows the quantity as zero quantity while receipting no matter what is mentioned in the Purchase order. The purpose behind it is to count…
Read MoreCumulative Pricing in Blanket Purchase Agreement Cumulative: Price Breaks will be applied to the cumulative quantity on all released shipments for the item. Step 1 – Create BPA: Create an…
Read More