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.
When attempting to add material to Job/operation in High Volume Repair (HVR)/ Technician dashboard repair execution page the following error occurs.
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
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