No Visibility to Previously Received Containers When a Break-Lock Occurs on Warehouse Delivery Receiving (Doc ID 1963205.1)

Last updated on FEBRUARY 09, 2015

Applies to:

Oracle Retail Store Inventory Management - Version 14.0.1 to 14.0.2 [Release 14.0]
Information in this document applies to any platform.

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release (SIM 14.0.3).
This article will be updated as official patch information becomes available.


The Store Inventory Management (SIM) handheld (HH) warehouse delivery receiving process does not have enough visibility to previously-received data.  It also shows inconsistent data in warehouse delivery by HH.


Steps to Reproduce:


Pre-requisite: Create a warehouse delivery shipment with 6 containers:
     SHIPMENT_CONTAINER0
     SHIPMENT_CONTAINER1
     SHIPMENT_CONTAINER2
     SHIPMENT_CONTAINER3
     SHIPMENT_CONTAINER4
     SHIPMENT_CONTAINER5

  1. Log in to HH.  Scan container SHIPMENT_CONTAINER0 to locate the shipment.
  2. Select "1 - Receive Container".
  3. Scan container SHIPMENT_CONTAINER0 to start the receiving process.
  4. Select "3 - Receive Container".
  5. Query database for the shipment data.
    Notice that status = 2 for container SHIPMENT_CONT80; also the item is received in line item table for this container.
    Notice that the HH summary shows 'Rcve Containers: 1' -- this indicates one container, SHIPMENT_CONTAINER0, is received.
    But the database shows the ASN status as WHD.status = 0 - New
    Without saving anything, the data is saved at container and line item level, but no change to the header status.
  6. Now kill the emulator session.
  7. Log in to HH again with a new session in a new emulator.
  8. Thinking container SHIPMENT_CONTAINER0 was received, scan the container SHIPMENT_CONTAINER1 to locate the ASN.  See message "This Delivery is in progress by SIM14ADMIN. Would you like to break the lock?"
  9. Select '1-Yes' to break the lock.
  10. Select "1 - Receive Container" and scan SHIPMENT_CONTAINER1 receive container SHIPMENT_CONTAINER1.  The HH summary screen still shows 'Rcvd Containers: 0'.  At this point, the backend data still shows, status = 2 for container SHIPMENT_CONTAINER0.
  11. Once again scan container SHIPMENT_CONTAINER1 and select '3 - Receive Container'.  Now the summary shows 'Rcvd Containers: 1'.
  12. Continue receiving the following containers in the same way:
    SHIPMENT_CONTAINER2
    SHIPMENT_CONTAINER3
    SHIPMENT_CONTAINER4
    SHIPMENT_CONTAINER5
  13. The status = 2 for all containers, no scanning made on container SHIPMENT_CONT80 after step 7. 
  14. There is a discrepancy alert for container SHIPMENT_CONTAINER0.

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