My Oracle Support Banner

ETL9.2:ACA Queries Not Working (Doc ID 2135149.1)

Last updated on JULY 22, 2020

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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