Online Confirmation Statement Process Errors if Schedule ID Is Left Blank With: Step BAS_CONFSTMT.10LdTbls.Step0300(SQL) with ORA-00936: missing expression.
(Doc ID 3028292.1)
Last updated on JUNE 12, 2024
Applies to:
PeopleSoft Enterprise HCM Benefits Administration - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
The Online Confirmation Statement process errors if the Schedule ID is left blank with the following:
ERROR:
Step BAS_CONFSTMT.10LdTbls.Step0300(SQL) with ORA-00936: missing expression.
Step BAS_CONFSTMT.10LdTbls.Step0300(SQL) with ORA-00936: missing expression.
The issue can be reproduced at will with the following steps:
- Run the Online Confirmation Statements process with a Blank Schedule ID. Navigation: Benefits > Manage Automated Enrollment > Participant Enrollment > Online Confirmation Statements.
- The process runs to no success with the error seen in the Application Engine log file.
Changes
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 |
Changes |
Cause |
Solution |
References |