Wednesday, February 9, 2022

OIC - ERP Supplier bulk import and callback

Highlevel steps:

  • List the files using ftp connection
  • Use for each and each file ref 
    • Download the file
    • Read file in segments using source supplier file csv schema
    • Write the fbdi format file to stage location
    • Write a property file in the same stage location
    • Zip the files
    • Import the zip files as bulk import to cloud erp adpater.
  • Create another integration for callback and log or write the callback status and doc id.
What files you need to do the POC:
  • SupplierSource.csv
  • PozSuppliersInt.csv


Supplier import template: Click on SupplierImportTemplate.xlsm

Property file(


Steps with POC Screenshots :

ERP Scheduled Processes:

1 comment:

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...