R12 PAXPREPR Ora-06502 Creating Peer Task WBS_NUMBER Corruption (Doc ID 1947583.1)

Last updated on MAY 30, 2016

Applies to:

Oracle Project Foundation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Project Definition

PAXPREPR Ora-06502 creating peer task PA_TASK_PUB1.UPDATE_WBS_NUMBERS

Users are attempting to create peer tasks on some projects in PAXPREPR.fmb.

 

A subtask is selected with "create peer task",then the task number, name and description are entered.

When the save button is clicked, an error is returned with:

"The procedure to create a task version failed, no task version was created. ORA-06502: PL/SQL numeric or value error: character to number conversion error in Package PA_TASK_PUB1 Procedure UPDATE_WBS_NUMBERS.

This is not consistent for all projects. If they use the "create subtask" button, the task is created correctly and does not 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