Inventory Does Not Get Updated for Complex Pack Items in SIM: "ORA-01403: No Data Found" Error Occurs

(Doc ID 1573387.1)

Last updated on AUGUST 17, 2016

Applies to:

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


When a user attempts to sell a Complex pack non-orderable item, the sales data for the pack item gets stuck in the Store Inventory Management (SIM) 13.2.4 POS_TRANSACTION table with the following error:

Steps to Reproduce:

1. Sell a complex pack item in POS terminal.
2. The sales transaction information will flow to SIM through web-services.
3. Initially the sales transaction messages are updated in STAGED_MESSAGE table of SIM, and then flow to POS_TRANSACTION table.
4. In a normal case, these messages will flow to the POS_TRANSACTION_HISTORY table, and the stock on hand (SOH) is updated for the sale item. However, in this case the messages for complex pack items get stuck in the POS_TRANSACTION table.  As a result, stock on hand (SOH) is not getting updated.


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