My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2019

Applies to:

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

Symptoms

On : 9.2 version, Affordable Care Act

ACA Queries not working ACA_MONTH, ACA_WEEK

ACA queries not working

ERROR
-----------------------

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



STEPS
-----------------------
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

Cause

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
Symptoms
Cause
Solution
References


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