My Oracle Support Banner

Oracle Fusion Recruiting Cloud: Extract Not Returning Data with Error: "ORA-01722: invalid number" (Doc ID 2718234.1)

Last updated on OCTOBER 12, 2020

Applies to:

Oracle Recruiting Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.

Symptoms

Problem Description:

When attempting to run an extract pulling the following criteria...

... the extract runs successfully but no results are returned. 

The following error occurs:

Name PAY_PAYPROC_UNKNOWN_ERR
Token1 null
Token2 null
Token3 null
A system error occurred during processing. Contact your help desk.
Out } PayMessage.handleMessage
In { PayMessage.handleMessage
In { PayMessage.getActionParameter

Parameter Name = MESSAGE_NAMES Parameter Value =
Out } PayUtils.getActionParameter

Set Token 1
Set Token 2
Set Token 3get
Name HR_6881_HRPROC_ORA_ERR
Token1 ReportUtil.CallReportProc
Token2 ORA-01722: invalid number
ORA-06512: at "SYS.DBMS_SQL", line 1712
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 711
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 2080
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1969
ORA-06512: at line 1

 

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!

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