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 laterInformation 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 |