My Oracle Support Banner

PAXPREPR ORA-06502 Creating Peer Task PA_TASK_PUB1.UPDATE_WBS_NUMBERS (Doc ID 1947556.1)

Last updated on JULY 07, 2021

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

In the PAXPREPR Projects form, users encounter error 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 as - "create peer task" - then the task number, name and description are entered. When the record is saved, a "note" window pops-up 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 the "Create Subtask" button is used, the task is created correctly and does not encounter the error.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.