Automate ERP Cloud Batch Uploads using Oracle MFT and Integration Cloud Service

In this blog, we will use Oracle Managed File Transfer (MFT) and Integration Cloud Service (ICS) to automate batch uploads into Oracle ERP Cloud. We will perform this upload with invoices, a typical use-case for organisations that work with numerous vendors and would like their vendors to bulk invoice them through say an SFTP file drop.

Steps are as follows:

  1. Drop the file into an SFTP folder that is managed by MFT
  2. MFT picks it up and uploads it into ERP Cloud’s WebCenter Content file repository
  3. MFT calls ICS to trigger a multi-step orchestration to load ERP Cloud
  4. Using the ICS ERP Cloud adapter, the ICS orchestration first loads the file into staging tables and import the invoice into final tables

Folks who have read my previous blog, Using MFT Cloud Service to Automate HCM Batch Uploads – Part 1 will notice how similar this is to HCM Data Loading, except that we use ICS to orchestrate a few post-load steps.

That is because HCM and ERP Cloud (also SCM and SalesCloud) are all Oracle Fusion Applications, modules built on the same platform. Some of you may even be on “Global Shared Instances”, essentially running both your HCM and ERP SaaSes in the same instance.

Continue reading “Automate ERP Cloud Batch Uploads using Oracle MFT and Integration Cloud Service”

Oracle Developer Days, Partner Technical Forum – Melbourne

Join us at this 2 day Partner Technical Forum (PTF) being held on Tuesday 9th & Wednesday 10th May 2017 in our Melbourne office at Level 5, 417 St Kilda Road.

On the 1st day, hear about the latest updates on Oracle Cloud IAAS and PAAS Strategy & Portfolio.

Oracle Cloud Platform Practitioners sharing latest Cloud Announcements & Roadmaps for areas such as:

  •     Application Container, Oracle Container & Developer Cloud Services
  •     Integration Capabilities, PAAS for SAAS
  •     App Builder, Process & Mobile Cloud Services
  •     APIs, Devops & Microservices
  •     Identity Management

If you choose to attend the 2nd day, join the “Hands-On” experience with a number of the above Cloud Services.

For those attending Day 1 and/or Day 2, you are also invited to the PTF Dinner following Day 1, on Tuesday 9th May at the Royce Hotel.

For further details visit the registration page:   http://bit.ly/PTF-melb