ORA-00001: unique constraint Error When Trying To Update Cycle Count Tasks And Save Task In WMS Control Board
(Doc ID 2353070.1)
Last updated on JANUARY 25, 2018
Applies to:Oracle Warehouse Management - Version 12.1.1 and later
Information in this document applies to any platform.
Users are unable to update and save assigned task in control board.
When attempting to update Cycle count Tasks in Pending status to Queued and update priority, the system runs the "Control Board - Manage Tasks" concurrent program
which completed with the following error
[22-DEC-17 07:39:00] Task Planning.Save Tasks: SQL error: ORA-00001: unique constraint (WMS.WMS_DISPATCHED_TASKS_U2) violated
[22-DEC-17 07:39:00] WMS_TASK_ACTION_PVT: WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS return Status = U
[22-DEC-17 07:39:00] WMS_TASK_ACTION_PVT: WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_save_count = 75
[22-DEC-17 07:39:00] WMS_TASK_ACTION_PVT: WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_msg_data = ORA-00001: unique constraint (WMS
[22-DEC-17 07:39:00] WMS_TASK_ACTION_PVT: .WMS_DISPATCHED_TASKS_U2) violated
[22-DEC-17 07:39:00] WMS_TASK_ACTION_PVT: WMS_WAVEPLAN_TASKS_PVT.SAVE_TASKS l_msg_count =
The issue can be reproduced at will with the following steps:
1. Navigate to WMS Control board form and enter Saved query to query up Pending Cycle count tasks
2. Change the status to Queued and set priority
3. Assign Employee to the tasks
4. Then Click on Submit button
5. The concurrent program Control Board - Manage Tasks runs and it completed with error
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