After our upgrade to 126.96.36.199, I see that the number of invalid objects has gone from approx 35 to about 92. I ran adadmin to compile the APPS schema - and there are still 79.You need to ensure that those database links are valid for those invalid objects to be validated.
What strikes me as odd is that most of the invalid objects are in the APPS schema - and are prefixed with either EDW_ or FII_
This is not the case in the PRODUCTION (yet to be upgraded) environment.
Is there something I am missing in the upgrade process?
What is the significance of the DB link EDW_APPS_TO_WH? Can this be the reason why the EDW_ objects are uncompiled?
You need to ensure that those database links are valid for those invalid objects to be validated.I just went through both notes - 412032.1 & 554036.1 - dropped and re-created the DB links (not sure how to go about testing them since they connect within the same instance). Then ran adadmin for the recompile of the APPS schema - but I am back to 79 invalid objects.
Invalid objects for the Modules EDW and FII [ID 412032.1]
EDW related Invalid Objects [ID 554036.1]
Interoperability Notes EBS R12 with Database 11gR2 [ID 1058763.1]