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.


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.


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.



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