My Oracle Support Banner

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

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