Inventory Does Not Get Updated for Complex Pack Items in SIM: "ORA-01403: No Data Found" Error Occurs
Last updated on MAY 08, 2018
Applies to:Oracle Retail Store Inventory Management - Version 13.2 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)'s 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