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


Can we create Absence Pattern?

No, it’s delivered by Oracle


What are the delivered Absence Pattern?

Illness or injury Childbirth or placement Generic absence


List of privileges for give the absence related task accesses

ANC_ABSENCE_ADMINISTRATION_WORK_AREA_PRIV ANC_ABSENCE_ENTRY_VIA_CALENDAR_PRIV ANC_ADJUST_ACCRUAL_PLAN_BALANCE_PRIV ANC_CONFIGURE_ABSENCE_BATCH_PARAMETER_PRIV


Is it possible to stop employee to delete holiday that is declined or completed

Is it possible to stop an employee from deleting a holiday that is declined or completed so the record remains in the system? Yes, there is an option in the absence type where we can restrict the employees to delete their declined or completed records. Go to the Absence Type...


How to get the maximum file size

SELECT v.level_name, v.level_value, v.profile_option_valueFROM fusion.fnd_profile_option_values v, fusion.fnd_profile_options_b bWHERE b.profile_option_id = v.profile_option_idAND b.profile_option_name = 'FND_FILE_UPLOAD_MAX_SIZE'


When The Candidate pool ownership is shared, how do you select other team members for sharing?

When candidate pool ownership is shared, you typically select collaborators to share access and ownership with other team members. This allows multiple users to work collaboratively on managing and interacting with the candidate pool. The term "collaborators" implies individuals who actively participate and contribute to the candidate management process, thereby...


Which functionality in Talent Management enables an HR specialist to select an individual based on a specific list of requirements?

The functionality in Talent Management that enables an HR specialist to select an individual based on a specific list of requirements is "Profile Search." With Profile Search, HR specialists can search for candidates or employees within the talent pool based on various criteria and requirements. This functionality allows them to...