Hello,
DB: 12.1.0.2
EBS APP: 12.2.5
have around 30 invalid objects that cannot be recompiled!
(after successful compilation they change to invalid instantly)
Tried to recompile dependencies, used utlrp.sql, no success.
Checked dba_dependencies for problematic package 'OE_DEFAULT_PVT' , and found there is only one record there (the original one).
The same in the dependencies table (sys.dependency$), checked the same object in TEST environment and there everything is ok (around 40 depended objects).
Any help or direction would be much appreciated!
Regards,
Kris