Application Error In Product Detail/Add Service

(Doc ID 2322764.1)

Last updated on OCTOBER 30, 2017

Applies to:

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

Symptoms

On Test:  12.1.3 version, Runtime Catalog

Product Detail page  

You are getting an Application error in iStore Product Details Page. You are using "Product Details with Services" as the display template for Product Details page, so that you can see the Services for Products.
The usage of this template (Product Details with Services) also causing application errors in "Add Service" Functionality from iStore cart.

ERROR
-----------------------
Application Error.

iStore Java Log shows below Errors
-----------------------
22:39:23:905 [Item.getAvailableServicesIDs] Begin (custAccountId=3574, inventoryItemId=2147332, itemRevision=null, requestDate=null)
22:39:23:907 [StoreProfile.get(String)] START
22:39:23:909 [IBEUtil.getProfile] IBE_USE_CUST_SVC_EXCL=N
22:39:23:911 [IBEUtil.useFeature] IBE_USE_CUST_SVC_EXCL=N
22:39:23:912 [Item.getAvailableServicesIDs] see if we shoudld get service item from cache
22:39:23:914 [Item.getAvailableServicesIDs] bCacheService = true
22:39:23:915 [Item.getAvailableServices] begin of calling IBE_Quote_misc_pvt.Get_Available_Services
22:39:24:603 [Item.getAvailableServicesIDs] End of calling IBE_Quote_misc_pvt.Get_Available_Services (687 milliseconds)

22:39:24:614 [IBEUtil.getStoreProfile] IBE_PRICE_RETRIVAL_FLAG=Y
22:39:24:617 [Contract.OperatingUnitCacheManager.get] Calling Cachemanager.get
22:39:24:619 [Item.load(int[], int, boolean, boolean, boolean,boolean)] begin, item size=2380, mode=0, retrievePrice=true,checkPublishedStatus=falseorg id 101
22:39:24:651 [Item.load(int[], int, boolean, boolean, boolean,boolean)] Unique item Ids =  2380

22:39:36:243 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] checking if need to retrieve all uoms...
22:39:36:245 [StoreProfile.get(String)] START
22:39:36:246 [IBEUtil.getProfile] IBE_RETRIEVE_ALL_ITEM_UOMS=null
22:39:36:247 [IBEUtil.getStoreProfile] IBE_RETRIEVE_ALL_ITEM_UOMS=null
22:39:36:249 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] retrieveAllUoms=true
22:39:36:250 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] preparing sql statement...
22:39:36:253 [Item.getItemQuery(int, int, int, int, StringBuffer, int)] BEGIN
22:39:36:255 [Item.getUomQuery(int, int, int, int, StringBuffer, int)] BEGIN

22:39:36:262 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] SQL size=14396

22:39:36:340 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] categorySetId=1100000064
22:39:36:342 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] hasCategorySet=true
22:39:36:343 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] pricing on item load is disabled
22:39:36:345 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] Done setting bind arg for IBE_CATALOG_PVT.LOAD_ITEMS
22:39:36:347 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] bindArgIndex=2412
22:39:36:348 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] executing statement...
22:39:36:515 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)]
java.sql.SQLException: ORA-06550: line 1, column 7846:
PL/SQL: ORA-01795: maximum number of expressions in a list is 1000
ORA-06550: line 1, column 834:
PL/SQL: SQL Statement ignored

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

at oracle.apps.ibe.catalog.Item.getAvailableServicesItems(Item.java:3718)
at _ibeCCtdSvcItmList._jspService(_ibeCCtdSvcItmList.java:281)

at java.lang.Thread.run(Thread.java:619)

22:39:36:517 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] disconnecting from db...
22:39:36:519 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] disconnected successfully
22:39:36:520 [Item.fetchFromDb(Item[],int,int,int, BigDecimal)] return, total items = 2380, elapsed time(ms)=10546
22:39:36:522 [ItemCacheLoader.load( Object[], Context] End method, number of items loaded 2380
22:39:37:808 [Item.getItems(Object[],CacheContext, int)] Items fetched 2380

22:39:45:401 [Item.getItems(Object[],CacheContext, int)] Number of unpublished items0
22:39:45:402 [Item.getItems(Object[],CacheContext, int)] END  
22:39:45:404 [Item.load(int[], int, boolean, boolean, boolean,boolean)] return, 2380 items loaded, elapsed time(ms)=20746
22:39:45:406 [Item.load(int[], int, boolean, boolean, boolean,boolean)] Item objects map constructed
22:39:45:407 [StoreMinisite.getPriceListID] Begin
22:39:45:408 [StoreMinisite.getPriceListID] found price list in session:1516458
22:39:45:409 [Item.getRelatedPrices] BEGIN
22:39:45:411 [Item.getRelatedPrices] Initialising price object list
22:39:45:412 [Item.getRelatedPrices] Constructing PriceCacheKey objects
22:39:45:415 [Contract.OperatingUnitCacheManager.get] Calling Cachemanager.get
22:39:45:423 [ibeCZzdError.jsp] Stack:

java.lang.NullPointerException
at oracle.apps.ibe.catalog.RelatedPriceCacheKey.hashCode(RelatedPriceCacheKey.java:122)
at java.lang.Object.toString(Object.java:219)
at java.lang.String.valueOf(String.java:2827)
at java.lang.StringBuilder.append(StringBuilder.java:115)
at oracle.apps.ibe.catalog.Item.getRelatedPrices(Item.java:3167)
at oracle.apps.ibe.catalog.Item.getRelatedPrices(Item.java:3062)
at oracle.apps.ibe.catalog.Item.getRelatedPrices(Item.java:3005)
at _ibeCCtdSvcItmList._jspService(_ibeCCtdSvcItmList.java:284)


iStore PL/SQL Log does not show any error but it shows high number of Service Items returned
-----------------------
08-AUG-2017:06:17:58 IBE    OKS_OMINT_PUB.Available_Services Finishes S  l_orderable_service_tbl.COUNT=2380
08-AUG-2017:06:17:58 IBE End IBE_CATALOG_PVT.GetAvailableServices


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login to iStore
2. Select a site
3. Click catalog to see items
4. Item displayed with price. Click on item link to see item details page
5. Item details page rendered but bottom half page where service items supposed to display shows 'Application Error'
6. Go Back to catalog to see items
7. Add item to cart
8. Click Add Service Link to launch list of available services page
9. Note that list of services page displayed with 'Application Error'. Not services were displayed.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Trying to use Add Service functionality for the first time.

Changes

 

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