My Oracle Support Banner

Transactions In Offline Mode Sent to QueueException Folder Due To 'ORA-00001: unique constraint violated Query String: INSERT INTO LE_HST_TL' (Doc ID 2079308.1)

Last updated on DECEMBER 03, 2020

Applies to:

Oracle Retail Point-of-Service - Version 13.4.8 and later
Information in this document applies to any platform.


In Oracle Retail Point of Service (ORPOS), transactions go missing when performed in offline mode.  Once the register comes online, some transactions fail to persist to the database and fail with the following error in the server-side queue exception file:


Steps to Reproduce:

  1. Log in to POS while online and make sure that new store day has been opened.
  2. Open Till 001 on Reg 001 for a particular business date in online mode.
  3. Take POS offline by shutting down the ORPOS server.
  4. Perform around 30 transactions in offline mode.
  5. Now close and reconcile Till 001 from Reg 001.
  6. Open Till 002 on Reg 001.
  7. Perform some transactions.
  8. Start the Server and bring POS back online.
  9. Log off and log on again on Client with current till ID (002).
  10. Perform some transactions while the transactions are processing from queues which were done with Till 001. (i.e., before transactions done in step 4).
  11. Notice that transactions are missing once the register comes online.  Some of the transactions fail to persist in database and fail with the error shown above.




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.