Run Diagnostics — Everything you need for Troubleshooting.
I think Run Diagnostics Test feature of Oracle is under-rated.It is so useful and still not being used much ,So I though of putting its advanatge in this Blog.
Suppose, You are a Business user or a functional consultant with no technical knowledge or don't know which table contains which data and need to know details for an employee (ofcourse you can do from UI,But you need some extra details ,history , who columns,and all related details) or take a scenario where for an employee ,you want to diagnose an issue.
There are multiple, in bulit diagnostic test provided by Oracle such as
“Absence Diagnostic Data collection”,
“User Details Diagnostic Test ” or want to know more details of an approval transaction then go with “Fetch Transaction Details” and on top of that its so simple to use.
Let me take an example of “Absence Diagnostic Data collection”.
Suppose , I want to know full history for an employee like -
When he was enrolled,
His absences,
His carry over, adjustment ,who uploaded etc ..
then I will run this test and below are the details ..
Inside Troubleshooting >>Run Diagnostics Test
Search with Test name :for this example, I am searching with Absence Diagnostic Data collection,
Add to test,
Input required input value , which in case will be person_number anc click on run
Go to Run status and clink on Report icon after expanding to one level
and here you see the full Report with all tables and values :
you get data of Absence Entry Details,Absence events ,
enrollmant history data, accrual entries details,absence plan details, hr related tables like per_all_people_f , assignment data , work relationsip data, formula used etc
Other Important links are —