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
  • PozSupplier.properties

SupplierSource.csv:


Supplier import template: Click on SupplierImportTemplate.xlsm

https://docs.oracle.com/en/cloud/saas/procurement/21d/oefbp/importsuppliers-3219.html#importsuppliers-3219

Property file(PozSupplier.properties):

/oracle/apps/ess/prc/poz/supplierImport/,ImportSuppliers,PozSuppliersInt,NEW,N,#NULL,#NULL,#NULL


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...