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.


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.



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