ETL9.2: ACA MView Which Creates The ACA_WEEKLY_JOB Is Not Including All Hours For Multiple Job Rows. (Doc ID 2050369.1)

Last updated on DECEMBER 22, 2015

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ACA Materialized view, which creates the ACA_WEEKLY_JOB, is not including all hours for multiple job rows.

Multiple EMPL_RCD's with data for both EMPL_RCD's are not handled correctly.

STEPS
-----------------------

1. Multiple jobs employee with one of the empl_rcds terminated.
2. Employee has multiple job records with ACA payable hours
3. The ACA TRC payable hours for the empl_rcd which was recently terminated, no longer appears in the ACA_WEEKLY_JOB table.

Due to this issue, without these hours users won't be unable to accurate calculate the Average Payable hours.

 

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