JTM Master Concurrent Program With Parameter = Transaction Errors: ORA-00001: unique constraint (CSM.CSM_REQ_LINE_DETAILS_ACC_U1) violated (Doc ID 3028919.1)

Last updated on JUNE 14, 2024

Applies to:

Symptoms

After applying patch 36355987:R12.CSM.C, when running the JTM Master Concurrent Program With Parameter = Transaction, the following error occurs:

Object CSM_CSP_REQ_LINES_EVENT_PKG-CONC_REQ_ORDER_REFRESH : Error ocurrs

ORA-00001: unique constraint (CSM.CSM_REQ_LINE_DETAILS_ACC_U1) violated
ORA-06512: at "APPS.CSM_CSP_REQ_LINES_EVENT_PKG", line 675
ORA-06512: at "APPS.CSM_CSP_REQ_LINES_EVENT_PKG", line 620
ORA-06512: at line 1


 Exception in  CONC_REQ_ORDER_REFRESH :-1:ORA-00001: unique constraint (CSM.CSM_REQ_LINE_DETAILS_ACC_U1) violated

Steps
----------

Mobile Field Service Administrator Responsibility
View Requests > Submit a New Request > JTM Master Concurrent Program > Category = Transaction > Submit
The program fails and the error is captured in the log file

Changes

 Applied patch 36355987:R12.CSM.C

Cause

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