E-AE: Using %UserID System Variable in Application Engine SQL Action Results in "ORA-00911: invalid character" Error
(Doc ID 2704168.1)
Last updated on AUGUST 26, 2020
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.
Sample environment is on PeopleTools 8.58.05. When using the %UserID system variable in an application engine program's (AE) SQL Action, the following error is seen when running the program.
The issue can be reproduced with the following steps:
1. Create an AE program with a state record and SQL action containing the above fields.
2. Run the AE program.
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