Item Price Not Getting Defaulted From Advance Pricing

(Doc ID 1947633.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Requisition Creation

When attempting to create a requisitions advanced pricing is not getting defaulted.

po.plsql.PO_AUTOSOURCE_SV.autosource.BEGIN 2 Start of subprogram.
po.plsql.PO_AUTOSOURCE_SV.autosource.000 1 x_mode = VENDOR
po.plsql.PO_AUTOSOURCE_SV.autosource.000 1 x_item_id = 4827
po.plsql.PO_AUTOSOURCE_SV.autosource.000 1 x_commodity_id = 1208
po.plsql.PO_AUTOSOURCE_SV.autosource.000 1 x_dest_organization_id = 163
po.plsql.PO_AUTOSOURCE_SV.autosource.000 1 x_autosource_date = 12-NOV-2014 07:59:13PM
po.plsql.PO_AUTOSOURCE_SV.autosource.010 1 x_item_buyer_id is null
po.plsql.PO_AUTOSOURCE_SV.autosource.030 1 Calling MRP Sourcing API
po.plsql.PO_AUTOSOURCE_SV.autosource.040 1 x_vendor_id is null
po.plsql.PO_AUTOSOURCE_SV.autosource.040 1 l_vendor_site_code is null
po.plsql.PO_AUTOSOURCE_SV.autosource.040 1 x_source_organization_id is null
po.plsql.PO_AUTOSOURCE_SV.autosource.040 1 x_sourcing_rule_id is null
po.plsql.PO_AUTOSOURCE_SV.autosource.040 1 x_error_message = MRP_SOURCING: Cannot select SourceJUNK12
po.plsql.PO_AUTOSOURCE_SV.autosource.045 1 x_error_message is null
po.plsql.PO_AUTOSOURCE_SV.autosource.END 2 End of subprogram.

Replication Steps:
The issue can be reproduced at will with the following steps:
1. Create BPA. Run Generate Sourcing Rule / ASL concurrent program to create ASL and sourcing rule.
2. Create Requisition template with price zero and no supplier/ site information.
3. Go to iProcurement. Go to shopping list and select the requisition template created in step 2 above.
4. Select the item and add to cart.
5. Click view cart and checkout.
6. Price is shown as zero.
- Users expect the price should be taken from the BPA based on the sourcing setup


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