R12 PAXPREPR Ora-06502 Creating Peer Task WBS_NUMBER Corruption
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
Million Knowledge Articles and hundreds of Community platforms