Projects - EBS (MOSC)

MOSC Banner

EBS R12.1.3 : PA packages invalid after db import to 12.1.0.2

edited Mar 11, 2016 4:07AM in Projects - EBS (MOSC) 1 commentAnswered

Hi,

We exported EBS R12.1.3 db from 11.2.0.1 and imported to 12.1.0.2 .   after import we executed adgrants.sql .   there are some PA packages invalid due to following error.  Please let me know how to resolve it

alter package APPS.PA_BUDGET_PUB compile;

Warning: Package altered with compilation errors.

SQL> SQL>

SQL> show errors

Errors for PACKAGE APPS.PA_BUDGET_PUB:

LINE/COL ERROR

-------- -----------------------------------------------------------------

263/30   PL/SQL: Declaration ignored

263/37   PLS-00904: insufficient privilege to access object

         SYSTEM.PA_VARCHAR2_30_TBL_TYPE

265/30   PL/SQL: Declaration ignored

265/37   PLS-00904: insufficient privilege to access object

         SYSTEM.PA_VARCHAR2_240_TBL_TYPE

266/30   PL/SQL: Declaration ignored

266/37   PLS-00904: insufficient privilege to access object

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center