Store Inventory Management Does Not Print Any Log Message for Recycled Transaction ID

(Doc ID 2176722.1)

Last updated on AUGUST 28, 2016

Applies to:

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


When processing Oracle Retail Point of Service (ORPOS) transactions, Store Inventory Management (SIM) does not insert the transaction data and does not print any message in the log file when an old record in POS_TRANSACTION table has the same external ID (POS transaction ID).  This makes it very hard to troubleshoot missing transactions in SIM.

Steps to Reproduce:

  1. Process an ORPOS transaction with an old record in POS_TRANSACTION table with the same transaction ID (external ID).
  2. Observe that the SIM log file will not print any information about this transaction.


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