My Oracle Support Banner

Inventory Does Not Get Updated for Complex Pack Items "ORA-01403: No Data Found" Error Occurs (Doc ID 1573387.1)

Last updated on SEPTEMBER 16, 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

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