Some Sample use cases for Core HR
Use Case - 1 In the event that a line manager completes a "Change Manager" transaction on one of their direct reports, the approval must be processed according to the steps outlined below.
Not able to access the list of document types
Either you don't have access to any document type, or your roles do not include the following aggregate privilege - "Use REST Service - HR Document Types List of Values", check the document security profile and see if the required document type is added or not.
SQL Query to get the profile code, content type name, content type id, content section id and much more
SELECT HPB.PROFILE_CODE,papf.person_number,HRT_CONT_TYPE.CONTENT_TYPE_NAME, HRT_PROF_ITEMS.* FROM
Content Type IDs
Performance Rating - Content Type id - 125 Licenses and Certifications - Content Type id - 103 Languages - Content Type id - 109
What is mean by Test Environment in oracle fusion hcm?
Test Environment: is defined as a single test environment provided to You as part of the Cloud Services. A test environment is used for testing and validating changes prior to promotion to the
If a reviewer save the content in talent review meeting not to submit the content then what we will happen?
If a reviewer only saves the review content not to submit then below are the situation that can happen. Saving: When a reviewer saves the review content, it means that they are temporarily storing the information, they have entered without finalizing their feedback.
How to create the Descriptive Flexfield (DFF) in Document Record (DOR)
Navigate to "Setup and Maintenance." In the "Setup and Maintenance" page, search "Document Types" task and search the required document type where you want to create the dff and then get the System Document Type id. That will help you to map your DFF with the document type.
Query to get the List of Job name and job codes
SELECT PJFT.NAME, PJF.JOB_CODE FROM PER_JOBS_F_TL PJFT , PER_JOBS_F PJF WHERE PJFT.LANGUAGE = 'US'
Enterprise Structure Terminologies and Definition
Enterprise - Enterprise is the highest level of Organization, and it is required because it acts as an umbrella for the entire implementation. Everything originates from this.
Autocomplete Rules Overview
What is Autocomplete Rule? Autocomplete Rules, which is also a part of the HCM Experience Design Studio takes the user experience to the next level by allowing customers to define very specific criteria for defaulting and validation across its suite of products. Example: Autocomplete = Auto populate (Default) + Auto correct (Validate)
How can I get the attachment details of the files uploaded for a Document Record?
SELECT papf.person_number ,ppnf.full_name ,fdv.file_name ,fdv.dm_document_id ,hdpr.date_from ,hdpr.date_to FROM per_periods_of_service ppos
Get the List of username, person no, role name, role code, department
select distinct papf.person_number,pu.username,prdt.role_name Role_Name,prd.role_common_name ,dept.name Department from per_All_people_F papf, PER_USER_ROLES pur, per_users pu,
Get the count of person records those who don't have work email id
select COUNT(1) FROM PER_ALL_PEOPLE_F papf where papf.person_id in ( SELECT ppos.person_id FROM per_periods_of_service ppos )
Query to get the List of Legal Employer and Legal employer Organization id
SELECT hauft.organization_id, hauft.NAME, houcf.classification_code FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf,
Query to get the List of Business Units and Business Unit id
SELECT hauft.organization_id business_unit_id, hauft.NAME, houcf.classification_code FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft
Query to get the list of departments with department (organization id)
SELECT hauft.organization_id, hauft.NAME FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft WHERE haouf.ORGANIZATION_ID = houcf.ORGANIZATION_ID AND haouf.ORGANIZATION_ID = hauft.ORGANIZATION_ID
Can we search the employee by using the worker number in the system
No, we cannot search, we can search the employee by using person number.
What is Vertex?
The vertex is the 3rd party company that provides the geographic data for us and Canada, for other countries it is GBQ Loqate.
Access Succession Plan and Talent related functions privileges
Function Security Policies · Create Succession Plan for Worker · Manage Succession Plan · Manage Succession Plan Candidate
How to setup Career Outlook
Background A client wants to set up the career outlook so that employees can find the next career opportunities