ETL9.2: Materialized Views ACA Weekly TL Reporting TRC Codes NOT In The ACA TRC Code Setup.

(Doc ID 2130966.1)

Last updated on MAY 09, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.


It appears ACA WEEKLY TL query reflects hours for TRCs other than what is specified in ACA TRC Code setup.

Steps to Replicate:
1) complete all preliminary ACA setup tables and employee enrollment
2) setup ACA TRC table to have only one TRC
3) report multiple different TRCs within the reporting period for Salaried employee reporting to exception time reporting workgroup
4) run Time Admin
5) check payable time
6) run materialized views
7) run ACA WEEKLY TL query
8) check the results to see if the hours reflected in ACA WEEKLY TL reflect any TRCs other than the TRC in the ACA TRC table

Business Impact:
Results for delivered query (ACA WEEKLY TL) are not as expected and therefore cause confusion for users.


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