I am stumped.
Can someone help or point me where to figure out how I can drop a file into the file reader, read it in, and create a new record in a custom logic unit?
I know I could do this with existing LUs using BizAPI but the LU I’m using is custom and has no BizAPI for it.
Best answer by NSRJMITCHELL
I ended up creating a custom PL/SQL package function that accepts a clob and extracts the values using a cursor. I then iterate over the cursor and insert the values into the custom table. I call this custom function from a Routing Rule and Routing Address when the file is read in.