ETL9.2 - Error Running Auto-Enrollment Process TL_AUTO_ENRL When Using Subquery Criteria.
(Doc ID 2345165.1)
Last updated on AUGUST 09, 2018
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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 in running query because of SQL Error, Code=936, Message=ORA-00936: missing expression (50,380)
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!