1. Understanding Scheduled Processes
  2. Loads HCM Person Mapping Data

Loads HCM Person Mapping Data

Use the ‘Loads HCM Person Mapping Data’ scheduled process to create BI reports involving Helpdesk Contact (Worker) Business Unit and Organization.

Beginning with 24B, this process replaces the automatically scheduled ‘Execute Incremental Load of HCM Person Mapping Data for Reporting’. There will be a period of soft cutover, where ‘Execute Incremental Load of HCM Person Mapping Data for Reporting’ will process the data, while ‘Loads HCM Person Mapping Data’ will perform no action. Once the period is over, ‘Loads HCM Person Mapping Data’ will process the data and ‘Execute Incremental Load of HCM Person Mapping Data for Reporting’ will perform no action. The soft cutover period will last for a minimum of 14 runs of ‘Loads HCM Person Mapping Data’ over 14 days. The period will end after 14 days and a minimum of 14 runs.

Incrementally loads HCM person mapping data making it easier for reporting Worker related dimensions Business Unit and Organization. The goal of the process is to provide a consolidation of the assignment information per person (a person has associated only one assignment).

When to Use

Loads HCM Person Mapping Data’ scheduled process needs to be executed when there are new or updated assignments for person records.

Privileges Required

Verify that you have the following privileges:

  • To administer the job the following roles are required with delete, execute, read and update:

    • ORA_SVC_HELPDESK_ADMINISTRATION

    • ORA_SVC_SR_ADMINISTRATOR

  • To schedule the job, the following privilege is required

    • SVC_SCHEDULE_SERVICE_JOBS_PRIV

Before You Start

Review the following before scheduling this scheduled process:

  • While the process that this scheduled process is replacing; ‘Execute Incremental Load of HCM Person Mapping Data for Reporting’, is automatically scheduled, if the customer has also manually scheduled it, any manually scheduled ‘Execute Incremental Load of HCM Person Mapping Data for Reporting’ process should be stopped.
  • Please note that this scheduled process must be scheduled by the customer. Unlike the process it is replacing, it will not be automatically scheduled by the system.
  • The recommended frequency is daily.

  • Execution Time:

    • For single data record, the estimated execution time is less than 1 sec;

    • For batch job on volume of 10K records, the estimated execution time is less than 1 minute;

  • Compatibility:

    • Before scheduling this job it is recommended that the job “Execute Full Load of HCM Person Mapping Data for Reporting” is run once in order to fully populate the data;

    • No other processes are triggered when this job runs;

    • No potential impact on the server performance while this job is running;

    • There can be only one instance of the job running at any one time, otherwise there will be issues. A built-in locking mechanism prevents a second instance of the job from being started before the current instance has finished. The job itself parallelizes the gathering of the data.

    • There are no issues with business processes executing in parallel with this job;

    • This scheduled process is incompatible with itself, therefore only one instance of the job should be running at any particular time;

Parameters

None.

Troubleshooting Information

Use this information to troubleshoot the scheduled process.

  • Notification of job completion would be using the standard scheduled process job notification system.

  • If the scheduled job does not run successfully, the next scheduled instance will process data from both jobs;

  • This scheduled process idempotent, and no cleanup activity is required if the job fails;

  • When the scheduled process starts it will attempt to obtain a process lock. If no other instance of the process is running, it will be successful. Upon successful completion or in the event the process fails gracefully, the lock will be released.
  • If the scheduled process is unable to obtain a process lock, the lock will automatically expire after 24 hours.
  • To verify this scheduled process is running successfully, perform a BI report dimensional query on Helpdesk Contact Business Unit and/or Organization from any subject area that has these dimension. Commonly if the process has never run, the report will return no data; or if not run recently, then the data reported will be stale. For example, in the Help Desk – HR Service Requests Real Time subject area, select elements from HR Service Request Contact > Contact Business Unit and/or HR Service Request Contact > Contact Organization.