Vision Demo - Utilizing the PO_CUSTOM_PRICE Public Package for Overriding Source Document Price With Requisition Price
(Doc ID 2333317.1)
Last updated on MAY 07, 2021
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:
- For Standard pricing setups and examples see <Note 2332541.1> Vision Demo- Explaining and Illustrating the Setups for Default Price on Requistions and Purchase Order Items
- For more information on Advanced Pricing Utilizing Surcharges see <Note 1101067.1> Vision Demo - How To Utilize Advanced Pricing in Purchasing
- For CREATEPO Workflow pricing examples see <Note 2333325.1> Vision Demo Explaining and Illustrating the Pricing Utilized on PO's created by the CREATEPO Workflow
- For More on the Custom Pricing Package and how to use it see <Note 943702.1> Custom Price Hook Example: How To Retain Price on Requisition to Autocreated PO When Allowing Price Override
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
|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|