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:

 

ODI - How to read fixed length file and insert to db

Steps:

• Under Topology, 
• Choose file technology
• Create new data server or use existing one
•  Under data server, create new physical server. Provide file directory 
• Add context to logical schema.
• Under Design, create a file model or use existing one
• Create a new data store
• Provide name, choose sample resource fixed length file
• Under files, privide format as fixed and record separator as unix or ms dos as required.
• Under attributes, reverse engineer. It will open Atribute setup wizard.
• Now we can select the length of each field here just by clicking on the above and also see the field details in the side view.
• Once done. Press ok and it will show all the columns and slect the data type.
• Under projects, create a new map 
• Drag and drop file and db data stores and wire or map all the fields
• Go to physical and select LKM as LKM file to SQL and IKM as IKM Oracle control append or insert.
• Save and run with global context. Go to operator tab and check the session 
• Also verify from db table.

Steps with screenshots:

OIC - How to create fixed length file

Here We will show you how to create a fixed length file in OIC implementation.

Used fixed length schema:

You can go following my blog to know how to create fixed length file:

https://soalicious.blogspot.com/2022/02/xsd-how-to-create-fixed-length-schema.html

Steps with screenshots: