ORA-04030: out of process memory while compiling XLA Package

XLA Invalid Object in R12 Application:


SQL>select object_name,object_type from dba_objects where status='INVALID';
OBJECT_NAME OBJECT_TYPE
----------------------------------- -------------------
XLA_00200_AAD_S_000010_PKG PACKAGE BODY
XLA_00200_AAD_S_000011_PKG PACKAGE BODY

SQL> alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY;
alter package apps.XLA_00200_AAD_S_000010_PKG COMPILE BODY
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 4108 bytes (PLS
non-lib hp,pdzgM64_New_Link)


Solution:

SQL> alter system set plsql_optimize_level =0;

System altered.

SQL> alter package apps.XLA_00200_AAD_S_000011_PKG compile body;

Package body altered.

SQL> alter system set plsql_optimize_level =2;


System altered.