My Oracle Support Banner

Fusion Global HR and Payroll: Extract Fails with Error "A System Error ORA-01722: Invalid Number" (Doc ID 2393340.1)

Last updated on JULY 28, 2020

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.20.07.0 and later
Oracle Fusion Global Payroll - Version 11.12.1.0.0 and later
Oracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.07.0 and later
Information in this document applies to any platform.

This note was created for Release 11.1.8.02.0. The note has been reviewed and is current for release 11.13.20.07.0.

Goal

Submitting the extract resulting below error:


Error:

"An application error occurred. An assertion failure was detected at location PayrollAction.setStatus:1.
Name HR_6881_HRPROC_ORA_ERR
Token1 SystemExtract.PreProcess
Token2 ORA-01722: invalid number
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1550
ORA-06512: at line 1

Token3 44
A system error ORA-01722: invalid number
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1550
ORA-06512: at line 1
 occurred in table SystemExtract.PreProcess at location 44. Your help desk was notified."
 


 

Solution

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
Goal
Solution
References


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