ETL9.2:ACA Queries Not Working

(Doc ID 2135149.1)

Last updated on JUNE 03, 2016

Applies to:

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


On : 9.2 version, Affordable Care Act

ACA Queries not working ACA_MONTH, ACA_WEEK

ACA queries not working


A SQL error occured. Please consult your system log for details

Error in running query because of SQL Error, code = 8601, Message=[Microsoft][SQL Server Native Client 11.0][SQL server]each group By expression muct cotains at least one column that is not and outer reference

The issue can be reproduced at will with the following steps:
1. Navigate to reporting Tools> query.>query manager
2.Run above queries and error is encountered

The issue has the following business impact:
Due to this issue, users cannot perform the functions to find out the aca eligiblity for the employees


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