My Oracle Support Banner

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 16, 2019

Applies to:

Oracle Mobile Field Service - Version 12.2.6 and later
Information in this document applies to any platform.
JTM_MASTER_CONC_PROG

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

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.