PAXPREPR.fmb transaction control option for tasks throws task number not unique error.
Please help to get most possible solution for below :
in PAXPREPR.fmb The error code PA_ALL_DUPLICATE_NUM
is raised from PACKAGE BODY tasks_private -> Procedure Check_Task_Number
This Procedure Check_Task_Number is being called by tasks_pkg.procedure
pre_insert AND procedure pre_update.
The issue here is when the new task got created and soon we open its
transaction option form it did not refresh it, because of which the
:tasks.row_id is NULL which gets passed to procedure Check_Task_Number and it
returns 0 after making a call to PA_TASK_UTILS.check_unique_task_number