My Oracle Support Banner

HVR Error: 'ORA-00001: unique constraint (CSD.CSD_WIP_TRANSACTION_DETAILS_U2) violated in Package CSD_HV_WIP_JOB_PVT' Adding Material Lines To A Repair Job (Doc ID 1222963.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

Oracle Depot Repair - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to add material to Job/operation in High Volume Repair (HVR)/ Technician dashboard repair execution  page the following error occurs.

ORA-00001: unique constraint (CSD.CSD_WIP_TRANSACTION_DETAILS_U2) violated in Package CSD_HV_WIP_JOB_PVT Procedure PROCESS_SAVE_CSD_MTL_TXN_DTLS


This is happening during load testing, where multiple (automated) processes are doing the same thing (creating and processing repair jobs) simultaneously. That means that in theory when 2 or more users are doing the same thing at the same time, this can occur as well.

The issue can be reproduced at will with the following steps:
1. Create Repair Order (type Work In Process)
2. Receive RMA Line of customer product
3. Click Repair Jobs tab
4. Click Create Jobs > HTML form opens
5. Add Operations > Save
6. Add Materials > Save
7. Receive error message

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.