How to add the custom text in Impact of Loss

There is no option to add the custom text in the person profile so there is an EL expression to use to add the custom text.   #{pageFlowScope.sectionFacetName == 'ImpactOfLoss' ? "Impact of Loss (Visible to Manager Only)": pageFlowScope.pSectionName}


Talent Management Configuration Checklist Tasks

Create Item catalog Create a rating model. Create Profile Types, for e.g. Person Profile, Job Profile Secure access to content section in person profile Manage Profile Option Values Manage Goal Value Sets Manage Goal Setting Lookups Manage Goal Descriptive Flexfields Manage Goal Management Notification Settings Create a review period. Create...


Goal Management Overview

Fusion Goal Management facilitates the setting and monitoring of Goals at multiple organizational levels, supporting a continuous performance conversation all year long. High-level priorities are communicated by business executives, and line managers and employees can work together to develop goals that are in accordance with the organization's direction. To provide...


When we are clicking on the talent profile then it takes me to the different page instead of skills and qualification page

We need to add these privileges to the custom job role and regenerate the data role from the workforce structure ORA_HRT_VIEW_PERSON_SKILLS_AND_QUALIFICATION ORA_HRT_EDIT_PERSON_SKILLS_AND_QUALIFICATION ORA_HRT_VIEW_PERSON_CAREER_PLANNING ORA_HRT_EDIT_PERSON_CAREER_PLANNING


Not able to delete the performance goal of an employee

There are some goals that we are trying to delete from an employee but the delete button is coming as disabled. There could be 2 reasons and because of that, we are not able to delete the performance goal. 1. 1st scenario, if we initiated the Performance Document or Check-In...


Load metadata file for adjust the absence balance using HDL

Dat File Name: PersonAccrualDetail.dat METADATA|PersonAccrualDetail|PersonNumber|WorkTermsNumber|PlanName|AccrualType|Value|ProcdDate|AdjustmentReason|SourceSystemId|SourceSystemOwner MERGE|PersonAccrualDetail|1000|ET1000|Annual Leave Plan|INIT|10|2022/12/31||ABR_1000|HRC_SQLLOADER


SQL Query to find the duplicate email

For specific employee select * from PER_EMAIL_ADDRESSES where PERSON_ID in (select person_id from per_all_people_f where person_number = 'XXXX') For All employees select * from PER_EMAIL_ADDRESSES


How to control the access for a specific report

You have the BI administrator duty role which gives full access (admin level access) to all reports. If you want to delete the option to be removed even from this role then you have to go to the specific folder or specific report from which you want to remove the...


SQL Query to get the person security profile details

The following SQL will give the list of all data roles and the column 'PERSON_SECURITY_PROFILE' will give the list of person security profiles associated with them. You can use this a build a report and filter on that. Alternatively, you can use the SQL and modify it to fetch the...


Load the metadata file for created dff in the document of record

METADATA|DocumentsOfRecord|DocumentType|DocumentTypeId|PersonNumber|FLEX:PER_DOCUMENTS_OF_RECORD_DFF|dateOfAmendedDutiesNote(PER_DOCUMENTS_OF_RECORD_DFF=GB_MEDICAL___AMENDED_DUTIES_NOTE)|SourceSystemOwner|SourceSystemId MERGE|DocumentsOfRecord|Medical - Amended Duties Note|300000000000000|1000|US_MEDICAL_AMENDED_DUTIES_NOTE|2021/12/31|HDL|Medical1


Load metadata file for licenses and certifications

Date File Name: ContentItem.dat METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name MERGE|ContentItem||||1951/01/01|CERTIFICATION|U|103|ABC Safety Officer SQL Query to get the content id 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    from hrt_content_items_b ITEM, hrt_content_items_tl TL, hrt_content_types_b TYPE where ITEM.CONTENT_ITEM_ID=TL.CONTENT_ITEM_ID AND ITEM.CONTENT_TYPE_ID=TYPE.CONTENT_TYPE_ID AND UPPER(TYPE.CONTEXT_NAME) =UPPER('CERTIFICATION')


SQL Query to get the employee with a missing Profile ID

 select * from ps_ceh_ft_emplid where emplid = '00000000'


How to load email id (Work or Home) metadata file

Data File Name - Worker.dat METADATA|PersonEmail|EmailAddressId|PersonId|PersonNumber|DateFrom|DateTo|EmailType|EmailAddress|PrimaryFlag|GUID|SourceSystemOwner|SourceSystemId MERGE|PersonEmail|300000000000000|400000000000000|100|1951/01/01|4712/12/31|H1|HOMEEMAIL@oracle.com|N|||


Terminating or Inactivating User Accounts after Terminations HDL

Once a user has been terminated, however, the user accounts are still active then follow the steps below to inactivate their user account using HDL. Step 1 – Get a list of all terminated employees Step 2 – Prepare the .dat file METADATA|User|PersonNumber|Suspended


Load metadata File for Job Level using HDL

METADATA|Job|Name|JobId|JobCode|ActiveStatus|ApprovalAuthority|EffectiveStartDate|SourceSystemOwner|SourceSystemId|GUID MERGE|Job|HR Specialist|0101010|ABC-KB-0799-51B|A|0|1951/01/01|ABC_SSES_US|12121212|


Deferred processing on subsequent absences

If there is any subsequent absence that is already there in the queue which the employee has applied for multiple absences for 18 to 20 December one absence 26 to 27 absence another absence you are created that means there are 2 absences records in the queue now


Concurrency Overview

If the employee has applied for multiple absences records for the same day or the same absence type for the same day then we need to enable concurrency


Approval reset on update

When an employee has submitted an absence record and it went to the manager and the manager approved it and then employee after approval the employee changes his mind and wants to change the date and postponed the travel so whenever they do some updates again you want to reset...


Occurrence limit rule

How many numbers of times the employee can apply for leave within a specific period.


How to create the vacation rule for others

1. Login to Fusion Application as an Application Implementation Consultant. 2. Navigate to BPM Worklist -> Click on Bell Icon Notifications - > Show All -> Worklist 3. Go to your Username > Preferences > Other Rules