R12: PA: Project Task Update Error: Task Number Is Not Unique (Doc ID 1633486.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 03-OCT-2016***

Symptoms

On : 12.1.3 version, Deliverables

Project task update error: Task number is not unique

Current Form
----------------------------------------
Form Application : Projects
Form Name : PAXPREPR
Form Path : /u01/ar121/DEV/apps/apps_st/appl/pa/12.0.0/forms/US/PAXPREPR.fmx
Form Version : 12.0.99.12010000.134
Form Last Modified : $Date: 2013/06/26 23:45 $

Problem is only for one project: OU300, project nr. 148648, task 04.3, no double entry in the table pa_proj_elements.

ERROR
-----------------------
 Task number is not unique


STEPS
-----------------------
Uploaded OutPut from:

select * from pa_projects_all a where a.segment1 in ('148648');
select * from pa_tasks a where a.project_id=794410;
SELECT e.* FROM pa_proj_elements e where e.project_id=794410;


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update task.

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