E-AE: Application Engine Restart Failed with ORA-06550/PLS-00103 Error on SQL Statement RECSTATS (Doc ID 979151.1)

Last updated on JANUARY 24, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.48 to 8.49 [Release 8.4]
PeopleSoft Enterprise PT PeopleTools - Version 8.51 to 8.51 [Release 8.4]
Information in this document applies to any platform.
***Checked for relevance on 19-Jan-2012***


Symptoms

Since our upgrade to Tools 8.49.19 from 8.46.19, The Application Engine (AE) start abending with ORA-6550. Further review indicated it occurs when the AE tries to run stats.

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1603 Error Position: 14 Return: 6550 - ORA-06550: line 1, column 15: PLS-00103: Encountered the symbol "TABLE" when expecting one of the following: := . ( @ % ;
Failed SQL stmt:RECSTATS PS_RE_OPTS_TAO4 LOW

Process 768988 ABENDED at Step AR_REV_EST.GETOPTS.STATS (SQL) -- RC = 6550 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

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