My Oracle Support Banner

Problem Line Stock Count Extract Fails with 'Severe System Error' When Product Group Element Contains Merchandising Hierarchy (Doc ID 2104871.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 14.1.1 and later
Information in this document applies to any platform.

Symptoms

In Store Inventory Management (SIM) application, we find that creating a product group schedule for a Problem line stock count with merchandising hierarchy, shows a "Severe system error".

Steps to Recreate:

1. Create a Product Group for problem line stock count >> At the Product Group Components screen, under the New Product Group Element, follow these steps exactly:
    a. Select HIERARCHY
    b. Select a Dept that has negative item SOH
    c. Select a Class under the Dept that has negative item SOH
    d. Select a Sub-Class under the Dept/Class that has negative SOH
    e. Select Add to Group
    f. Select Save to save the newly created problem line product group
2. Create a Problem Line Product Group Schedule
3. Select the Product Group that was created in the previous step
4. Enter description and select a location
5. Select Start Date = Today’s date and End Date = Today’s Date
6. Select SAVE
7. Select YES on the confirmation dialog
8. Find that "Severe system error" is displayed with the following message trace:

oracle.retail.sim.common.core.SimServerException: Error querying stored procedure.
at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:237)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:348)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259)
at oracle.retail.sim.service.ejb.StockCountBean_fc89jm_StockCountInterfaceImpl_1036_WLStub.generateStockCounts(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
at com.sun.proxy.$Proxy10.generateStockCounts(Unknown Source)
at oracle.retail.sim.service.stockcount.StockCountEJBServices.generateStockCounts(Unknown Source)
at oracle.retail.sim.client.screen.productgroup.ProductGroupScheduleDetailModel.generateTransactionsFromSchedule(Unknown Source)
at oracle.retail.sim.client.screen.productgroup.ProductGroupScheduleDetailPanel.saveProductGroupSchedule(Unknown Source)
...

 

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.