Getting ORA-04023 errors on any query against fnd_lookups view after applying any patch.
SQL> select count(*) from fnd_lookups
2 where rownum < 10;
select count(*) from fnd_lookups
*
ERROR at line 1:
ORA-04023: Object select count(*) from fnd_lookups where rownum < 10
We are able to restore functionality by manually compiling fnd_lookups and any other invalid objects. But what's wrong with our patching process? We use a hosting provider for our DBA services so I can't do much diagnosis myself, but would appreciate any suggestions that I could relay to our provider. We are on R12.1.3 and dataase 11.2.0.2.0. Note: The patches we are applying are often simple updates to database packages and have nothing to do with fnd_lookups.