Till Pick Up and Till Loan Amount Do Not Update LE_HST_STR_SF_TND.MO_BLNC_CRT_OPR_TND in ORBO (Doc ID 1447513.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

Till Pick Up and Till Loan Amount transactions completed on Oracle Retail Point of Service (ORPOS) do not update 'LE_HST_STR_SF_TND.MO_BLNC_CRT_OPR_TND' In Backoffice (BO) database. The following exception is seen in the orpos logs.

ERROR 2012-03-28 21:33:55,605 206982 (RMI TCP Connection(37)-10.150.64.196:oracle.retail.stores.foundation.manager.data.JdbcDataConnection):
[oracle.retail.stores.foundation.manager.data.JdbcDataConnection.logSQLException(JdbcDataConnection.java:1444)]
Execute Statement Failed :ORA-00001: unique constraint (BOADMIN.SYS_C005334) violated

SQL Error Code: 1; SQL State : 23000;
SQL Statement: INSERT INTO TR_TRN ( SC_PST_PRCS, ID_WS, TY_INF_CT, TS_TRN_BGN, ID_RPSTY_TND, ID_EM, TY_TRN, TS_CRT_RCRD, DC_DY_BSN, TS_TRN_END, INF_CT, ID_OPR, FL_TRE_TRN, SC_TRN, AI_TRN, FL_TRG_TRN, ID_STR_RT, FL_SLS_ASSC_MDF, TS_MDF_RCRD) VALUES (0, '129', 0, TO_TIMESTAMP('2012-03-28 21:33:49.849', 'YYYY-MM-DD HH24:MI:SS.FF'), '1296', null, '12', SYSDATE, '2012-03-22', TO_TIMESTAMP('2012-03-28 21:33:54.872', 'YYYY-MM-DD HH24:MI:SS.FF'), null, '0', '0', 2, 66, '0', '04241', '0', SYSDATE)

ERROR 2012-03-28 21:33:55,605 206982 (RMI TCP Connection(37)-10.150.64.196:oracle.retail.stores.domain.arts.JdbcSaveTransaction):
[oracle.retail.stores.domain.arts.JdbcSaveTransaction.insertTransaction(JdbcSaveTransaction.java:171)]
Class: oracle.retail.stores.foundation.manager.data.DataException(Revision $Revision: /main/14 $) @16654270: SQLState: 23000
Integrity constraint violation, Source Exception: java.sql.SQLException: ORA-00001: unique constraint (BOADMIN.SYS_C005334) violated

Transaction Name: [null]
Error code: [10] [A referential integrity error occurred during database access.]
Error code (extended): [1]
Description: [SQLState: 23000
Integrity constraint violation, Source Exception: java.sql.SQLException: ORA-00001: unique constraint (BOADMIN.SYS_C005334) violated
]
Query String: INSERT INTO TR_TRN ( SC_PST_PRCS, ID_WS, TY_INF_CT, TS_TRN_BGN, ID_RPSTY_TND, ID_EM, TY_TRN, TS_CRT_RCRD, DC_DY_BSN, TS_TRN_END, INF_CT, ID_OPR, FL_TRE_TRN, SC_TRN, AI_TRN, FL_TRG_TRN, ID_STR_RT, FL_SLS_ASSC_MDF, TS_MDF_RCRD) VALUES (0, '129', 0, TO_TIMESTAMP('2012-03-28 21:33:49.849', 'YYYY-MM-DD HH24:MI:SS.FF'), '1296', null, '12', SYSDATE, '2012-03-22', TO_TIMESTAMP('2012-03-28 21:33:54.872', 'YYYY-MM-DD HH24:MI:SS.FF'), null, '0', '0', 2, 66, '0', '04241', '0', SYSDATE)
Original exception: [null]


Steps to Reproduce:

Note: Both Till Pick up and Till Loan operations have to be performed back to back, as quickly as possible. Please ensure that the time delay between both the transactions is as low as possible.
  1. Log in Oracle Retail Point of Service (ORPOS)
  2. From the Sell Item screen select More
  3. Select Till functions
  4. Select Pickup
  5. Select Cash
  6. Enter 10.00
  7. Select Enter and close cash drawer
  8. From Till functions, select Loan
  9. Enter 20.00
  10. Select Enter and close cash drawer

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