PA_DATAFIXES_UTIL Package Is Invalid ~ How to Recompile It? (Doc ID 1600017.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Management - Version 12.1.3 and later
Information in this document applies to any platform.
Checked for relevance on 14-Apr-2015

Goal

 PA_DATAFIXES_UTIL is invalid.  How can this compile without errors?

DBA_ERRORS shows:

APPS PA_DATAFIX PACKAGE BODY 3 680 67 PL/SQL: ORA-00942: table or vi ERROR 0
          ES_UTIL ew does not exist

APPS PA_DATAFIX PACKAGE BODY 4 674 1 PL/SQL: SQL Statement ignored ERROR 0
          ES_UTIL

or

APPS PA_DATAFIXES_UTIL PACKAGE BODY 3 680 67 PL/SQL: ORA-00942: table or view does not exist ERROR 0
          
APPS PA_DATAFIXES_UTIL PACKAGE BODY 4 674 1 PL/SQL: SQL Statement ignored ERROR 0
         

 

Solution

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