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 JUNE 21, 2023

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


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.


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

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