Oracle Fusion HCM Knowledge Hub

Many job and abstract roles are predefined in Oracle Human Capital Management Cloud (Oracle HCM Cloud). This list shows the main predefined HCM roles: Benefits Administrator Benefits Manager Benefits Specialist Compensation Administrator Compensation Analyst Compensation Manager Compensation Specialist Contingent Worker Employee Environment, Health and Safety Manager Human Capital Management Application Administrator Human Capital Management Integration Specialist Human Resource Analyst Human Resource Manager Human Resource Specialist Line Manager Payroll Administrator Payroll Manager Power Recruiter Recruiting Administrator Time and Labor Administrator Time and Labor Manager These predefined roles are part of the Oracle HCM Cloud security reference implementation. The security reference implementation is a predefined set of security definitions that you can use as supplied. Also included in the security reference implementation are roles that are common to all Oracle Fusion applicatio...

The Oracle Fusion Applications Security Console is an easy-to-use administrative work area where you perform most security-management tasks. Security Console Functions Use the Security Console to: Review role hierarchies and role analytics. Create and manage custom job, abstract, and duty roles. Review the roles assigned to users. Create and manage implementation users and their roles. Compare roles. Simulate the Navigator for a user or role. Manage the default format of user names and the enterprise password policy. Manage notifications for user-lifecycle events, such as password expiration. Manage PGP and X.509 certificates for data encryption and decryption. Set up federation, and synchronize user and role information between Oracle Fusion Applications Security and Microsoft Active Directory, if appropriate. Accessing the Security Console You must have the IT Security Manager job role to access the Security Console. You open the Security Console by selecting the Security Console wor...

 What is a role?  A role is some kind of privilege that you can assign to the user allowing them to perform certain type actions in the application. As you can see from above, the role only allows you to grant some privilege, it does not stop you from doing something. Role Types: Explained Oracle Human Capital Management Cloud (Oracle HCM Cloud) defines five types of roles: Data roles Abstract roles Job roles Aggregate privileges Duty roles This topic introduces the role types. Data Roles Data roles combine a worker's job and the data that users with the job must access. For example, the HCM data role Country Human Resource Specialist combines a job (human resource specialist) with a data scope (country). You define the data scope of a data role in one or more HCM security profiles. HCM data roles aren't part of the security reference implementation. You define all HCM data roles locally and assign them directly to users. Abstract Roles Abstract roles represent a worker's r...

Lookups are containers for the list items that appear in an application. Users select one of the items from such lists to enter a value on the application UI. Lookups consist of: 1.  Lookup Type  - A lookup type is a static list of values users use to make entries in the application. This is the name of the field that appears on the setup UI and not on the application UI where you make the selection. 2.  Lookup Code  - An internal application code for each lookup that is not visible to users. 3.  Meaning  - The actual UI term associated with the lookup code. It is the item that appears in the list on the application UI against the specific field name, and can be selected by the users to indicate their choice. 4.  Tag  - The description or a label associated with that lookup. 5.  Enabled  (status) - Determines the availability of the meaning (the value or the item) within the selection list for that lookup type. If you do not enable it, t...

Oracle Fusion Functional Setup Manager is the application used to perform the setup tasks required to complete the implementation of Oracle Fusion Applications.  The application implementation process includes both manual activities and activities executed within the Setup and Maintenance work area within Oracle Fusion Applications.  – Plan  – Install  – Configure  – Implement  – Export   Roles required to access FSM are:  • Application Implementation Manager  • Application Implementation Consultant

SELECT PGLFT.NAME         FROM FUSION.PER_PERSON_NAMES_F     PPNF,              FUSION.PER_ALL_ASSIGNMENTS_M  PAAM,              FUSION.PER_GRADE_LADDERS_F_TL PGLFT,              FUSION.PER_GRADE_LADDERS_F    PGLF        WHERE PPNF.PERSON_ID = PAAM.PERSON_ID          AND PAAM.GRADE_LADDER_PGM_ID(+) = PGLFT.GRADE_LADDER_ID          AND PPNF.PERSON_ID = PAAM.PERSON_ID          AND PPNF.NAME_TYPE = 'GLOBAL'          AND PAAM.ASSIGNMENT_TYPE = 'E'          AND PAAM.PERSON_ID = P_PERSON_ID          AND PGLFT.LANGUAGE = USERENV('LANG')          AND PGLFT.GRADE_LADDER_ID = PGLF.GRADE_LADDER_ID          AND TRUNC(SYSDATE) BETW...

