Inventory Does Not Get Updated for Complex Pack Items "ORA-01403: No Data Found" Error Occurs
(Doc ID 1573387.1)
Last updated on MARCH 06, 2019
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.
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