Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12.2.8: Insufficient privileges to objects in APPS_NE

edited Aug 20, 2021 10:18AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered

Hello,

We recently upgraded to r12.2.8 from r12.1.3.    There are custom objects which got moved to APPS_NE schema.   These are non-editioned objects.    Some packages are dependent on these objects and we are unable to compile them

ERROR at line 1:

ORA-06552: PL/SQL: Compilation unit analysis terminated

ORA-06553: PLS-904: insufficient privilege to access object

APPS_NE.KESX_TYP_ITM_STAT_INFO_NESTED

OWNER      OBJECT_NAME                    OBJECT_TYPE             STATUS

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

APPS       KESX_TYP_ITM_STAT_INFO_NESTED  SYNONYM                 VALID

APPS_NE    KESX_TYP_ITM_STAT_INFO_NESTED  TYPE                    VALID

Please let us know, what privileges should be granted.

Tagged:

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