My Oracle Support Banner

ETL9.2 - Error Running Auto-Enrollment Process TL_AUTO_ENRL When Using Subquery Criteria. (Doc ID 2345165.1)

Last updated on DECEMBER 02, 2021

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!

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.