Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI Report

Received Response
12
Views
3
Comments
Shivam Naugraiya
Shivam Naugraiya Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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

Tagged:

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited June 5

    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
    Shivam Naugraiya Rank 1 - Community Starter

    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
    Nathan CCC Rank 7 - Analytics Coach

    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