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 AUGUST 26, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.

Symptoms

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.


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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.