E-AE: %Execute Not Working In PeopleTools 8.55.02

(Doc ID 2105491.1)

Last updated on JULY 26, 2017

Applies to:

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

Symptoms

On :  8.55 version, Application Engine

 %Execute() or %Execute(/) is not working properly in PT8.55.02.  Whenever this is used, App Designer and subsequently the AE, throws an error.

ERROR
-----------------------

Error(8) 911: ORA-00911: invalid character.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Put the following code in sql section of AE.
%Execute(/)
DECLARE
 counter INTEGER;
BEGIN
 FOR counter := 1 TO 10
  UPDATE pslock SET version = version + 1;
 END FOR;
END;
/
2. Validate syntax


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms