The Column(s), PRICE_LIST_ID, Has An Invalid Value(s) when add to cart in iStore (Doc ID 1677349.1)

Last updated on JULY 06, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Shopping Cart Related on all instances

After setting up a new operating unit, when trying to add an item to the cart the following error is returned to the iStore user:


ERROR
-----------------------
The column(s), PRICE_LIST_ID, has an invalid value(s) , <price list id>
The column(s), PRICE_LIST_ID, has an invalid value(s)


There are no items in your cart

 

For example -

The column(s), PRICE_LIST_ID, has an invalid value(s) , 96641
The column(s), PRICE_LIST_ID, has an invalid value(s)


There are no items in your cart

 

 

LOG

-----------------------

The iStore PL/SQL log shows the price list validation error on price list header id 96641 -


ASO Validate_PriceList Begin: p_price_list_id: 96641
ASO Validate_PriceList :mo_global.get_current_org_id 222
28-MAY-2014 11:23:01 ASO Create_Quote: After call to Validate_PriceList: x_return_status: E
ASO Exception in package : ASO_QUOTE_HEADERS_PVT
ASO Exception in API : Create_quote
ASO SQLCODE : 1
ASO SQLERRM : User-Defined Exception
ASO create_quote_pub: after create quote, starting user hooks (1)E
ASO Exception in package : ASO_QUOTE_PUB
ASO Exception in API : CREATE_QUOTE
ASO SQLCODE : 1
ASO SQLERRM : User-Defined Exception
28-MAY-2014 11:23:01 ASO After call to the second overloaded create_quote procedure: x_return_status: E
28-MAY-2014:11:23:01 IBE Expected error IBE_Quote_Save_pvt.Save()
28-MAY-2014:11:23:01 IBE Unexpected error  IBE_Quote_Save_pvt.Save()
28-MAY-2014:11:23:01 IBE Expected error: IBE_Quote_Save_pvt.AddItemsToCart_orig()
28-MAY-2014:11:23:01 IBE End IBE_Quote_Save_pvt.AddItemsToCart_orig() : E
28-MAY-2014:11:23:01 IBE Expected error: IBE_Quote_Save_pvt.AddItemsToCart() (new one)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to iStore
2. Add an item to the cart
3. Error shows and not items get added to the cart.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot add items to the cart in this specialty store causing loss of sales.

Changes

 New operating unit (OU) added to the system.

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