ETL9.2 - Error Running Auto-Enrollment Process TL_AUTO_ENRL When Using Subquery Criteria.
(Doc ID 2345165.1)
Last updated on SEPTEMBER 11, 2023
Applies to:
PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
On : 9.2 version
When an enrollment group's Query contains additional subquery criteria, an error intermittently occurs when running auto-enrollment process TL_AUTO_ENRL.
ERROR
-----------------------
Error in running query because of SQL Error, Code=936, Message=ORA-00936: missing expression (50,380)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Query using a Subquery. To most consistently reproduce the error, the subquery records should have the lowest alphabetical aliases and use the EMPLID and/or EMPL_RCD fields
2. Create Auto-enroll process group using the Query from step 1
3. Hire employees
4. Run auto-enrollment process
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 |