My Oracle Support Banner

'Source Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint' Error During Exchange Transaction (Doc ID 2798441.1)

Last updated on AUGUST 18, 2021

Applies to:

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

Symptoms

ORPOS in certain exchange transactions when price adjustment item is deleted create a queue exception file with the following error.

ERROR
-----------------------
Integrity constraint violation, Source Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TR_LTM_RTL_TRN_PK) violated]
Query String: INSERT INTO TR_LTM_RTL_TRN ( ID_STR_RT, ID_WS, AI_TRN, DC_DY_BSN, AI_LN_ITM, TY_LN_ITM, TS_MDF_RCRD, TS_CRT_RCRD) VALUES ('04241', '001', 381, '2020-01-01', 3, 'TN', SYSDATE, SYSDATE)
Original exception: [null]

at oracle.retail.stores.foundation.manager.data.BaseJdbcSQLState.mapException(BaseJdbcSQLState.java:394)
at oracle.retail.stores.foundation.manager.data.JdbcDataConnection.throwDataException(JdbcDataConnection.java:1401)
at oracle.retail.stores.foundation.manager.data.JdbcDataConnection.execute(JdbcDataConnection.java:1079)
at oracle.retail.stores.foundation.manager.data.JdbcDataConnection.execute(JdbcDataConnection.java:919)
at oracle.retail.stores.domain.arts.JdbcSaveRetailTransactionLineItems.insertRetailTransactionLineItem(JdbcSaveRetailTransactionLineItems.java:2069)
at oracle.retail.stores.domain.arts.JdbcSaveTenderLineItems.insertTenderLineItem(JdbcSaveTenderLineItems.java:1618)
at oracle.retail.stores.domain.arts.JdbcSaveTenderLineItems.saveTenderLineItem(JdbcSaveTenderLineItems.java:491)
at oracle.retail.stores.domain.arts.JdbcSaveTenderLineItems.saveTenderLineItems(JdbcSaveTenderLineItems.java:440)
at oracle.retail.stores.domain.arts.JdbcSaveTenderLineItems.execute(JdbcSaveTenderLineItems.java:281)
at oracle.retail.stores.foundation.manager.data.DataCommand.execute(DataCommand.java:341)



Steps to Reproduce:

1. Login to POS.
2. Scan items
3. Select an item and click on Pricing (F8) Price Override (F2).
4. Enter higher price, select any reason code and press next.
5. Press Tender and complete this transaction with Cash, also note the transaction number.
6. Again login to POS.
7. Press return and enter transaction number noted in step 5.
8. Select an item for return and come back to sell screen.
9. Add any other item say 928..d click on “Price Adjustment”.
10. Enter transaction number noted in step 5.
11. You should see price adjusted items added in transaction.
12. Now select those price adjusted items and delete them.
13. Press tender and complete the transaction with Cash.

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.