My Oracle Support Banner

Vision Demo - Utilizing the PO_CUSTOM_PRICE Public Package for Overriding Source Document Price With Requisition Price (Doc ID 2333317.1)

Last updated on OCTOBER 30, 2023

Applies to:

Oracle Purchasing - Version 11.5.10 and later
Information in this document applies to any platform.


The goal of this note is to demonstrate the Alternative Pricing utilizing the PO custom Price Pub.


In this demonstration the steps will be shown on how to use the Custom Pricing Public package "PO_CUSTOM_PRICE_PUB" and the procedure "GET_CUSTOM_PO_PRICE" to override the sourcing document price with the price entered on the requisition.




This document is intended for any user to illustrate and demonstrate the Alternative Pricing utilizing the PO custom Price Pub

This package can be altered and modified for many different business case scenarios.

In this demonstration the ability to let users enter a different requisition item price for a Blanket sourced item is illustrated.

Normal functionality lets users modify the price of a sourced item on the requisition, but when the requisition is autocreated into a standard po/Release the source document prices is used.

Sometimes there is a business need to let the user entered Requisition price become the price on the PO and the code illustrated in this package/procedure will show how this is accomplished.


For more information and examples on other pricing topics see the following:



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Package/Procedure Info
 Setup an Item by Copying an existing item for the demonstration
 Package PO_CUSTOM_PRICE_PUB - Unaltered
 Create A Source Document (Global Blanket) and Sourcing Rules/ASL
 Creating a Requisition and Autocreating a Standard PO from the Requisition 
 Modification of the Custom Price Public Package to Override Source document price
 Post Modification of the Package - Creating a Requisition and Autocreating a Standard PO from the Requisition
 Illustrating the Custom Pricing Package with the CREATEPO (Autocreate in background through workflow) process

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.