OTBI Report

Shivam Naugraiya

is there any report for the showing the employee with missing personal information like address missing , pin code missing , department missng

Nathan CCC

Hi Shivam,

Not out of the box since the vendor cannot know which optional fields you consider "required".

But to find the exceptions you can write your own custom query from a subject area in OTBI.

select all t.p from t  where (t.x is null or t.y is null or t.z is null)

Nathan

Shivam Naugraiya

oh my understanding, there suppose to be some standard report for the missing standard data fields like address pin code email address , that can we extended further with new fields.

is there any report for the missing address/phone number you can suggest or should i post for improevment ideas

Nathan CCC

Hi,

If a field is mandatory then it cant be missing. So consider making your required fields mandatory.

Here is the list of analytics and reports in HCM. You may find something you can use in here.

https://docs.oracle.com/en/cloud/saas/human-resources/24b/analyze-and-report.html

https://www.oracle.com/docs/tech/hcm-reports.xls