How data bursting works on oracle cloud using file-based data Import

Subject: Supplier Data Bursting on Oracle Cloud using File-Based Data Import

Oracle Standard Template Download Link: (Oracle Help Center)

https://docs.oracle.com/en/cloud/saas/procurement/19c/oefbp/supplier-model.html#importsupplieraddresses-3054

Step1: Download XLSM template (.XLSM)

Step2: Prepare data & read the instruction guide.

- Read Instruction:

- Prepare data

- Select Import Action Update/Create as per the business need.

Step3: Generate .CSV file.

- Click on Generate .CSV file button

-Save the .CSV file, It will save as .CSV and .zip format.

Step4: Required to upload .csv with .zip format on server. 

Navigator > Tools > File Import and Export.

- Click on + button to add .zip file

- Select .zip file

- Add Account details prc/supplier/import

- Click on Save and Close Button

- Data is not imported into the Interface table. For import data into interface required to run 'Load Interface File for Import' request

- Navigation File Explorer > Tools > Schedule Processor

- Run the 'Load Interface File for Import' request.

- Now data will be imported into the interface table.

Step5: Run Import Program.

- Navigate to Procurement > Suppliers > Task > Import Suppliers

-          Select Action> Import Supplier Address

-          Import Options: New

-          Click on Submit.

-          After successfully request completed we can verify the data. If at time of request run we get any error check request error log and correct the data and follow the same process again.

  

Note: For supplier master migration on cloud we have required to upload all listed category data one by one with the same process steps. Above all steps for supplier address migration steps only.

Purge Interface Table:

1. Select the ‘Purge Supplier Interface Records‘ process from the Actions menu on the Import Suppliers page.

2. Select which interface table to purge.

3. Select which interface records to purge.  To clear only records with errors, select Rejected.

4. Submit the process.