Training Mode Transactions Tendered with Store Credit Fail to Persist Due to "ORA-00001: unique constraint violated" Error (Doc ID 1404543.1)

Last updated on OCTOBER 20, 2015

Applies to:

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

Symptoms

Oracle Retail Point of Service (ORPOS) issues the same store credit in training mode as well as normal mode, which results in unique constraint violation exceptions. When attempting to issue a store credit for a return transaction, the following error occurs:

Class: com.extendyourstore.foundation.manager.data.DataException(Revision $Revision: /main/9 $) @21590065: SQLState: 23000
Integrity constraint violationSource Exception: java.sql.SQLException: ORA-00001: unique constraint (BO131.SYS_C0019676) violated

Transaction Name: TransactionWriteDataTransaction
Error code: [10] [A referential integrity error occurred during database access.]
Error code (extended): [1]
Description: [SQLState: 23000
Integrity constraint violationSource Exception: java.sql.SQLException: ORA-00001: unique constraint (BO131.SYS_C0019676) violated
]
Query String: INSERT INTO DO_CR_STR ( LN_PRS_CR_STR, MO_CR_STR, DC_CR_STR_EP, FL_TRG_CR_STR, SC_CR_STR, FN_PRS_CR_STR, ID_CNY_ICD, MO_VL_FC_SC_CR_CF, TY_ID_CR_STR, ID_CR_STR) VALUES ('Doe', 55.15, TO_DATE('2012-10-30', 'YYYY-MM-DD'), '1', 'ISSUED', 'John', 1, 0.00, '20', '04241139110001')
Original exception: [null]


Steps to Reproduce:

  1. Log in to Training mode
  2. Perform a sale transaction
  3. Note the transaction number
  4. Select F2 Return and issue the change to a store credit
  5. Log off from Training mode
  6. Log in to POS (F3)
  7. Perform a sale and note the transaction number
  8. Select F2 Return and issue change to a store credit

Notice that the transaction has been put into the '\Server\pos\bin\QueueException' folder.
 

Cause

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