How to disable notification in talent management
Set and Maintenance > Task > Search > Manage Task Configurations for Human Capital Management > Click on Administration Tab > Find Notification Mode then select none and save
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
Load the metadata file for terminate an employee using HDL
Dat File Name: Worker.dat 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
Categories
- All Posts
- 01. Common for all modules
- 02. Questionnaire For Client
- Absence Management (DEFINITION)
- Absence Management (HDL Templates)
- Absence Management (ISSUES)
- Absence Management (REQUIREMENT)
- Benefit Management (DEFINITION)
- Compensation Management (DEFINITION)
- Compensation Management (FAQ)
- Compensation Management (ISSUES)
- Fast Formulas (FF)
- Global Human Resource (DEFINITIONS)
- Global Human Resource (FAQ)
- Global Human Resource (HDL Templates)
- Global Human Resource (ISSUES)
- HDL Templates (Data Loader)
- Human Resource Helpdesk (DEFINITION)
- Journeys (FAQ)
- Oracle Learning Cloud (DEFINITION)
- Oracle Learning Cloud (FAQ)
- Oracle Learning Cloud (HDL Templates)
- Oracle Learning Cloud (ISSUES)
- Oracle Payroll Cloud (HDL Template)
- Oracle Recruiting Cloud (DEFINITION)
- Oracle Recruiting Cloud (FAQ)
- Oracle Recruiting Cloud (ISSUES)
- Oracle Time and Labor (DEFINITION)
- Oracle Time and Labor (ISSUES)
- OTBI Report
- Redwood_Visual Build Studio_RWPHT (DEFINITION)
- Redwood_Visual Build Studio_RWPHT (FAQ)
- Redwood_Visual Build Studio_RWPHT (ISSUES)
- Spreadsheet Loaders (HSDL)
- SQL Queries (SQLQ)
- SQL Queries + HDL Template
- Talent Management (DEFINITION)
- Talent Management (FAQ)
- Talent Management (HDL Templates)
- Talent Management (ISSUES)
- Technical Contents (DEFINITION)
- Touchpoints (DEFINITION)
- Touchpoints (FAQ)