My Oracle Support Banner

Data Getting Deleted From Direct Reports Tables After Incremental Run (Doc ID 2390567.1)

Last updated on APRIL 24, 2018

Applies to:

PeopleSoft Enterprise HCM eProfile Manager Desktop - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
The Direct Reports Tables Build Process, HR_DRPT_BLD, using Incremental Build Mode is wiping out data from HR_DIRECT_REP_2, HR_DIRECT_REP_4 and HR_DIRECT_REP_5 tables though there were no changes made in employees data.

EXPECTED BEHAVIOR
-----------------------
Data should remain same when there were no changes made.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Set Up HCM > Common Definitions > Direct Reports for Managers > Direct Reports Tables Build
2. On the Run Control page, enter the value for build mode as 'Full - Complete Rebuild' and Access method as '5 - Position/Supervisor ID'
3.Click on Run.
4. Once process is went to success, check the row count by executing the following SQLs.
select count(*) from PS_HR_DIRECT_REP_2;
select count(*) from PS_HR_DIRECT_REP_4;
select count(*) from PS_HR_DIRECT_REP_5;
5. Again run the process with build mode as 'Incremental - Current Date Upd'.
6. Once process is went to success, check the row count by executing the following SQLs.
select count(*) from PS_HR_DIRECT_REP_2;
select count(*) from PS_HR_DIRECT_REP_4;
select count(*) from PS_HR_DIRECT_REP_5;

Changes

 

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!


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