E1: ORCH: CSV File Load Using a Custom Step (Create Array) Fails to Read The CSV File That is Uploaded. (Doc ID 3001010.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Symptoms

Attempting to load a CSV file using the Custom Step (Create Array) and the orchestration is not loading the csv file correctly.  

The guide specifically says if you turn on the toggle bar, then it will read the temp folder instead of the session folder.

Reference doc: JD Edwards EnterpriseOne Tools:  Orchestrator Guide

Section: "Defining Files as Orchestration Input (Release 9.2.6)"


Error:
---------

Steps to Duplicate:
------------------------------

1. Create a custom step with "Create Array".
2. select CSV file
3. Name the Data Set Variable Name and CSV has headers on.
4. using the "Sample File" button, load your csv file. 
5. This will identify the column names.  You can set the header fields if you have any.
   
6. save and create an orch.
7. Go to "Inputs and Values" for the orch and select "File Inputs" 
8. Select Process Files As an array
9. turn on the "Keep Temp Files" toggle
10. Put anything in File Array Name
    
11. in the transformation of the custom step, select your array name in the "Iterate Over"
12. save the orch and run
13. make sure you import the csv file by clicking on the "Files(0)" icon. 
    
14. You will receive the above error

Cause

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