Third Party Stock Count Import Job Fails With Check Constraint Violation
(Doc ID 2855812.1)
Last updated on MARCH 24, 2022
Applies to:Oracle Retail Enterprise Inventory Cloud Service - Version 19.4 and later
Information in this document applies to any platform.
ThirdPartyStockCountImport_OpsJob errors out with a batch_status = 30 and error_message containing text stating
Error executing batch statement. BatchUpdateException(2290): ORA-02290: check constraint (SIM01.STORE_ITEM_STOCK_CK2) violated
Steps to Reproduce:
Auto authorize selected in the Product Group
System Configuration: Allow non-range item set to Yes
1. Create Stock Count schedule (with count date of tomorrow)
2. Run generate unit & amount count job
3. Take snapshot
4. Upload the third party count file
5. Run the third party stock count import job
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