My Oracle Support Banner

E-NV: Nvision Recurrence with Email Template Adds Semicolon Character to RQST_TEXT Field (Doc ID 2645361.1)

Last updated on MARCH 24, 2020

Applies to:

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


When scheduling NVSRUN through the Process Scheduler via nVision report request to email on a recurrence, a ";" semicolon character is prepended to the value on PSPRCSRQSTTEXT.RQST_TEXT. This happens each time it recurs and a new semicolon is added. Once the total character length of the RQST_TEXT field reaches 189, then the process instance will no longer post to the report repository. The posting status in the Process monitor remains N/A. If not fixed, then once the MAX API limit is reached, the process scheduler will begin to queue processes.

The issue can be reproduced with the following steps:
1. Schedule an nVision report on a recurrence to email using the email template
2. Observe issue over time with each new recurrence until issue affects all processing

PeopleTools 8.57 , Process Scheduler




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.