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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

HDL (HCM Data Loader) DAT File Issue

edited Jul 11, 2017 3:17PM in Human Capital Management 4 comments

Summary

Why does the pipe delimiter causes an error when loading data?

Content

Hello,

We are beginning to use the HDL for uploading data into HCM.  Right now, we are starting with HDL to load documents of record into HCM.  It has become apparent the file will not load without error due to extra the pipe delimiters on the DAT file for the attachment lines. 

These extra pipe delimiters appear because the DocumentsofRecord tab has more columns than the number of column in the attachments.  When the DocumentsOfRecord and the Attachment files headers are combined into the one DAT load file, the headers from the DocumentsOfRecord tab cause the Attachments section in the DAT file to have extra pipe delimiters.  See attached screenshot. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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