Direct Reports Tables Build (HR_DRPT_BLD) Performance Issue (Doc ID 1951343.1)

Last updated on JUNE 20, 2017

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Direct Reports Tables Build (HR_DRPT_BLD) performance issue.

The Application engine first step (for Access Type 2) takes close to 2 hours.
The subsequent steps run in seconds. Issue occurs when running a full build, or an incremental build.

REPLICATION STEPS

Navigation : Main Menu > Set Up HRMS > Common Definitions > Direct Reports for Managers > Direct Reports Table Build

Process runs for long time.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms