To enable managers to use the Equity Analysis for Organization report to make an informed decision about salary for an applicant, you must complete the following steps:

   To set up the Equity Analysis Organization report for offers:

1. Run the following concurrent programs if this is the first time you are using HRMSi or DBI for HR:

   Note: If you already use HRMSi or DBI, then you need not run these programs. You would have run these concurrent programs at the time of set up.

   • Update Gregorian Hierarchy in the Time Dimension

     Run this program to load the FII_TIME_DAY table with time information. The Offers Materialized view uses this table to display information in real time. Set the Date To parameter at least one year into the future when you run the concurrent program.

   • HRI Load All Supervisor Hierarchies

     Run this program to load the Supervisor Hierarchy Summary Table (HRI_CS_SUPH.) with supervisor hierarchy details. The Equity Analysis for Organization report uses these details to display salary information for jobs in the supervisor hierarchy.

2. Run the concurrent process HRMSi (Embedded Analytics) Materialized View Refresh to refresh the HRI_MDP_SUP_WRKFC_JX_MV materialized view that updates workforce information.

   Prerequisites

   These processes are not delivered in any request sets or groups. To use these processes, you need to add the processes to a request group and, if applicable, a request set.

   See: Organizing Programs into Request Groups

   See: Organizing Programs into Request Sets

3. Set the profile option HRI: Enable Embedded Analytics to Yes for Application Human Resources at the Application level. You set the profile option to enable the Equity Analysis for Organization region in the Basic Details page.

4. Check that jobs and salary basis are set up correctly in Oracle HRMS to meet your requirements for offers equity analysis. The report uses the job and the hiring manager details to display the salary information.

   See: Jobs and Positions

   See: Salary Basis

5. Set up the currency conversion rate to display salary information in a common currency using the Conversion Rate Types window of Oracle General Ledger. Set up the Corporate conversion rate to define a standard rate for your enterprise. Oracle General Ledger currency setup is a shared product. Liaise with your Financials implementation team to get this information. If you do not use Oracle General Ledger, add the GL_GCS_RATES menu or individual functions from the menu to an existing menu that users access through their standard responsibilities. For further information about conversion rates, see the Oracle General Ledger User's Guide in the Oracle Financial Applications documentation.

6. Schedule to run the following processes to display the latest information. You can schedule the processes to run according to your business needs. For example, you can schedule to run these processes daily or once a week.

   • HRI Load All Supervisor Hierarchies

     Note: If you do not use Daily Business Intelligence, then set the Full Refresh parameter to Yes for subsequent runs. If you use Daily Business Intelligence, you must set the Full Refresh parameter to No for subsequent runs. Oracle supports only incremental refresh of supervisor hierarchy if DBI is installed.

   • HRMSi (Embedded Analytics) Materialized View Refresh