E-BI/XMLP: Process goes to error when output type is set to EMAIL

(Doc ID 2372239.1)

Last updated on MARCH 16, 2018

Applies to:

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

Symptoms

BI Publisher process goes to error when output type is set to EMAIL while run from a process scheduler. Other output type has no problem.

The process fails with the below error:

File: /vob/peopletools/src/pspsm/psmrqsttext.cppSQL error. Stmt #: 133 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PSAPSPRCSRQSTTEXT) violated
Failed SQL stmt: INSERT INTO PSPRCSRQSTTEXT( PRCSINSTANCE,RQSTTEXTTYPE,RQST_TEXT) VALUES (:1, :2, :3)
.....

.....
12:04:14.359 SQL Error: ORA-00001: unique constraint (SYSADM.PSAPSPRCSRQSTTEXT) violated


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