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

Last updated on FEBRUARY 03, 2017

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

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 hundreds of Community platforms