12.2: Post Upgrade to 12.2, Package PJI_PJP_SUM_ROLLUP remains Invalid (Doc ID 2194327.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Project Definition

When attempting to create a Project,
the following error occurs.

ERROR
-----------------------
API: PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE SQL ERROR MESSAGE: ORA: 06508: PL/SQL : COULD NOT FIND PROGRAM UNIT BEING CALLED

The package: PJI_PJP_SUM_ROLLUP is Invalid


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Query the template
2. Try to create a new Project
3. Error appears


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