Hi @User_WZDVD, Please change EMP.ACTUAL_TERMINATION_DATE BETWEEN TO_DATE(:"From") AND TO_DATE(:"To") To EMP.ACTUAL_TERMINATION_DATE BETWEEN TO_DATE(:FromDt) AND TO_DATE(:ToDt) Thanks.

Hi @AjayKumar Maddipati, You can drop an email to cloudconnect-help_ww@oracle.com team and share the details of your new Org with the team. The team will help you to carry forward the same account to your new email. Thanks.

Hi @Abhishek Bagh , Which subject area you are using? Thanks.

Hi @Brennan, Can you see any difference between the records created from UI and from HSDL in PER_ASSIGNMENT_EXTRA_INFO_M table? Hi @Raghavendra Raghunath-Oracle , Can you please help here? Thanks.

Hi @Vibha Pandey , Ultimately Manager is a Person, so if you join Manager Person Number with Person Real Time.Person Number , you can get NID from Person real time SA. Thanks.

One option I can see it working is to make use of Logical SQL. Thanks.

Hi @Abhishek Bagh , I think you will need to use a Logical SQL to get the results. Thanks.

Hi @Nagaraju P , Can you confirm if the DFF attribute is set is BI enabled at setup level? Thanks.

Hi Mike, There is no such functionality available currently. An idea was raised for same but I can see that in declined status: https://community.oracle.com/customerconnect/discussion/589757/oracle-bip-datamodel-default-views-table-view-and-200-rows-possible Thanks.

Please check if below helps: http://fusionhcmconsulting.com/2021/03/reports-bip-query-to-get-correct-time-zone/ Thanks.

Hi @PamS, Did the above query work as expected? Thanks.

Hi, As per my understanding FAW is mostly for high level management reports like KPI's, dashboards etc. Thanks.

Hi @User_75PCQ , It will be a mix of both OTBI and BI Publisher reports. You can easily create drag and drop day to day transactions reports using OTBI but it doesn't have the capability like Discoverer to write your own code and call external registered functions. Thanks.

Hi Pam, Please check if below helps: SELECT DISTINCT to_char(pjfv.effective_start_date, 'dd/mm/yyyy') effective_start_date, to_char(pjfv.effective_end_date, 'dd/mm/yyyy') effective_end_date, pjfv.job_code job_code, pjfv.name job_name, pjfv.attribute1 comp_group, pjfv.set_id job_set_id, decode(pjfv.active_status, 'A',…

In the main select, you will need to change below: pjftl.job_family_name --> pjfv.job_family_name Thanks.

Hi @PamS You want to show data as of effective start date of valid grades? or any other table? It will depend upon your date conditions. Try with below: AND ( pvjf.effective_start_date BETWEEN pjftl.effective_start_date AND pjftl.effective_end_date OR pvjf.effective_start_date >= sysdate ) Thanks.

Glad it worked @PamS. Do let me know if you need any other details. Thanks.

Hi Pam, This is very strange. You can view the logic on below link: https://docs.oracle.com/en/cloud/saas/human-resources/21c/oedmh/global-human-resources.html#perjobsfvl-3355 The logic is very simple. Please see if below helps: SELECT DISTINCT to_char(pvgf.effective_start_date, 'dd/mm/yyyy') effective_start_date,…

Hi @PamS , Please share the modified query. I can take a look. Thanks.

Hi Pam, Please check if below helps: SELECT DISTINCT TO_CHAR (pvgf.effective_start_date, 'DD/MON/YYYY') effective_start_date, TO_CHAR (pvgf.effective_end_date, 'DD/MON/YYYY') effective_end_date, pjfv.job_code, pjfv.name job_name, pgfv.grade_code, pgfv.name grade_name, pvgf.valid_grade_id, pgfv.grade_id, pjfv.job_id FROM…