E-ORA/AE/APPSRV: SQL Access Manager Error When Secondary Db Connection was Made After Upgrade To PT 8.56.05

(Doc ID 2394973.1)

Last updated on MAY 11, 2018

Applies to:

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


Application & Version:PT 8.56.05/HCM 9.2 PI 21,

After upgraded from PT 8.55.14, a customized AE program using GetNextNumberWithGapCommit , it ran failed with error

After that, all subsequent AE processes run failed with similar error

Error seen in log

PSAESRV.19005558 (7) [2018-04-20T10:00:24.314] - - - (3) File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: -2 -




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