Getting Benefit eligibility profiles when adding an eligibility profile on goal eligibility profile page

Yes, this is the delivered functionality, we have verified in the demo. Went inside the goals page and we are able to see the "Benefits" profile usage eligibility profiles.


Load metadata file for Talent Profile using HDL

Dat File Name: TalentProfile.dat METADATA|ProfileItem|ProfileCode|ContentTypeId|SectionId|DateFrom|RatingModelId1|RatingLevelId1|SourceSystemOwner|SourceSystemId


Load metadata file for an Area of responsibility (AOR) using HDL

Dat File Name:  METADATA|AreasOfResponsibility|AsgResponsibilityId|ResponsibilityName|ResponsibilityType|StartDate|EndDate|Status|PersonId|PersonNumber|AssignmentId|AssignmentNumber|LocationCode|LocationSetCode


SQL Query to get Goal Plan Assignment id, Goal Plan Id, Assignment Id, Goal Plan Name, Person Number

select "HRG_GOAL_PLN_ASSIGNMENTS"."GOAL_PLAN_ASSIGNMENT_ID" as "GOAL_PLAN_ASSIGNMENT_ID", "HRG_GOAL_PLN_ASSIGNMENTS"."GOAL_PLAN_ID" as "GOAL_PLAN_ID", "HRG_GOAL_PLN_ASSIGNMENTS"."ASSIGNMENT_ID" as "ASSIGNMENT_ID",


SQL Query to get the approval transaction id details

Select Txnd.Status As Txn_Status ,Txnh.Module_Identifier ,p.person_number ,txnh.CREATION_DATE ,Txnh.Transaction_Id


How to create a Pending Worker manually from the Manage Job offer page

Job Offer is only used in the ORC when the job offer is signed(when the candidate is in the Offer accepted phase), the candidate then can be moved to HR as a pending worker, and the job offer contains info that is moved also to HR like Name, DOB, Position, Department, once the candidate is moved to HR as a pending worker then it cannot be reverted and go back as a candidate.


Steps to create the prerequisite for an offer letter

Prerequisite – 1 – As the recruiter create one offer and keep it as draft 2 – Go to XMLPSERVER Shared Folder/Human Capital Management/Recruiting/Job Offer/Job Offer Letter à Click on more and customize 3 – Copy the data model of the offer letter and paste it into the custom folder


Double Opt-In Management?

You enable double opt-in so that external candidates can opt-in to receive job alerts and recruiting marketing communications when they apply for a job when they sign in to a talent community, or from their candidate self-service page. When candidates are opt-in, they receive a message confirming their selection.


How to Activate the Contingent Worker Setting?

1. Enterprise Recruiting and Candidate Experience Information 2. In the Contingent Worker is External Candidate section, select Active 3. Submit the Contingent Worker Scheduled Process You need to submit the scheduled process Classify Contingent Workers in Recruiting in the Scheduled Processes work area.


How can we define 4 competencies with multiple behaviors

You can start by creating competence. My Client Group > Profile > Item Catalog > Competence  After this, you create a rating model that you associate with all the competencies. I recommend using the same rating model in all the competence so the 9BOX works properly.


Talent Management Related Access Privileges

Function Security Policies Create Succession Plan for Worker Manage Succession Plan Manage Succession Plan Candidate Use REST Service - Succession Management Lists of Values View Succession Plan


Setup to enable enhanced talent profile

Setup to enable enhanced talent profile Profile Options · HCM_RESPONSIVE_PAGE-ENABLED: set Profile Value to Y. · ORA_HRT_USER_INTERFACE_REDESIGN: set Profile Value to Y. Upgrade Security Privileges


What are the activities perform by different users in goal management

- Human Resource Specialist Actions Create Review Periods Add Goals to Goal Library Create Goal Plans Add Goals to the goal plan Add an Eligibility profile Included Workers and Excluded Workers Assign Goal Plan Mass Assign Goals


List of HCM SQL Query Tables

PERSON DOCUMENTATION HR_DOCUMENTS_OF_RECORD PAY_PAY_RELATIONSHIPS_F PAY_PAY_RELATIONSHIPS_DN PER_LDAP_REQUESTS


Load the metadata file for terminate an employee using HDL

Dat File Name:  METADATA|WorkRelationship|LegalEmployerName|PersonNumber|ActualTerminationDate|ActionCode|ReasonCode|TerminateWorkRelationshipFlag|PeriodOfServiceId


SQL Query to get the list of terminated employees

select    "PER_PERIODS_OF_SERVICE"."LAST_UPDATE_DATE" as "LAST_UPDATE_DATE",                "PER_PERIODS_OF_SERVICE"."LAST_UPDATED_BY" as "LAST_UPDATED_BY",                "PER_ALL_PEOPLE_F"."PERSON_NUMBER" as "PERSON_NUMBER"


SQL Query to get the list of seniority date version

SELECT SeniorityDateSetUp.seniority_date_code,  HcmLookup.MEANING,SeniorityDateSetUp.SENIORITY_VERSION  FROM fusion.per_seniority_dates_setup SeniorityDateSetUp,


SQL Query to extract those data that have no profile code

Select distinct papf.person_number,profile_code from PER_ALL_PEOPLE_F PAPF, HRT_PROFILES_B HPB where PAPF.PERSON_ID = HPB.PERSON_ID AND Profile_Code is NULL


SQL Query to get only active employees

EXISTS (SELECT 1 FROM PER_ALL_ASSIGNMENTS_M ASG,PER_PERIODS_OF_SERVICE PS WHERE ASG.ASSIGNMENT_TYPE IN('E','C','N','P') AND ASG.EFFECTIVE_LATEST_CHANGE='Y' AND SYSDATE BETWEEN LEAST(SYSDATE,ASG.EFFECTIVE_START_DATE) AND ASG.EFFECTIVE_END_DATE AND


Load metadata file for Department using HDL

METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|SourceSystemOwner|SourceSystemId|ClassificationCode MERGE|Organization|1951/01/01||ABC-AT-SS|ABC_SS_AT|ORG_AT_DPT_001|DEPARTMENT