My Oracle Support Banner

Unable to Retain the Overridden Requisition Price on its Autocreated Release (Doc ID 1304766.1)

Last updated on MARCH 02, 2023

Applies to:

Oracle Purchasing - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Custom PO/release Pricing API
Autocreate PO


The requisition Price (p_req_line_price) is being passed as null in procedures GET_CUSTOM_PO_PRICE of PO_CUSTOM_PRICE_PUB package when sourcing a requisition from Local BPA (Blanket Purchase Agreement) and autocreate Blanket release

Steps to Reproduce:

  1. Take a backup of file POXPCPRB.pls
  2. Modify the file POXPCPRB.pls, under procedure GET_CUSTOM_PO_PRICE, Insert  (x_new_price := p_req_line_price;), then compile the file
  3. Create new Local BPA : xxx , Item : Test Item,  Price : yyy1
  4. Create new requisition : zzz
  5. Source this requisition to above xxx.
  6. Now the requisition will have the price as yyy1.
  7. Modify the price of the requisition to yyy2 and save.
  8. Now autocreate this document to Release. The price yyy1 appeares in the Release which is incorrect. As per the code the requisition price needs to be carried over to Release i.e yyy2.


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.