Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
HCM Data Loader FF INPUT line parse issue - CSV string all in POSITION1
Summary
HCM Data Loader FF INPUT line parse issue - CSV string all in POSITION1Content
Hello forum:
I"m not sure why but my CSV input file record is ONLY being assigned to POSITION1 , and not POSITION2-POSITION4?
Thoughts?
Later in my formula below snippet
PersonNumber = trim(POSITION1)
LOG FILE : PersonNumber: 851780,AD2,PC,07/08/2020
INPUTS ARE OPERATION (text), LINENO (number), LINESEQUENCE(number), LINEREPEATNO (number),POSITION1 (text), POSITION2 (text), POSITION3 (text), POSITION4 (text), POSITION5 (text), POSITION6 (text)
/* Database Item Defaults- */
DEFAULT FOR POSITION1 IS 'NO DATA'
DEFAULT FOR POSITION2 IS 'NO DATA'
DEFAULT FOR POSITION3 IS 'NO DATA'
DEFAULT FOR POSITION4 IS 'NO DATA'
1