Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best way to automate uploading a spreadsheet of orders

Bob Cagle - IT Manager - LynkSep 24 2020 — edited Feb 8 2021

On World A9.3.1

Setting up a new customer that will be sending us orders via CSV files thru an FTP server - one order per file.  What's the best practice for automating this upload?  What are my options?

Write an RPG to process the CSV and upload into the F47 files and treat it like any other inbound 850?  If so, what are the absolute minimum fields required to be loaded in the F47 files to accomplish this?

Or utilize the Z-file batch import process?  And how would that be automated?

Any other suggestions?

I already have the code in place to pull & push the files from the FTP server.

Thanks

Bob

Comments
Post Details
Added on Sep 24 2020
0 comments
207 views