Succession Plan Overview

Succession Planning: For the job, you created a succession plan and ask the system to give you the people who are ready now which means they have similar skills, languages, capabilities, experience, and everything which the person who was occupying the particular job had.


Can we generate a person number based on an Alphanumeric

According to Oracle’s documentation on Person Number Generation Methods, there are three person number generation methods available for your enterprise on the Edit Enterprise page of the Manage Enterprise HCM Information task in the Setup and Maintenance work area:


Migrate seniority dates from V2 to V3

Yes, you can migrate seniority dates to version 2 from version 3 in Oracle Fusion HCM. You can run the Migrate to Version 3 of the Seniority Dates process to migrate the seniority dates data to the new version (V3) from earlier versions (V1 or V2). Use the Scheduled Processes work area to schedule and run the process.


Limit the size of photo upload

You can't upload photos of sizes more than 20 MB or larger. Since large-sized photos are causing a performance issue, an error is added to prevent users from uploading photos of size 20 MB or larger. The recommended size for photos remains equal to or less than 2 MB.


A work relationship has been canceled

I did some research and found that, since we canceled the work relationship, all the employment details got purged but the person details remain in the system. So, all you need to do is perform a New Hire again and let the system identify the


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


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?


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.