SELECT PPNF.FULL_NAME       FROM FUSION.PER_PERSON_NAMES_F    PPNF,            FUSION.PER_ALL_PEOPLE_F      PAPF,            FUSION.PER_ALL_ASSIGNMENTS_M PAAM      WHERE PPNF.PERSON_ID = PAPF.PERSON_ID        AND PAPF.PERSON_ID = PAAM.PERSON_ID        AND PAAM.PERSON_ID = PPNF.PERSON_ID        AND PPNF.NAME_TYPE = 'GLOBAL'        AND PAAM.JOB_ID = P_JOB_ID        AND PAAM.ASSIGNMENT_TYPE = 'E'        AND PAAM.POSITION_ID = P_POSITION_ID        AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND            PAAM.EFFECTIVE_END_DATE        AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND            PPNF.EFFECTIVE_END_DATE        ...

SELECT FLT.MEANING, FLB.TAG, FLT.DESCRIPTION      FROM FUSION.FND_LOOKUP_VALUES_TL FLT,                   FUSION.FND_LOOKUP_VALUES_B FLB      WHERE FLB.LOOKUP_TYPE = FLT.LOOKUP_TYPE        AND FLT.LOOKUP_CODE = FLB.LOOKUP_CODE        AND FLB.ENABLED_FLAG = 'Y'        AND FLT.LANGUAGE = USERENV('LANG')        AND FLB.LOOKUP_CODE = P_LOOKUP_CODE        AND FLB.LOOKUP_TYPE = P_LOOKUP_TYPE;

SELECT parb.action_reason_code       FROM fusion.per_all_people_f       papf,            fusion.per_periods_of_service ppos,            ---------------------------------------            fusion.per_all_assignments_m paam,            ---------------------------------------            fusion.PER_ACTION_OCCURRENCES pao,            fusion.PER_ACTION_REASONS_B   parb,            fusion.per_action_reasons_tl  PART             ---------------------------------------         WHERE 1 = 1        AND TRUNC(P_DATE) BETWEEN papf.effective_start_date AND            papf.effective_end_date        AND papf.pers...

SELECT PPTL.USER_PERSON_TYPE           FROM FUSION.PER_PERSON_TYPE_USAGES_M PPTUM,            FUSION.PER_PERSON_NAMES_F       PPNF,            FUSION.PER_PERSON_TYPES_TL      PPTL      WHERE PPTUM.PERSON_ID = PPNF.PERSON_ID        AND PPTL.PERSON_TYPE_ID = PPTUM.PERSON_TYPE_ID        AND PPTL.LANGUAGE = USERENV('LANG')        AND PPNF.PERSON_ID = P_PERSON_ID        AND PPNF.NAME_TYPE = 'GLOBAL'        AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND            PPNF.EFFECTIVE_END_DATE        AND TRUNC(SYSDATE) BETWEEN PPTUM.EFFECTIVE_START_DATE AND            PPTUM.EFFECTIVE_END_DATE;

SELECT PPNF.DISPLAY_NAME            FROM FUSION.PER_ASSIGNMENT_SUPERVISORS_F PASF,            FUSION.PER_PERSON_NAMES_F           PPNF      WHERE PASF.PERSON_ID = P_PERSON_ID        AND PPNF.PERSON_ID = PASF.MANAGER_ID        AND SYSDATE BETWEEN PASF.EFFECTIVE_START_DATE AND            PASF.EFFECTIVE_END_DATE        AND SYSDATE BETWEEN PPNF.EFFECTIVE_START_DATE AND            PPNF.EFFECTIVE_END_DATE        AND PPNF.NAME_TYPE = 'GLOBAL';

