If you want to submit any scripts useful for Apps DBA's then
Mail Me.
* Thanks to Vish for sharing these scripts with Other Oracle
apps DBA. These scripts are mentioned here for information only, Please test these before
executing them on Production Instance
/* to find the base application version */
select ARU_RELEASE_NAME||'.'||MINOR_VERSION||'.'||TAPE_VERSION version, START_DATE_ACTIVE
when updated,
ROW_SOURCE_COMMENTS "how it is done" from AD_RELEASES where BASE_RELEASE_FLAG = 'Y'
/* To find all available application version */
select ARU_RELEASE_NAME||'.'||MINOR_VERSION||'.'||TAPE_VERSION version, START_DATE_ACTIVE
when updated,
END_DATE_ACTIVE "when lasted", CASE WHEN BASE_RELEASE_FLAG = 'Y' Then 'BASE VERSION' ELSE
'Upgrade' END "BASE/UPGRADE", ROW_SOURCE_COMMENTS "how it is done"
from AD_RELEASES
/* To get file version of any application file which is changed through patch application */
select A.FILE_ID, A.APP_SHORT_NAME, A.SUBDIR, A.FILENAME, max(B.VERSION) from AD_FILES A,
AD_FILE_VERSIONS B where A.FILE_ID = B.FILE_ID
and B.FILE_ID = 86291
group by A.FILE_ID, A.APP_SHORT_NAME, A.SUBDIR, A.FILENAME
|
Previous Page
|
Next Page
|