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 and later
Information in this document applies to any platform.


Need to validate the following Invalid objects:


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'PA_PROJ_ACCUM_MAIN' and 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.



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