1 Reply Latest reply: Aug 24, 2012 3:41 AM by HrishikeshJ RSS

    Unable to load Item  from inventory application error

    L S P..
      Hi all,

      I am work with oracle istore customization process in R12. In that we got Application error and null pointer exception, while Viewing or selecting the existing saved "Shopping list" name in the istore shopping lists.

      The error is follows,

      Message: Unable to load Item @item from inventory, please make sure the item is active, published (if not in preview) and belongs to the current organization.
      Stack:
      oracle.apps.ibe.catalog.ItemNotFoundException: Unable to load Item @item from inventory, please make sure the item is active, published (if not in preview) and belongs to the current organization.
           at oracle.apps.ibe.catalog.Item.load(Item.java:5946)
           at ibeCFgdDisplay.jspService(_ibeCFgdDisplay.java:1409)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
           at com.evermind.server.http.ServletRequestDispatcher.unprivileged_include(ServletRequestDispatcher.java:177)
           at com.evermind.server.http.ServletRequestDispatcher.access$000(ServletRequestDispatcher.java:68)
           at com.evermind.server.http.ServletRequestDispatcher$1.oc4jRun(ServletRequestDispatcher.java:114)
           at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
           at com.evermind.server.http.ServletRequestDispatcher.include(ServletRequestDispatcher.java:119)
           at com.evermind.server.http.EvermindPageContext.include(EvermindPageContext.java:456)
           at ibeCSldListDetail.jspService(_ibeCSldListDetail.java:1912)


      Stack:

      java.lang.NullPointerException
           at oracle.apps.ibe.util.IBEUtil.getProfileStore(IBEUtil.java:870)
           at oracle.apps.ibe.util.IBEUtil.getProfile(IBEUtil.java:860)
           at ibeCSldListDetail.jspService(_ibeCSldListDetail.java:2069)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
           at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
           at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
           at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
           at oracle.apps.ibe.util.IBEReleaseResFilter.doFilter(IBEReleaseResFilter.java:42)
           at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)


      Please help,
        • 1. Re: Unable to load Item  from inventory application error
          HrishikeshJ
          Hi,

          Try to locate data in following two tables:
          select * from IBE_SH_SHP_LISTS_ALL
          select * from IBE_SHP_LIST_ITEMS_ALL

          check following:
          1. verify that the items have web_status as PUBLISHED
          and they have a valid category assigned (against the category set mentioned in IBE: Category Set)
          2. Verify that the item has been assigned to the relevant organizations.
          3. verify if IBE: Item Validation Organization is set correctly at appropriate level.

          Thanks,
          Hrishi