SQL Query to get all the security profiles based on roles

SELECT r_code.*,"Role Code" || ' - '||"Role Name"|| ' - '||"Job Role Name" || ' - '||"Organization Security Profile"|| ' - '||"Position Security Profile"|| ' - '||"Country Security Profile"|| ' - '||"LDG Security Profile"|| ' - '||"Person Security Profile"|| ' - '||"Public Person Security Profile"||' - '||"Document Type Security Profile"||


Get the list of area of responsibility assigned to the user

select        papf.person_number,        ppnf.display_name,        paaf.assignment_number,


Anytime Feedback Section Overview

Feedback Given to Me: In this section, Employees can see feedback given by others in the organization to him/her. An employee can also add feedback for themselves and select feedback visibility for the Feedback. He/she can also edit the feedback that they give to themselves. He/she can hide, show, and send the thank you message to them from whom they have received the feedback.


Instance Qualifiers Overview

Instance Qualifiers are nothing but a group of codes that we used to uniquely identify different occurrences of the same profile item maybe a competency, maybe a performance rating, because in talent management the competencies, the ratings, will be used by different people on different occasions, it's not that only rating will from the performance


What are tasks that Manager can perform in Goal?

Assign a performance goal to your reports within the goal plan with a review period. · Add target outcomes, if enabled, to goals and automatically update the person profiles of your reportees. · Add and update tasks to provide specific actions that determine how your reportees can achieve their goals. · Align the goals of your reportees to other goals.


What are the places where we can use competencies

In Performance Document – As a Competencies Section In Career Development – As a Target Outcomes In Employee – In Skills and Qualifications – As a Competencies


What we need to do if we are not getting any data in Talent Profile

There are some schedule processes that we need to run in order to get the data in the Talen profile Job 1: Update Person Search Keywords Batch ID-1, After Batch Load-YES Job 2: Optimize Person Search Keywords Index


What is the thing we need to consider to create a performance document

Standard, for typical performance documents, such as annual or project or company-wide evaluations. · Anytime, for performance documents that managers and workers can create at any time to evaluate the worker’s performance.


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