Shopping List Favorites Shows Item is Not Available, and Add All Items To Cart Gets IndexOutOfBoundsException for Internal Catalog Items in Favorites (Doc ID 2240332.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle iProcurement - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

When attempting to click on 'Add All Items to Cart' button, from Favorites list, the following error occurs.

ERROR
-----------------------

You have encountered an unexpected error.

Exception Details.   
 oracle.apps.fnd.framework.OAException: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
...
## Detail 0 ##
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at com.sun.java.util.collections.ArrayList.RangeCheck(ArrayList.java:492)
at com.sun.java.util.collections.ArrayList.get(ArrayList.java:306)
at oracle.apps.icx.por.req.server.AddToCartSvrCmd.execute(AddToCartSvrCmd.java:284)
at oracle.apps.icx.por.common.server.PorBaseAMImpl.executeServerCommand(PorBaseAMImpl.java:122)

Customer also got the following error message at first, but this was due to extensions.  After removing the extension customization the above error exception is shown

Error Page

Exception details
oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value PoRequisitionLinesVO for source passed to method ViewLinkImpl.setSource. Explanation: view def mismatch
...
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
## Detail 0 ##
oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value PoRequisitionLinesVO for source passed to method ViewLinkImpl.setSource. Explanation: view def mismatch
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:1050)


debug.log:
-----------
fnd.security.AppsConnectionManagerWLSDS 2 getGwyuidConn(): BEGIN
fnd.security.AppsConnectionManagerWLSDS 2 makeGuestConnection(): BEGIN
fnd.security.DBConnObjDS 2 Pool.DBConnObj(Hashtable): Constructed new DBConnObj
fnd.security.AppsConnectionManagerWLSDS 2 borrowConnection(Hashtable): BEGIN
fnd.common.WebAppsContext 2 oracle.apps.fnd.common.WebAppsContext.borrowConnection(oracle.apps.fnd.framework.webui.OAPageContextImpl@15ac1dae,599394578,true): : BEGIN
fnd.common.WebAppsContext 2 oracle.apps.fnd.common.WebAppsContext.getPrivateConnectionFinal(oracle.apps.fnd.framework.webui.OAPageContextImpl@15ac1dae,599394578,true,false,true): : BEGIN
fnd.common.WebAppsContext 2 oracle.apps.fnd.common.WebAppsContext.getExtraJDBCConnection(oracle.apps.fnd.framework.webui.OAPageContextImpl@15ac1dae,599394578,true,true): : BEGIN
fnd.common.WebAppsContext 2 oracle.apps.fnd.common.WebAppsContext.getExtraJDBCConnection(oracle.apps.fnd.framework.webui.OAPageContextImpl@15ac1dae,599394578): : BEGIN/END
fnd.framework.webui.OAPageErrorHandler 6 "60)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:487)
.
.
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
"
fnd.framework.webui.OAPageErrorHandler 6 "oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value PoRequisitionLinesVO for source passed to method ViewLinkImpl.setSource. Explanation: view def mismatch;
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:1050)
at oracle.apps.icx.icatalog.shopping.webui.ShoppingClientHelper.addToReqs(ShoppingClientHelper.java:273)
.
.
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:149)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:"
icx.por.req.server.RequisitionAMImpl 4 Exception on calling oaExp.getAllMessageStackTraces():java.lang.NullPointerException
icx.por.req.server.RequisitionAMImpl 4 Fatal OAException:oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value PoRequisitionLinesVO for source passed to method ViewLinkImpl.setSource. Explanation: view def mismatch;
icx.por.req.server.RequisitionAMImpl 4 Exception on calling oaExp.getAllMessageStackTraces():java.lang.NullPointerException
icx.por.req.server.RequisitionAMImpl 4 Fatal OAException:oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value PoRequisitionLinesVO for source passed to method ViewLinkImpl.setSource. Explanation: view def mismatch
fnd.profiles.Profiles 2 getProfileOptionValue: name=VO_MAX_FETCH_SIZE; levelID=10001; levelValue=0; levelValueApplID=0
fnd.profiles.Profiles 2 getProfileOptionValue: name=VO_MAX_FETCH_SIZE; levelID=10002; levelValue=201; levelValueApplID=0
fnd.profiles.Profiles 2 getProfileOptionValue: name=VO_MAX_FETCH_SIZE; levelID=10003; levelValue=57373; levelValueApplID=201
fnd.profiles.Profiles 2 getProfileOptionValue: name=VO_MAX_FETCH_SIZE; levelID=10004; levelValue=42696; levelValueApplID=0



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to iProcurement and open Shopping Lists Page after adding favorites. See the followings:
- for each item it says “This item is not available”.
- items only have description and no other information.
2. There is no Add to Cart button, but the can select the “Add All Items to Cart” button
3. When the users clicks on “Add All Items to Cart” button, the error can be seen



Changes

This issue occurs after the fix from <Bug 22971593> which adds a condition to show active CLM (Contract Lifecycle Management for Public Sector) blanket items only, however this causes the issue and error exception to occur for non-CLM cases.  Only items associated to CLM documents are working without error.

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