OTBI Report

Question

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

Nathan CCC · Answer

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

Shivam Naugraiya · Answer

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 · Answer

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