My Oracle Support Banner

HCM: Process Direct Reports Tables Build (AE HR_DRPT_BLD) Does Not Complete for All Access Methods (Doc ID 2903380.1)

Last updated on JANUARY 26, 2024

Applies to:

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

Symptoms

After upgrade to HCM 9.2 PUM #36, when run the Process Build Direct Reports for full rebuild mode, AE HR_DRPT_BLD App Engine Process runs and stops.

 

Steps to reproduce the issue:

1. Navigate to Set Up HCM > Common Definitions > Direct Reports for Managers > Direct Reports Tables Build
2. Run AE HR_DRPT_BLD with Build Mode - Full - Complete Rebuild and Access Method-All Access Methods
3. Process HR_DRPT_BLD appears to stop, but a SQL statement is executing, continuously in AE HR_DRPT_BLD.4ByPosn.GBL.default.1900-01-01.Step02f.OnExecute.

 

 

 

 

 

 

 

 

 

Changes

If there are changes in the environment, product, account and hardware that trigger the problem describe them.

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.