Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood 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
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.
Tagged:
0