My Oracle Support Banner

Custom Price Hook Example: How To Retain Price on Requisition to Autocreated PO When Allowing Price Override (Doc ID 943702.1)

Last updated on JULY 06, 2018

Applies to:

Oracle Purchasing - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
POXPOEPO.fmx - Purchase Orders form
POXRQERQ.fmx - Requisitions form
POXBWVRP.fmx - AutoCreate form


Goal

How to retain price on requisition to autocreated standard purchase order SPO using custom price hook when the source agreement allows price override?

Current functionality without custom price hook:



So, to retain requisition price when source agreement allows price override, custom price hook must be used to retain the requisition line price for the SPO line.

Example scenario:

  1.  Create a Global Blanket Purchase Agreement with line item id = 176749, line item price = 33. Allow Price Override = Yes. Approve GBPA.
  2.  Create a Requisition with a line sourced from the above GBPA. Update line price = 30 (from 33.) Approve Requisition.
  3. Autocreate Standard Purchase Order from the Requisition above.
  4. Retain SPO line price = 30 from the Requisition line for the autocreated SPO.

Solution

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

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


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