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.

Symptoms

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

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 =


STEPS
-----------------------
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms