What is current view APPL_TOP snapshots

Last updated on July 17th, 2015 at 06:05 pm

 1) It is record the current set of files and file versions in your APPL_TOP 
2) Current view snapshots are created once and updated when appropriate to maintain a consistent view of the APPL_TOP content
3)You must run AD Administration “Maintain snapshot information” once for each APPL_TOP before you can apply any patch that contains a “compatible feature prereq” line on that APPL_TOP. Running AD Administration “Maintain snapshot information” for an APPL_TOP completely populates the APPL_TOP’s current view snapshot. This complete information is required for the automatic prerequisite patch checking feature to give correct results.
4)AutoPatch automatically updates the list of file versions and bug fixes in the current view snapshot for each APPL_TOP as patches are applied to that APPL_TOP. The combination of running AD Administration “Maintain snapshot information” once for an APPL_TOP and AutoPatch’s incremental updates ensures that the current view snapshot for a given APPL_TOP contains an accurate picture of the current set of files and bug fixes present in that APPL_TOP.
5) APPL_TOP snapshot information is stored in the AD_SNAPSHOTS, AD_SNAPSHOT_FILES, and AD_SNAPSHOT_BUGFIXES tables

Issues with Generating current View snaphot
1) Sometime it hangs .Following solution can be used
exec fnd_stats.gather_table_stats(‘APPLSYS’,’AD_SNAPSHOT_FILES’);
exec fnd_stats.gather_table_stats(‘APPLSYS’,’AD_SNAPSHOT_BUGFIXES’);
exec fnd_stats.gather_table_stats(‘APPLSYS’,’AD_SNAPSHOTS’);
exec fnd_stats.gather_table_stats(‘APPLSYS’,’AD_FILE_VERSIONS’);
exec fnd_stats.gather_table_stats(‘APPLSYS’,’AD_CHECK_FILE_TEMP’);
exec fnd_stats.gather_table_stats(‘APPLSYS’,’AD_PATCH_HIST_TEMP’);
exec fnd_stats.gather_table_stats(‘APPLSYS’,’AD_SNAPSHOT_FILES_TEMP’);
exec fnd_stats.gather_table_stats(‘APPLSYS’,’AD_FILES’);

Leave a Reply