My Oracle Support Banner

Error 'ORA-02290: check constraint (FAHSIM16.STORE_ITEM_STOCK_CK2) violated' While Delete Unit And Amound Stock Count (Doc ID 2898841.1)

Last updated on SEPTEMBER 28, 2022

Applies to:

Oracle Retail Store Inventory Management - Version 16.0.3 and later
Information in this document applies to any platform.

Goal

We are getting an error while deleting Unit and amount Stock count id in SIM.

Error in sim.log:

"ERROR-18977 Time: 9/4/22 10:45 AM Type: SimServerException Message: Error executing batch statement.
2022-09-04 10:45:52,401 ERROR [[ACTIVE] ExecuteThread: '42' for queue: 'weblogic.kernel.Default (self-tuning)'][o.r.s.s.d.d.StockCountOracleDao] Error executing batch statement: UPDATE STORE_ITEM_STOCK SET STORE_ITEM_STOCK.OPEN_STOCK_COUNTS = NVL(STORE_ITEM_STOCK.OPEN_STOCK_COUNTS, 0) - 1 WHERE STORE_ITEM_STOCK.ITEM_ID = ? AND STORE_ITEM_STOCK.STORE_ID = ?
java.sql.BatchUpdateException: ORA-02290: check constraint (FAHSIM16.STORE_ITEM_STOCK_CK2) violated".

Solution

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
Goal
Solution


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