My Oracle Support Banner

E-AE: %Execute Not Working In PeopleTools 8.55.02 (Doc ID 2105491.1)

Last updated on FEBRUARY 07, 2019

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


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.