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…

Hi Pam, SectionId is a mandatory attribute which you will need to pass. Also, please try adding DateFrom and DateTo fields as well. SourceSystemId is fine. Please check if the source system owner exist in the HRC%SOURCE%SYSTEM% lookup. Check the below link to find section id:…

Hi Pam, My apologies. You would need to use Talent Profile -> Profile Item HDL for uploading this data. Below is sample file:…

Hi Pam, You will need to use ContentItem.dat only. So, you are at correct place. Check the attached excel file to find the attribute to store certificate number. Let me know if you need any more details. Thanks. Profile_Management_Content_Template_Definitions.xlsx

Hi Chandrajit, This is incorrect forum for your question. Please post it under either under Application Security or your respective product area. Thanks.

Hi Rajneesh, Can you check the history and see if it shows the report as successfully delivered? Thanks.

Hi @Alan Lee - Oracle-Oracle, Can you please consider atleast defaulting the view option to table? Thanks.