R12: Autocreate Standard Purchase Order Errors Out For Requisitions With Revision Controlled Items With Price Failing To Populate

(Doc ID 1901552.1)

Last updated on DECEMBER 22, 2015

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
PO_PRICE_HELPER.plb

Symptoms

When attempting to autocreate Requisition with Revision controlled Item having NULL Revision, the following error occurs.

ERROR
Error: Requisition # XXXX, Line # 1 failed to autocreate due to

Error: Column PRICE_OVERRIDE should not be NULL. (VALUE=) (COLUMN=PRICE_OVERRIDE)
+------------------------------------------------------------------------------------------------------------------+
Error: Requisition # XXXX, Line # 1 failed to autocreate due to Error: Column UNIT_PRICE should not be NULL. (VALUE=)
+------------------------------------------------------------------------------------------------------------------+

Steps to reproduce:

1. Navigate to: Autocreate

2. Query Requisition # XXXX

3. In the Autocreate Documents window:

Item = XXXX
Rev. = NULL

If the Requisition has no Item Revision number then the Requisition is generating with price but failing to create PO with the above 2 errors.

Cause

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