Error: 'Task Number Is Not Unique', Task not Visible in Task Form

(Doc ID 2381945.1)

Last updated on APRIL 03, 2018

Applies to:

Oracle Project Costing - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Missing task in PA_TASK
Not visible in Project form

Task exists in pa_proj_elements  and pa_proj_element_versions tables, but  missing in PA_TASKS


View the output of the following to see task missing in PA_TASKS

 a) Select * from pa_tasks where project_id=XXX;
 b) Select * from pa_tasks where project_id=XXX;
 c) Select * from pa_proj_workplan_attr where project_id=XXX;
 d) Select * from pa_proj_elements where here project_id=XXX;

 

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