APPL_TOP and APPS Schema Synchronization
I recently found a couple packages in APPS that were older than the version in the patch files in the APPL_TOP. It appears that for some reason, the patch files were not compiled. Possibly an error in patching a while back. adadmin has many options to recompile, maintain snapshots, etc. But nothing that will validate patch files with compiled code. Is there an AD utility, or custom utility that would validate the APPS objects against the patch files?
Example:
$grep Header ./ad/12.0.0/patch/115/sql/adddb.pls
/* $Header: adddb.pls 120.0 2005/05/25 12:10:05 appldev noship $ */
select text from dba_source where text like '%adddb.pls%' and line<5;