E-AE: Read Only Application Engine with Temp Tables Can Not Be Run in Standby DB of Oracle Active Data Guard Environment

(Doc ID 2131737.1)

Last updated on MAY 03, 2016

Applies to:

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


On : 8.54 version, Application Engine

Application Engine has temp tables tables configured and Read-only. When it is run in stand-by database of Oracle Active Data Guard environment,it gives out the following error. 


116 15:13:47.055 0.001000 Cur#1.7588.STANDBY RC=0 Dur=0.000000 COM Stmt=TRUNCATE TABLE EMDBO.PS_EOEN_AL_TAO1
117 15:13:47.216 0.161000 Cur#1.7588.STANDBY RC=604 Dur=0.160000 EXE
118 15:13:47.220 0.004000 Cur#1.7588.STANDBY RC=0 Dur=0.000000 RCD rtncd=604
119 15:13:47.220 0.000000 Cur#1.7588.STANDBY RC=0 Dur=0.000000 EPO error pos=21
120 15:13:47.225 0.005000 Cur#0.7588.notSamTran RC=-1 Dur=0.000000 XER rtncd=0 msg=
121 15:13:47.226 0.001000 Cur#0.7588.notSamTran RC=0 Dur=0.000000 ERR rtncd=604 msg=ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access

The issue can be reproduced at will with the following steps:
1. Application Engine configured with temp tables and read-only
2. Oracle Active Data Guard is setup in PeopleSoft DBs.

3. Run this AE.

The issue has the following business impact:
Due to this issue, users cannot run read-only AE.


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