Get the list of work email address to be flagged as primary email
Select pea.email_address_id, papf.person_id, pea.email_type,pea.email_address, case when pea.email_address_id = papf.primary_email_id then 'Y'
SQL Query to get the list of failed approval transactions
SELECT d.*-- h.transaction_id, d.state,d.status,h.module_identifier, h.CREATION_DATE FROM HRC_TXN_HEADER h,HRC_TXN_DATA d WHERE h.Transaction_id = d.Transaction_id and h.transaction_id = 000000000000000
Employee cannot add the specific absence type in the future date
A client wants the employee cannot add the absence type in the future date, it should be today’s day only. We have written the fast formula. DEFAULT FOR IV_START_DATE is '0001/01/01 00:00:00' (Date) INPUTS ARE IV_START_DATE (Date)
SQL Query to get the employee person id with person number
select * from per_all_people_f where person_number= '1734'
SQL Query to get the absence entry id, absence type id, absence start date and absence end date
select per.person_number,PER_ABSENCE_ENTRY_ID ,abs.absence_type_id, abs.name absence_type, to_char(apae.start_date,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') start_date, to_char(apae.end_date,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') end_date, duration from ANC_PER_ABS_ENTRIES apae, PER_PERIODS_OF_SERVICE pps, PER_ALL_PEOPLE_F per,
Load metadata file for License and Certification using HDL
ContentItem.dat METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name MERGE|ContentItem||LC063||1951/01/01|CERTIFICATION|U|103|Supervision of Aerosols
Talent Review Meeting Overview
In the talent review module after the performance appraisal is completed generally all the managers who have the sub ordinates and already whom they have rated will set together in a meeting room and you will have a talent review dashboard, a talent review dashboard consist of some box chart and all the managers will set together and they will have
How to visible attachment attribute on development goal
Activate the sandbox 1. Navigator 2. Configuration
Not able to change the hire date of an employee
Reason/Root Cause: Kindly Check for all the Child Records for Employment and Personal Details. Example: Salary, Payroll Relationship, Element Entries, DOR, AOR etc.
You cannot deselect using the HCM Position Hierarchy because the line manager is synchronized from the position hierarchy
You cannot deselect using the HCM Position Hierarchy because the line manager is synchronized from the position hierarchy. (PER-1531935)
In the core HR when you hire an employee then in the backend this this employee is also created the user account, if I am creating an agent, so also will it create the user account for this agent?
In the core HR when you hire an employee then in the backend this this employee is also created the user account, if I am creating an agent, so also will it create the user account for this agent or not?
What are the stages for that you can setup the approval?
Requisition and Offer
Areas of responsibility Overview
AOR is work based on representative types (HR, Payroll, Admin, IT) AOR tag on based on employment fields (Department, Business Unit, Legal Entity, Location) Example: -
List of assignment status
Assignment Status > HR Status > Payroll Status Active - payroll eligible > Active > Process Active - no payroll > Active > Do not process Active - process when earning > Active > Process when earning
Converting a Pending Worker
You convert a pending worker to an employee using the Convert Pending Worker. The Convert option populates the hiring record for the pending worker based on details from the pending worker record.
Security Overview
Abstract Role: Abstract role are those roles that provide you the access to basic functionalities to the application. · Abstract roles are not dependent on any kind of job that you perform. It will give you basic data access that is related to an employee. · Employee is a very good example of an Abstract role. · Line Manager · Contingent Worker · Hiring Manager
SQL Query to get the content id for license and certification
Select ITEM.CONTENT_ITEM_ID, ITEM.CONTENT_TYPE_ID, ITEM.CONTENT_ITEM_CODE,ITEM.DATE_FROM, ITEM.BUSINESS_GROUP_ID, TL.NAME, TL.ITEM_DESCRIPTION, TYPE.CONTEXT_NAME, ITEM.CREATED_BY, ITEM.CREATION_DATE, ITEM.LAST_UPDATED_BY, ITEM.LAST_UPDATE_DATE
Load metadata file for goal using HDL
METADATA|Goal|GoalId|GoalName|Description|StartDate|TargetCompletionDate|AssignmentId|OrganizationId|PersonId|WorkerPersonNumber|StatusCode|GoalSourceCode|AllowKeyAttrUpdateFlag|AssignedByPersonId|PublishedFlag MERGE|Goal|300000000000000|Strengthen and model a Culture of Accountability, Agility and Business Acuity and the Rewards and Consequences required to support it||2018/01/01|2018/12/31|400000000000000||100000000000000|20000000|NOT_STARTED|HR|N|500000000000000|
Employee is having an assignment with some direct reportees, and user wants to change the legal employer hire date
A user wants to change the legal employer hire date from 1st Feb 2021 to 1st Jan 2021, but they are not able to change the hire date of an employee.
FUN-720323A scope value was not selected
FUN-720323A scope value was not selected. Return to the task list and use an implementation project to select a scope value prior to selecting the task.