My Oracle Support Banner

E-PRCS: "ORA-01722: invalid number Failed SQL stmt: select r.PT_OVRDFROMEMAILID" Error In Scheduler Logs With Tidal Integration (Doc ID 2801400.1)

Last updated on AUGUST 23, 2021

Applies to:

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

Symptoms

When the jobs are coming from Tidal (third-party) to PeopleSoft, its showing below error in Scheduler Log, located at:

Windows

PS_CFG_HOME\appserv\prcs\<Database Name>\Logs

Unix

Logs: PS_CFG_HOME/appserv/prcs/<Database Name>/Logs

The same error will be captured into errorLog.html, located at:

<PS_CFG>/webserv/<DOMAIN_NAME>/applications/peoplesoft/PSIGW.war



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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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