Unable to recompile invalid package bodies
Hello,
Recently, I cloned the EBS installation, and there were a lot of invalid objects. I used the script to recompile them, and they went fine except for some package bodies, that can't be recompiled neither manually via sqlplus, nor sqldeveloper. Tried also via adadmin, there is no way to be recompiled.
There are 39 packages owned by apps schema as follows:
SQL> select object_name, object_type, owner, status
2 from dba_objects where status='INVALID';
OBJECT_NAME OBJECT_TYPE OWNER STATUS
-------------------
-------
FII_AP_INV_ON_HOLD_F_C PACKAGE BODY APPS INVALID
FII_AP_HOLD_DATA_F_C PACKAGE BODY APPS INVALID
Recently, I cloned the EBS installation, and there were a lot of invalid objects. I used the script to recompile them, and they went fine except for some package bodies, that can't be recompiled neither manually via sqlplus, nor sqldeveloper. Tried also via adadmin, there is no way to be recompiled.
There are 39 packages owned by apps schema as follows:
SQL> select object_name, object_type, owner, status
2 from dba_objects where status='INVALID';
OBJECT_NAME OBJECT_TYPE OWNER STATUS
-------------------
-------
FII_AP_INV_ON_HOLD_F_C PACKAGE BODY APPS INVALID
FII_AP_HOLD_DATA_F_C PACKAGE BODY APPS INVALID
Tagged:
0