Oracle Fusion HCM Knowledge Hub

How to enable Global Search in Fusion Applications 1) Login to Fusion 2) Navigate to ‘Setup and Maintenance’ 3) Search for task: “Manage Administrator Profile Values” 4) In the ‘Profile Option Code’ Field input value: “FUSION_APPS_SEARCH_ENABLED” 5) Select Search 6)   Navigate to ‘Setup and Maintenance’ 7)   Search for task: “Manage Global Search Configurations”     8) Duplicate the HCM configuration and create a new one with different name. Save and Close the details. 9) Global search will be available in the home page    

  1.        Click on Menu 2.        Navigate to   Tools-> Security Console-> Roles 3.        Search for Role 4.        In the function security policy, add Impersonate User privilege. Save the details.  Attach the role to set of users.  5.        Login to user and navigate to S ettings & Actions Menu > Set Preferences   6.        Click on Action> Create 7.        Search the employees for proxy use and click on apply 8.        Login from the proxy user and Navigate to Settings & Actions Menu 9.        Click on Switch To      10. Login to the proxy user, enter password and start using the application.  

 Query to get below details corresponding to a DFF in Fusion: DESCRIPTIVE_FLEXFIELD_CODE, CONTEXT_CODE, SEGMENT_CODE, NAME, COLUMN_NAME, VALUE_SET_CODE, DISPLAY_TYPE, PROMPT, SHORT_PROMPT, ENABLED_FLAG, REQUIRED_FLAG, READ_ONLY_FLAG, DESCRIPTION, SEQUENCE_NUMBER, BI_ENABLED_FLAG ********************************************************************************************************************** SELECT fdsv.descriptive_flexfield_code ,fdsv.context_code ,fdsv.segment_code ,fdsv.name ,fdsv.column_name ,fvvs.value_set_code ,fdsv.display_type ,fdsv.prompt ,fdsv.short_prompt ,fdsv.enabled_flag ,fdsv.required_flag ,fdsv.read_only_flag ,fdsv.description ,fdsv.sequence_number ,fdsv.derivation_value ,fdsv.bi_enabled_flag FROM fnd_df_segments_vl fdsv, fnd_vs_value_sets fvvs WHERE fdsv.value_set_id = fvvs.value_set_id(+) AND fdsv.descriptive_flexfield_code = 'PER_ASG_DF'