SELECT PAPF1.FULL_NAME         FROM FUSION.PER_PERSON_NAMES_F            PAPF1,            FUSION.HR_ORGANIZATION_INFORMATION_F HOIF      WHERE PAPF1.PERSON_ID = HOIF.ORG_INFORMATION2        AND HOIF.ORGANIZATION_ID = P_ORG_ID        AND HOIF.ORG_INFORMATION_CONTEXT = 'PER_ORG_MANAGER_INFO'        AND PAPF1.NAME_TYPE = 'GLOBAL'        AND P_EFFECTIVE_DATE BETWEEN PAPF1.EFFECTIVE_START_DATE AND            PAPF1.EFFECTIVE_END_DATE        AND P_EFFECTIVE_DATE BETWEEN HOIF.EFFECTIVE_START_DATE AND            HOIF.EFFECTIVE_END_DATE;

select PGSFL.Name       FROM FUSION.PER_ALL_PEOPLE_F         PAPF,            FUSION.PER_PERSON_NAMES_F       PPNF,            FUSION.PER_ALL_ASSIGNMENTS_M    PAAM,            FUSION.PER_GRADES_F             PGF,            FUSION.PER_GRADE_STEPS_F_TL     PGSFL,            FUSION.Per_Assign_Grade_Steps_f  PAGSF      where paam.assignment_status_type = 'ACTIVE'        AND PAAM.PRIMARY_FLAG = 'Y'        AND PGSFL.LANGUAGE = USERENV('LANG')        AND PPNF.NAME_TYPE = 'GLOBAL'        AND PAAM.PERSON_ID = PAPF.PERSON_ID        AND PAAM.GRADE_ID = PGF.GRADE_ID        AND PPNF...

 SELECT NATIONAL_IDENTIFIER_NUMBER      FROM FUSION.PER_NATIONAL_IDENTIFIERS PNI,            FUSION.PER_ALL_PEOPLE_F         PAPF      WHERE PAPF.PERSON_ID = PNI.PERSON_ID        AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND            PAPF.EFFECTIVE_END_DATE        AND PAPF.PERSON_NUMBER = P_PERSON_NUMBER

