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.

Symptoms

On : 12.1.3 version, Requisition Creation

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

Error:
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


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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