My Oracle Support Banner

Transactions Sent to QueueException Folder if Register Open From Back Office and Record not in the Workstation History Table (Doc ID 1582707.1)

Last updated on FEBRUARY 04, 2019

Applies to:

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

Symptoms

When attempting to persist sale transactions that are performed on a register which has been opened from Oracle Retail Back Office (ORBO), the following error occurs and the transactions are put into the QueueException folder.



Steps to Reproduce:

Pre-Requisites:
   a. Install a new POS client 128
   b. Record in the AS_WS table for this registerID had a value of null in the TS_TM_SRT column.

  1. Open store for new business day in ORBO.
  2. Open register A.
  3. Delete the record from the LE_HST_WS table for register A. (This is being done to simulate the situation in a production environment where this record is not being inserted for register open for new business date intermittently)
  4. Open Till from ORPOS and insert the Till into Cash Drawer.
  5. Complete a sale transaction.
  6. Notice that the receipt is printed and the transaction is not persisted to the store database.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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