How To Check Oracle EBS Version

Somehow we should know what version we running in. There's two ways to check it out :
1. On the application just click : Help -> About Oracle Application
2. Run this simple query : "SELECT release_name FROM app.fnd_product_groups"

Cheers :D

Check Status RMAN Backup

Some how, we need to check status our RMAN backup, so these the script :

• To check full and incremental RMAN backup with archivelog :

col status format a9
col hrs format 999.99
SELECT
session_key,input_type, status,
to_char(start_time,'mm/dd/yy hh24:mi')  start_time,
to_char(end_time,'mm/dd/yy hh24:mi') end_time,
elapsed_seconds/3600 hrs
FROM v$rman_backup_job_details ORDER BY session_key;

• Tp check full and incremental backup, not archivelog backup

col status format a9
col hrs format 999.99
SELECT
session_key, input_type, status,
to_char(start_time,'mm/dd/yy hh24:mi') start_time,
to_char(end_time,'mm/dd/yy hh24:mi') end_time,
elapsed_seconds/3600 hrs
FROM v$rman_backup_job_details
WHERE input_type='DB INCR' ORDER BY session_key;