I discovered a utility in R12.2 when I was looking for the directory of adop :
which adop
$NE_BASE/EBSapps/appl/ad/bin/adop
cd $NE_BASE/EBSapps/appl/ad/bin/
$ ls
adop adopreports
Curious I executed adopreports
$ adopreports
Enter the APPS username: apps
Enter the APPS Password:
Online Patching Diagnostic Reports Main Menu
--------------------------------------------
1. Run edition reports
2. Patch edition reports
3. Other generic reports
4. Exit
Enter your choice [4]: 3
Other Generic Reports Sub Menu
------------------------------
1. Editions summary
2. Editioned objects summary
3. Free space in important tablespaces
4. Status of critical AD_ZD objects
5. Actual objects in current edition
6. Objects dependencies
7. Objects dependency tree
8. Editioning views column mappings
9. Index details for a table
10. Inherited objects in the current edition
11. All log messages
12. Materialized view details
13. Database sessions by edition
14. Table details (Synonyms, EV, etc.)
15. Count and status of DDL execution by phase
16. Back to main menu
This is a great utility for R12.2
which adop
$NE_BASE/EBSapps/appl/ad/bin/adop
cd $NE_BASE/EBSapps/appl/ad/bin/
$ ls
adop adopreports
Curious I executed adopreports
$ adopreports
Enter the APPS username: apps
Enter the APPS Password:
Online Patching Diagnostic Reports Main Menu
--------------------------------------------
1. Run edition reports
2. Patch edition reports
3. Other generic reports
4. Exit
Enter your choice [4]: 3
Other Generic Reports Sub Menu
------------------------------
1. Editions summary
2. Editioned objects summary
3. Free space in important tablespaces
4. Status of critical AD_ZD objects
5. Actual objects in current edition
6. Objects dependencies
7. Objects dependency tree
8. Editioning views column mappings
9. Index details for a table
10. Inherited objects in the current edition
11. All log messages
12. Materialized view details
13. Database sessions by edition
14. Table details (Synonyms, EV, etc.)
15. Count and status of DDL execution by phase
16. Back to main menu
This is a great utility for R12.2