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 APRIL 18, 2025

Applies to:

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

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
-----------------------

	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

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