My Oracle Support Banner

Item Price Not Getting Defaulted From Advance Pricing (Doc ID 1947633.1)

Last updated on AUGUST 11, 2020

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 = <item id>
po.plsql.PO_AUTOSOURCE_SV.autosource.000 1 x_commodity_id = <commodity_id>>
po.plsql.PO_AUTOSOURCE_SV.autosource.000 1 x_dest_organization_id = <org_id>
po.plsql.PO_AUTOSOURCE_SV.autosource.000 1 x_autosource_date = DD-MON-YYYY hh:mm:ss
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




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.