Oracle Fusion HCM Knowledge Hub

 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...

  Change Hire Date of an Employee while assignment with 'Synchronization from Position' action exists for an employee?   Solution:   We cannot delete the 'Synchronization from Position' record and this is an expected functionality. However, as a workaround, You may use the following sample dat file to change the Action Code on the Assignment split created by position Sync ESS Job   METADATA|WorkTerms|EffectiveStartDate|EffectiveEndDate|AssignmentId|ActionCode|ReasonCode|EffectiveSequence|EffectiveLatestChange|PersonNumber|DateStart|WorkerType|AssignmentType|PeriodOfServiceId|AssignmentNumber MERGE|WorkTerms|2021/01/01|4712/12/31|ASSIGNMENT_ID|ASG_CHANGE||2|Y|PERSON_NUMBER|2021/01/01|E|ET|PERIOD_OF_SERVICE_ID|ETPERSON_NUMBER METADATA|Assignment|EffectiveStartDate|EffectiveEndDate|AssignmentId|ActionCode|ReasonCode|EffectiveSequence|EffectiveLatestChange|PersonNumber|DateStart|WorkerType|AssignmentType|PeriodOfServiceId|AssignmentNumber|WorkTermsNumbe...