Purchasing.

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 PO line and…

Read More

Query to display the PO delta extract

Introduction: This query will display the PO details(Delta extract) select prha.attribute1 triprojectnumbertx, –project_number, poh.segment1 cstPONumberTX, –po_number, cstPOUniqueKeyTX prla.attribute4 cstCostCodeIDTX, — Added this as per the latest Cost code change request.…

Read More

Defaulting Requisition Sourcing details using Sourcing Rules

Sourcing Rules in Oracle R12: You can define sourcing rules that specify how to replenish items in an organization, such as purchased items in plants. Sourcing rules can also specify…

Read More

Price Tolerance Percentage and Price Tolerance Amount Functionality in Purchase Orders – R12.2

GOAL: Understanding the Price Tolerance Amount functionality in Oracle Purchasing. Exercise 1: Price Tolerance (%) options in Purchasing. Step 1: Raise a requisition for an item (Test 123) with price…

Read More

Group Shipments functionality of Autocreate in R12.2

This document provides information on Group Shipments functionality for Auto created Purchase Documents. New feature in  R12.2 + related to Group Shipments of Autocreated purchasing documents. Purchase orders generated through…

Read More

ADC – Automatic Document Creation in Oracle Purchasing R12.2

Concept: ADC is created for the documents like Blanket Purchase Agreement, Approved Quotes, and Contract Purchase Agreements to Release the Purchase Orders automatically. Below is the process flow for reference:…

Read More

Un-Ordered Receipts in Oracle Purchasing – R12.2

Un-Ordered Receipts Allow Unordered receipts allows to receive the goods without a PO. But these goods can only sent to receiving area and not for the sub-inventory. Later we have…

Read More

Express Receipts in Oracle Purchasing – R12.2

Express Transactions The express transaction function is a quick method of entering receipts and receiving transactions. Step1: Create a PO. Create a purchase order and go to line level shipments…

Read More

Cascade Receipts in Oracle Purchasing – R12.2

Cascade Receipts The Cascade function facilitates the distribution of a given quantity of an item and UOM from a single supplier across multiple shipments and distributions When you select the…

Read More

Blanket Purchase Agreement (BPA) with Minimum Release Amount Functionality

Minimum Releases in Blanket Purchase Agreement Step 1 – Create Items: Responsibility: Purchasing Super User Navigation: Items > Master Items. Create two different items (Test Item1 and Test Item2) as…

Read More