Projects - EBS (MOSC)

MOSC Banner

PAXPREPR.fmb transaction control option for tasks throws task number not unique error.

edited May 13, 2014 6:31AM in Projects - EBS (MOSC) 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center