E-WF: PSWORKLIST Error On Insert; 'ORA-25408: can not safely replay call' On Oracle Environments Running TAF (Doc ID 1579965.1)

Last updated on JULY 10, 2017

Applies to:

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

Symptoms

On : Worklist Component
Transparent Application Failover (TAF) implemented.
PT 8.52.09 or above
Oracle 11 Database version.



ISSUE STATEMENT
---------------
Periodic error with workflow submission, when Worklists are involved. Tried submitting again ~20 minutes later, the transaction goes through.

PT_AMM_WF Application Engine (AE) program goes No Success, when Worklists are configured for notification.

Any processing that does INSERT INTO PSWORKLIST can see this occur.
 

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

Online error;



 STEPS
 -----------------------
 The issue can NOT be reproduced at will.  The following steps have been observed when error occurs:

 1. Perform submission of workflow configured to generate Worklist.
 2. Note error occurs periodically.
 3. Retry allows transaction to go through.



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