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.
- Navigation File Explorer > Tools > Schedule Processor
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.
No comments:
Post a Comment