Invalid Objects PA_PROJ_ACCUM_MAIN and PA_COMMITMENTS_V (Doc ID 1669522.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Project Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Need to validate the following Invalid objects:

APPS PA_PROJ_ACCUM_MAIN PACKAGE BODY
APPS PA_COMMITMENTS_V VIEW


After execution of the alter package PA_PROJ_ACCUM_MAIN compile the following error occurs:

Error starting at line 5 in command:
alter package 'PA_PROJ_ACCUM_MAIN' compile
Error report:
SQL Error: ORA-04050: invalid or missing procedure, function, or package name
04050. 00000 - "invalid or missing procedure, function, or package name"
*Cause: The required procedure, function, or package name is invalid
  or missing.
*Action: Specify a valid name.

 


After execution of this command “select line,text from user_errors where name='PA_PROJ_ACCUM_MAIN'”

4211 "PL/SQL: ORA-04063: view "APPS.PA_COMMITMENTS_V" has errors
ORA-00942: table or view does not exist"
4062 PL/SQL: SQL Statement ignored
4) After execution of the ‘select a.line,a.text from USER_SOURCE a , USER_ERRORS B where a.name='PA_PROJ_ACCUM_MAIN' and a.name=b.name and a.LINE=B.LINE”

4062 " INSERT INTO pa_commitment_txns_tmp
"
4211 " FROM pa_commitments_v pctv


"
After compiling the view PA_COMMITMENTS_V the following error occurs:

Error starting at line 19 in command:
alter view PA_COMMITMENTS_V compile
Error report:
SQL Command: alter view
Failed: Warning: execution completed with warning
alter view PA_COMMITMENTS_V succeeded.

 

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