Oracle Human Resources Command Center Setup
This chapter covers the following topics:
Setting Up Human Resources Command Center
Setup and Configuration Steps for Human Resources Command Center
Setting Profile Options for Human Resources Command Center
Running the Script for PERSON_ID Encryption
Adding the Human Resources Command Center Functions
Assigning the Command Center Role
Reviewing Users' Security Profiles
Adding the Load Program to a Request Group
Running the People Tag Maintenance Program
Configuring Descriptive Flexfields for Search
Populating the Person List
Loading Person Hierarchy Data
Loading Person Data
Human Resources Command Center Configuration
Setting Up Human Resources Command Center
See Human Resources Command Center Overview, Oracle HRMS Workforce Sourcing, Deployment, and Talent Guide.
The Human Resources Command Center configuration setup must be completed after the installation and common configurations are
completed as described in My Oracle Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command Center Framework,
Release 12.2.
For more information, see Setup and Configuration Steps for Human Resources Command Center.
Setup and Configuration Steps for Human Resources
Command Center
See Human Resources Command Center Overview, Oracle HRMS Workforce Sourcing, Deployment, and Talent Guide.
To complete setup of the Human Resources Command Center:
1. Set the profile option for the command center.
2. Encrypt PERSON_ID.
3. Add the Human Resources Command Center functions .
4. Assign the command center role.
5. Review users' security profiles.
6. Add the load program to a request group.
7. Run the People Tag Maintenance program.
8. Configure descriptive flexfields for search.
Note: You can configure descriptive flexfields for search only for the US and UK legislations.
9. Populate the person list.
10. Load person hierarchy data.
11. Load person data.
Note: To enable users of the command center to view and update talent profiles of the workforce, your enterprise must license Oracle Self-
Service Human Resources.
Setting Profile Options for Human Resources Command
Center
See Setup and Configuration Steps for Human Resources Command Center.
Set the following profile option for the Human Resources Command Center.
Profile Option Name Description
HR: Extension For Determines whether Oracle Human Resource Enterprise Command Center is enabled or not. Set the profile option to Yes at s
Endeca or ECC default, the profile options setting is left blank (null). The application considers null equal to No.
Note: The Extension list in the Security Profile window is enabled only if the profile option is set to Yes.
Running the Script for PERSON_ID Encryption
See Human Resources Command Center Overview, Oracle HRMS Workforce Sourcing, Deployment, and Talent Guide and Setup and
Configuration Steps for Human Resources Command Center.
If your enterprise has licensed Oracle Self-Service Human Resources, then users can navigate from the Workforce Explorer dashboard to
the Talent Profile page for an employee or a contingent worker. When the applications displays the Talent Profile page for a person, the
page URL includes the PERSON_ID value. This is a security issue. To comply with person security and to encrypt the PERSON_ID value,
you must run a script. Set this encrypt key in FND_VAULT with ECC as the identifier.
Use the following command to run the script to encrypt the PERSON_ID:
begin
fnd_vault.put('ECC','CRYPT_KEY','AAAAACOREHRAAAAAAAAAACOREHRAAAAAAAAAACOREHRAAAAAAAAAACOAAAAAACOA');
commit;
end;
Adding the Human Resources Command Center Functions
See Human Resources Command Center Overview, Oracle HRMS Workforce Sourcing, Deployment, and Talent Guide and Setup and
Configuration Steps for Human Resources Command Center.
To enable users to work with the Workforce Explorer dashboard and the Person Hierarchy dashboard of the Human Resources
Command Center, you must add the command center's functions to a predefined or a custom Super HRMS Manager or Self-Service
responsibility that is used in your enterprise.
To add the Human Resources Command center functions
1. Navigate to the Menus window.
2. Query the menu for the responsibility to which you want to add the functions.
3. Search for the following functions and then add them to the menu.
o For the Workforce Explorer dashboard:
Human Resource Command Center Home (PER_ECC_HOME)
Human Resources Command Center Person Search (PER_ECC_PERSON_SEARCH)
HR ECC Proxy Page Function (HR_ECC_PROXY_PG)
ECC Talent Profile Home Function (HR_ECC_TALENT_HOME_FUNC)
Note: To enable users of the command center to view and update talent profiles of the
workforce, your enterprise must license Oracle Self-Service Human Resources.
o For the Person Hierarchy dashboard:
Human Resources Command Center Person Hierarchy Home (PER_ECC_HIERARCHY)
Human Resources Command Center Person Hierarchy (PER_ECC_PERSON_HIERARCHY)
Important: Do not select the Grant check box for these functions, because access to the command center is
provided through role-based access control (RBAC).For more information, see "Providing Users Access to Enterprise
Command Centers" in My Oracle Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command
Center Framework, 12.2.
4. Change the following prompts:
o Change the PER_ECC_HOME function prompt to Workforce Explorer. When you click this prompt,
the Workforce Explorer dashboard appears.
o Change the PER_ECC_HIERARCHY function prompt to Person Hierarchy. When you click this prompt,
the Person Hierarchy dashboard appears.
Assigning the Command Center Role
See Human Resources Command Center Overview, Oracle HRMS Workforce Sourcing, Deployment, and Talent Guide and Setup and
Configuration Steps for Human Resources Command Center.
After adding the functions, perform the following steps to grant necessary permissions to users to work with Human Resources Command
Center.
To assign the command center role
1. Assign the following role to any predefined or any custom responsibility and individual users.
Role Name: PER ECC PEOPLE
SEARCH (UMX|PER_ECC_PEOPLE_SEARCH_ROLE)
The permission set associated with this role is PER ECC Person Search Permission Set
(PER_ECC_PERSON_SEARCH_PS). To assign the role, log in to the User Management responsibility, and use the
Roles and Role Inheritance page.
2. Submit the Workflow Background Process concurrent program and ensure that it runs successfully.
Reviewing Users' Security Profiles
See Human Resources Command Center Overview, Oracle HRMS Workforce Sourcing, Deployment, and Talent Guide and Setup and
Configuration Steps for Human Resources Command Center.
The Human Resources Command Center uses the same security mechanisms as Oracle Human Resources applications. By defining
security profiles, both static and dynamic, you control who can use the Workforce Explorer dashboard and which workforce records those
users can access. Security rules affect the calculation of metrics and the plotting of charts, which use only the data to which the user has
access. When implementing the Human Resources Command Center, you must consider the security structure and ensure that the
concerned human resources personnel, line managers, and supervisors have appropriate access to workforce records. If security profiles
are not set up correctly, then the person data and any calculation based on the data may be incorrectly displayed for the given user.
For information about setting up security profiles, see Security Profiles, Oracle HRMS Configuring, Reporting, and System Administration
Guide.
To set up security profiles for the Workforce Explorer dashboard:
1. Based on your business requirement, create or update security profiles using the “Endeca or ECC” extension value.
Both static and dynamic security profiles are supported. To achieve high performance, the application evaluates
both types of security profiles and stores them in the PER_SHARED_PERSON_LIST table. This data is loaded to the
ECC server so that the same HRMS security is applied when a user accesses the Workforce Explorer dashboard.
To create or update security profiles:
a. Navigate to the Security Profile window.
b. Create or query an existing security profile.
c. Select the Extension list. Note that this list is enabled only if the profile HR: Extension For Endeca or
ECC is set to Yes.
d. Select Endeca or ECC as the value. This enables the Populate Shared Tables for Person Search
concurrent program to select the security profiles marked as Endeca or ECC. The concurrent program
converts security profiles to list values and makes it ready for use in the ECC environment.
2. Use the Assign Security Profile window to assign the security profiles that you created in step 1 to the user-
application-responsibility-business group combination.
3. Run the Security List Maintenance concurrent program after assigning the security profiles. Run this program
whenever there are changes in the security profile definition. For information about the program, see Running the
Security List Maintenance Process, Oracle HRMS Configuring, Reporting, and System Administration Guide.
4. Run the Populate Shared Tables for Person Search concurrent program so that the security profiles marked as ECC
in the Security Profile window are selected when the program runs. This program processes and converts
security profiles to list values and makes it ready for use in the ECC environment. Use the Submit
Request window to run this program. Schedule this program to run at the regular intervals.
Important: Schedule this program to run before the PER ECC Data Load program to get the latest secured records
into the Human Resource Command Center.
Security Profile for the Person Hierarchy Dashboard
Because the Person Hierarchy dashboard uses the View All security profile to display data of the workforce, you need not restrict users'
access to this dashboard.
Adding the Load Program to a Request Group
See Human Resources Command Center Overview, Oracle HRMS Workforce Sourcing, Deployment, and Talent Guide and Setup and
Configuration Steps for Human Resources Command Center.
As part of post installation step, you must add the PER ECC Data Load concurrent program to the request group, which is attached to the
predefined Oracle HRMS or the custom responsibility that your enterprises uses. Use the Request Groups window to perform this task.
This step ensures that the required program is available under that responsibility.
Running the People Tag Maintenance Program
See Setup and Configuration Steps for Human Resources Command Center.
Run the People Tag Maintenance concurrent program to collect all tags from the EBS HRMS database and ensure that the list is in the
ECC readable format. Schedule this program at regular intervals, so that the latest tag information is available for ECC. This program
downloads all the comma separated tag values for each employee and then creates a separate record for each tag per person in EBS HR
data base. After this process, all employee tags are loaded to the ECC data set through the PER ECC Data Load program so that
employee tags are displayed in the Workforce Explorer dashboard.
Run this concurrent program from the Submit Request window.
To run the People Tag Maintenance program:
1. In the Name field, select People Tag Maintenance.
2. In the Parameters window, enter the following information:
o Effective date
o Business group
o Organization (optional)
o Person (optional)
3. Submit the request.
4. Review your request using the Requests page.
Configuring Descriptive Flexfields for Search
See Human Resources Command Center Overview, Oracle HRMS Workforce Sourcing, Deployment, and Talent Guide and Setup and
Configuration Steps for Human Resources Command Center.
Enterprise command centers support searching on descriptive flexfield (DFF) attributes. After you configure DFFs you must run the data
load process to make the DFF attributes available in the command center.
For additional information about configuring and customizing flexfields, see the Oracle E-Business Suite Flexfields Guide and My Oracle
Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command Center Framework, Release 12.2.
The following table describes the DFFs that are available in the Workforce Explorer dashboard. You can configure DFFs for the following
Oracle HRMS legislations:
US
UK
Data Set DFF Title DFF Name DFF Attribute Group Name
PER Further Person Information Person Developer DF Further Person Information
Populating the Person List
See Human Resources Command Center Overview, Oracle HRMS Workforce Sourcing, Deployment, and Talent Guide and Setup and
Configuration Steps for Human Resources Command Center.
Before you load the person data using the PER ECC Data Load For People Hierarchy program, you must run the Populate Global Person
List concurrent program. This program populates the delta table PER_ALL_PEOPLE_LIST with person data changes from Oracle E-
Business Suite. This program is located under Super HRMS Manager > Processes and Reports > Submit Processes and Reports.
There are no parameters for this program. Schedule this program to run regularly so that the latest person data is available in the
PER_ALL_PEOPLE_LIST table.
Loading Person Hierarchy Data
See Human Resources Command Center Overview, Oracle HRMS Workforce Sourcing, Deployment, and Talent Guide and Setup and
Configuration Steps for Human Resources Command Center.
To load the person hierarchy and the assignment timeline data, run the PER ECC Data Load For People Hierarchy concurrent program,
which is located under Super HRMS Manager > Processes and Reports > Submit Processes and Reports.
This program loads data to the data sets listed in the following table:
Data Set Associated Dashboard
Human Resources Assignment Timeline (PER_ASSG_TIMELINE) Workforce Explorer (Compare
Human Resources People Hierarchy (per-hierarchy) Person Hierarchy
Important: The program loads data only for the primary assignments.
Prerequisite Step
Ensure that you have run the program Populate Global Person List before running the PER ECC Data Load for People Hierarchy program
with the Full Load option. Otherwise, the latest person list will not be available to load to the ECC data store.
Run the concurrent program from the Submit Request window.
PER ECC Data Load for People Hierarchy
To run the PER ECC Data Load For People Hierarchy program
1. In the Name field, select PER ECC Data Load For People Hierarchy.
2. Select the appropriate load type.
o Full Load: Loads all people hierarchy data and must be run for the first data load. If you run a full load
for a subsequent request, then this program clears all person data from ECC and loads fresh data.
o Incremental Load: Loads only the data that has been modified since the previous load. Schedule
incremental loads to run as often as required to keep the Person Hierarchy dashboard current.
o Metadata Load: Loads Descriptive Flexfield (DFF) metadata. This load type is not applicable to the
Person Hierarchy dashboard.
3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the
format AA,BB,NN. If the field is left blank, then the data will be loaded for the base language only (usually US).
4. Select the log level that you want the program to report. The default value is Error.
5. Select True to enable SQL trace. Otherwise, select False.
6. Submit the concurrent request.
7. Review your request using the Requests page.
8. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.
Loading Person Data
See Human Resources Command Center Overview, Oracle HRMS Workforce Sourcing, Deployment, and Talent Guide and Setup and
Configuration Steps for Human Resources Command Center.
To import the data from Oracle E-Business Suite to Human Resources Command Center, run the PER ECC Data Load concurrent
program, which is located under Super HRMS Manager > Processes and Reports > Submit Processes and Reports.
Run the concurrent program from the Submit Request window.
To run the PER ECC Data Load program
1. In the Name field, select PER ECC Data Load.
2. Select the appropriate load type.
o Full Load: Loads all person data and must be run for the first data load. If you run a full load for a
subsequent request, then this program clears all person data from ECC and loads fresh data.
o Incremental Load: Loads only the data that has been modified since the previous load. Schedule
incremental loads to run as often as required to keep the ECC dashboard current.
o Metadata Load: Loads Descriptive Flexfield (DFF) metadata. To enable DFFs on the Workforce
Explorer dashboard, you must first run the load program with the Load Type parameter set
to Metadata Load. Then, run the program with the Full Load option to ensure that DFF changes are
displayed in the command center.
Important: The Metadata Load option is applicable only to US and UK legislations. See Configuring
Descriptive Flexfields for Search.
3. In the Languages field, enter one or more language codes for the output. For multiple language codes, use the
format AA,BB,NN. If the field is left blank, then the data will be loaded for the base language only (usually US).
4. Select the log level that you want the program to report. The default value is Error.
5. Select True to enable SQL trace. Otherwise, select False.
6. Submit the concurrent request.
7. Review your request using the Requests page.
8. Monitor data loading using the Data Load Tracking page of the ECC Developer responsibility.