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…

Hi Surya, Can you please try to use CAST function? Thanks.

Hi PamS, As per my understanding, it is not possible to create a custom SA in your SaaS environment. You can do it in Fusion Analytics Warehouse if you have subscribed for that. Thanks.

Hi Pam, Can you please confirm if you have run Import Oracle Fusion Data Extensions for Transactional Business Intelligence process? While defining the flexfield attributes, check the BI enabled checkbox and then run this process. The flexfields will start appearing in the SA. You will be easily identify the attribute from…

Hi Pam, You can use User Keys and skip the Source System Id and Source System owner attributes. In this application will auto generate these Ids. However, it is advisable to use these keys using HDL. You can put it any logic to generate the source system ID like Talent Profile_ProfileCode_ContentItem_Date From Any code…

Hi Pam, To update existing records,you will need to use the existing source system keys. For that you will need to query hrc_integration_key_map table. Use below joins: HRT_PROFILE_ITEMS HPI, HRC_INTEGRATION_KEY_MAP HIKM, HRT_PROFILES_B HPB WHERE HIKM.SURROGATE_ID = HPI.PROFILE_ITEM_ID AND HPI.PROFILE_ID = HPB.PROFILE_ID…