select sum(D.RESULT_VALUE)          from FUSION.PAY_PAYROLL_ACTIONS      a,            FUSION.PAY_PAYROLL_REL_ACTIONS  b,            FUSION.pay_run_results          c,            FUSION.PAY_RUN_RESULT_VALUES    D,            FUSION.PAY_PAY_RELATIONSHIPS_Dn e,            FUSION.PER_person_names_f       f,            FUSION.pay_element_types_vl     g,            FUSION.PAY_TIME_PERIODS         h      where a.LEGISLATIVE_DATA_GROUP_ID IN            (SELECT LEGISLATIVE_DATA_GROUP_ID               FROM FUSION.PER_LEGISLATIVE_DATA_GROUPS_VL     ...

SELECT round(prvf.value, 2)             FROM fusion.per_rates_f              prf,            fusion.per_rate_values_f        prvf,            fusion.per_assign_grade_steps_f pagsf,            fusion.per_all_assignments_m    paam      WHERE prf.rate_id = prvf.rate_id        AND prf.rate_object_type = 'STEP'        AND prf.grade_ladder_id = paam.grade_ladder_pgm_id        AND TRUNC(P_DATE) BETWEEN prf.effective_start_date AND            prf.effective_end_date        AND prvf.rate_object_type = 'STEP'        AND TRUNC(P_DATE) BETWEEN prvf.effective_start_date AND            prvf.effective_end_date       ...

SELECT PGFT.NAME           FROM FUSION.PER_ALL_PEOPLE_F      PAPF,            FUSION.PER_ALL_ASSIGNMENTS_M PAAM,            FUSION.PER_GRADES_F_TL       PGFT      WHERE 1 = 1        AND PAPF.PERSON_ID = PAAM.PERSON_ID        AND PAAM.GRADE_ID = PGFT.GRADE_ID        AND PGFT.LANGUAGE = USERENV('LANG')        AND PAAM.ASSIGNMENT_TYPE = 'E'        AND PAAM.Assignment_Status_Type = 'ACTIVE'        AND PAPF.PERSON_NUMBER = P_PERSON_NUMBER        AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND            PAPF.EFFECTIVE_END_DATE        AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND            PAAM.EFFECTIVE_END_...

SELECT PJFT.NAME       FROM FUSION.PER_ALL_PEOPLE_F      PAPF,            FUSION.PER_ALL_ASSIGNMENTS_M PAAM,            FUSION.PER_JOBS_F_TL         PJFT      WHERE 1 = 1        AND PAPF.PERSON_ID = PAAM.PERSON_ID        AND PAAM.JOB_ID = PJFT.JOB_ID        AND PJFT.LANGUAGE = USERENV('LANG')        AND PAAM.ASSIGNMENT_TYPE = 'E'        AND PAAM.Assignment_Status_Type = 'ACTIVE'        AND PAPF.PERSON_NUMBER = P_PERSON_NUMBER        AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND            PAPF.EFFECTIVE_END_DATE        AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND            PAAM.EFFECTIVE_END_DATE   ...

SELECT PPLF.SEX               FROM FUSION.PER_PERSON_NAMES_F       PAPF,              FUSION.PER_PEOPLE_LEGISLATIVE_F PPLF        WHERE PPLF.PERSON_ID(+) = PAPF.PERSON_ID          AND PAPF.NAME_TYPE = 'GLOBAL'          AND PAPF.PERSON_NUMBER = P_PERSON_NUMBER          AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND              PAPF.EFFECTIVE_END_DATE          AND TRUNC(SYSDATE) BETWEEN PPLF.EFFECTIVE_START_DATE AND              PPLF.EFFECTIVE_END_DATE;

SELECT HOUFT.NAME            FROM FUSION.HR_ORGANIZATION_UNITS_F_TL HOUFT      WHERE HOUFT.ORGANIZATION_ID = &P_ORG_ID        AND HOUFT.LANGUAGE = USERENV('LANG')        AND TRUNC(SYSDATE) BETWEEN HOUFT.EFFECTIVE_START_DATE AND            HOUFT.EFFECTIVE_END_DATE;

SELECT PPNF.FULL_NAME      FROM FUSION.PER_PERSON_NAMES_F    PPNF,            FUSION.PER_ALL_PEOPLE_F      PAPF,            FUSION.PER_ALL_ASSIGNMENTS_M PAAM      WHERE PPNF.PERSON_ID = PAPF.PERSON_ID        AND PAPF.PERSON_ID = PAAM.PERSON_ID        AND PAAM.PERSON_ID = PPNF.PERSON_ID        AND PPNF.NAME_TYPE = 'GLOBAL'        AND PAAM.JOB_ID = P_JOB_ID        AND PAAM.ASSIGNMENT_TYPE = 'E'        AND PAAM.POSITION_ID = &P_POSITION_ID        AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND            PAAM.EFFECTIVE_END_DATE        AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND            PPNF.EFFECTIVE_END_DATE   ...

Predefined HCM Roles:  Many job and abstract roles are predefined in Oracle Fusion Human Capital Management (Oracle Fusion HCM). This list shows the main predefined HCM roles: • Benefits Administrator • Benefits Manager • Benefits Specialist • Compensation Administrator • Compensation Analyst • Compensation Manager • Compensation Specialist • Contingent Worker • Employee • Human Capital Management Application Administrator • Human Resource Analyst • Human Resource Manager • Human Resource Specialist • Human Resource VP • Line Manager • Payroll Administrator • Payroll Manager These predefined roles are part of the Oracle Fusion HCM Security Reference Implementation. The Security Reference Implementation is a predefined set of security definitions that you can use as supplied. Also included in the Security Reference Implementation are roles that are common to all Oracle Fusion applications, such as: • Application Implementation Consultant • IT Security Mana...