Below is the query to get the HDL file information if the UCM ID is known :  SELECT * FROM hrc_dl_file_lines  WHERE data_set_bus_obj_id IN  (SELECT data_set_bus_obj_id FROM hrc_dl_data_set_bus_objs WHERE data_set_id IN  ( SELECT data_set_id FROM hrc_dl_data_sets WHERE ucm_content_id = 'UCMXXXXXX'))

  How to Create a Read Only User in Oracle Fusion Navigation : Setup and Maintenance » Search » Search task “Manage administrator profile Values” Search for Profile Option Code “FND_READ_ONLY_MODE” Under section “FND_READ_ONLY_MODE: Profile Values” click on Action and then select “New”. Add the below details: Profile Level User User Name username@username.com Profile Value Enable   Click on “Save and Close”

  Configuration of Life Event Enrollment Certification Requirement in Fusion Benefit Documents that participant must provide to complete or to finish enrollment in a benefit offering. The documents include birth certificates, marriage certificates, proof of good health, evidence of insurability etc. 1) Navigation to setup the same: Benefit Administrator -> Plan Configuration -> Program and Plans -> Plan Search for plan and navigate to Certifications 2) Select the option for which EoI need to be configured: 3) For Second option against life event, evidence of Insurability needs to be configured:  Option -> Enrollment Certifications -> Life Event   Life Event Open Action Item: Required Yes Due Date 30 days after life event   4) Configuration required to add a certification:   Life Event -> Select and Add -> Certification Type -> Determina...

 SELECT distinct papf.person_number PERSON_NUMBER, (select full_name from per_person_names_f ppnf where ppnf.person_id = papf.person_id and name_type = 'GLOBAL' and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date) person_name, ple.name LEGAL_EMPLOYE, 'W4 Change' ACTION_NAME, (select hl.meaning from hr_lookups hl where hl.lookup_type = 'HRX_US_FEDERAL_FILING_STATUS'         AND hl.lookup_code = ri_old.value1) as OLD_DATA, (select hl.meaning from hr_lookups hl where hl.lookup_type = 'HRX_US_FEDERAL_FILING_STATUS'         AND hl.lookup_code = ri.value1) as NEW_DATA ,TO_CHAR(ri.effective_start_date, 'MM/DD/YYYY') EFFECTIVE_DATE ,TO_CHAR(ri.creation_date, 'MM/DD/YYYY') CHANGED_DATE ,ri.LAST_UPDATED_BY CHANGED_BY         FROM   fusion.Pay_Value_Definitions_Vl    Vd               ,fusion.Pay_Value_Definitions_Vl    V...

 SELECT papf.person_number PERSON_NUMBER, (select full_name from per_person_names_f ppnf where ppnf.person_id = papf.person_id and name_type = 'GLOBAL' and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date) person_name, ple.name LEGAL_EMPLOYE, (CASE  when cs.SALARY_BASIS_CODE = 'ANNUAL' THEN 'Salary Change'  else  'Hourly Rate Change' end)  ACTION_NAME, to_char(cs_old.salary_amount) OLD_DATA,  to_char(CS.salary_amount) NEW_DATA    ,TO_CHAR(cs.date_from, 'MM/DD/YYYY') EFFECTIVE_DATE    ,  TO_CHAR(cs.creation_date, 'MM/DD/YYYY') CHANGED_DATE    , cs.LAST_UPDATED_BY CHANGED_BY           from  fusion.CMP_SALARY cs,           CMP_SALARY cs_old,   PER_ALL_ASSIGNMENTS_M  PAAM,   PER_ALL_PEOPLE_F PAPF   ,per_legal_employers ple          where 1 = 1    AND PAPF.PERSON_ID = P...

********************************************************************************** Columns : Person Number, Name, Legal Employer Name, Action Name,Start Date, Changed Date, Changed By Parameter : Start Date and End Date *********************************************************************************** SELECT PAPF.PERSON_NUMBER PERSON_NUMBER, (select full_name from per_person_names_f ppnf where ppnf.person_id = papf.person_id and name_type = 'GLOBAL' and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date) person_name,        ple.name LEGAL_EMPLOYE,    PAV.ACTION_NAME,    NULL OLD_DATA,    to_char(paam.effective_start_date,'MM/DD/YYYY') NEW_DATA,        TO_CHAR(paam.effective_start_date, 'MM/DD/YYYY') EFFECTIVE_DATE,    TO_CHAR(paam.creation_date, 'MM/DD/YYYY') CHANGED_DATE,    paam.LAST_UPDATED_BY CHANGED_BY   FROM FUSION.PER_ALL_PEOPLE_F PAPF,   ...

  How to configure dependent Coverage Start Date same as employee coverage start date in fusion Benefit. In many scenarios we observed that coverage start date is incorrect when enrolling and designating a dependent. The date should be same as the date of enrollment or in some cases same as the employee enrollment start date. Solution : To implement the solution, please execute the following steps: 1.        Go into the responsibility: Benefits Administrator 2.        Navigate to Program --> Query the Program 3.        Navigate to the Designation Requirements                4.        Select the Plan Type                5.        Select the Life Event Tab and add the Life Event which need to be evaluated:      ...

HSDL to Load Element Entry and Element Entry Rollback Element entries are used to capture earnings, deductions, absences, and basic benefit details for an employee assignment. The element entry values hold the necessary values for the element type. For example, a salary entry can contain the salary value and the salary frequency. Parameter Value Legislative Data Group USA Legislative Data Group Element Name Commutation Allowance Assignment Number E3141464 Start Date 01-Apr-2021   Entry Value 1 Parameter Value Legislative Data Group USA Legislative Data Group Element Name Commutation Allowance Assignment Number E3141464 Start Date 01-Apr-2019 Input Value Name Amount Screen Entry Value 3456 HSDL Selected Attr...