My Oracle Support Banner

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 APRIL 06, 2021

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 and observe the error.




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.