JTM Master Concurrent Program Ends with Error ORA-00001 and Trunk Stock Not Showing On-Hand Quantiry For Items (Doc ID 2578170.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

In Mobile Field Service, Trunk stock is not showing on-hand quantity for items.
The JTM Master Concurrent Program ends with the following errors:

Error:

JTM_MASTER_CONC_PROG: JTM Master Concurrent Program

**Starts**DD-MMM-YYYY 10:00:00

Error message from CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY:
              Error in CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY: -1:
              ORA-00001: unique constraint (CSM.CSM_MTL_ONHAND_QTY_ACC_U2) violated.

Error message from CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC:
              Error in CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC: -1:
              ORA-00001: unique constraint (CSM.CSM_ITEM_INSTANCES_ACC_U1) violated

Changes

Cause

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