You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Getting Error on Loading Worker.dat

edited Sep 29, 2018 8:40AM in HCM Integrations 8 comments

Summary

Getting error of Invalid Number on WorkTerms Line in Worker.dat

Content

Hi all, 

 

I am getting a error of Invalid number when I am loading newhire data in a Worker.dat file via HDL, Can some please help. I am attaching the file below and with this question.
I am trying to load Pending worker in Fusion system from Taleo.

 


Error: An error occurred. To review details of the error run the HCM Data Loader Error Analysis Report diagnostic test. Message details: ORA-01722: invalid number 

 

Worker file

METADATA|Worker|PersonNumber|EffectiveStartDate|BloodType|StartDate|DateOfBirth|CountryOfBirth|RegionOfBirth|ActionCode|SourceSystemOwner|SourceSystemId

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!