Mass Update Supplier Information’s in Oracle Fusion: Interface to update Suppliers Information’s in Oracle Cloud
Oracle cloud has given the Tools FBDI to insert or create
the suppliers from external system in Oracle cloud application. With the help
of the FBDI tool we can create mass suppliers in oracle fusion. Oracle has provided
the standard data templates in the form of FBDI to insert supplier information’s
from external application to Oracle application. But once the supplier’s
created in the cloud application then we can also mass update the suppliers’ information’s
with the help of FBDI. Mass update or change supplier information’s in the
supplier master is very common Requirment. To address this Requirment Oracle
cloud has provided the FBDI for take care both Create and Update needs.
Tool for Update Mass supplier Information’s in Oracle Cloud
As like new supplier Requirment, we use FBDI, in the same
way we can use this FBDI tool to mass update the supplier information’s in
Oracle Cloud. We just need to take care the Action Field of the FBDI Supplier template.
Oracle has given the common FBDI template to Create and Update suppliers in
Oracle Cloud. We need to use these below Template to update the supplier information’s
in Oracle fusion.
4 Important FBDI template to Update Supplier Information’s
1.
PozSuppliersInt
2.
SupplierAddressImportTemplate
3.
PozSupplierSitesInt
4.
SupplierSiteAssignmentImportTemplate
We create Suppliers in Oracle Cloud from Interface through
these four templates.
1.
First, we create the Supplier Headers with the
Help of PozSuppliersInt Template.
2.
Second, we create the Addresses for that supplier
with the help SupplierAddressImportTemplate
3.
Third we create the supplier site for Supplier
and for the Supplier address using PozSupplierSitesInt Temaplte
4.
Fourth We assign the supplier site to the
Operation Unit/ Business Unit using SupplierSiteAssignmentImportTemplate
Based on the above uses of these templates we need to select
the right template which will update the right information’s in the right level
of the supplier master.
Step by Step to Update Supplier's in Oracle cloud Through Interfaces
Step1:- Go to Oracle repository to download the relevant supplier FBDI templates as per the business Requirment to update suppliers Information's in Oracle cloud.
Go to this path for Oracle Repository.
Step2:- FBDI Template oracle
Step-2:- Go to Procurement Tab as below and Click on Release 11 under File-Based Data Import.
Step-3:- Then this below screen page will open.
Step 4:- Under File-Based Data Imports click on Import Supplier Data Template.
Step-5:- Click on XLSM template and save the data Template in our Desktop.
Step-6:- This is the Below Data Template for Import Supplier.
First Tab is the Instruction tab and Second Tab is the Data Template in which we will put data for suppliers.
Step-7:- Go to the Second Tab 'POZ_SUPPLIERS_INT' to update the supplier information's. Here I am only going to update the supplier Header level Info.
Choose the Import Action to 'UPDATE' for updating the Supplier Information's.
Step-8:- After Putting data in Data Template and then go back to first tab and Click on Generate CSV File button as below.
This will create PozSuppliersInt.zip file in your local system.
Step-10:- Click on Create Upload
Browse local drive to select PozSuppliersInt.zip file
Select Account – prc/supplier/import.
Click Save and Continue.
Step-11 :- Once the File will be Imported.
Click Navigator -> Tools -> Scheduled Process
Step-12:- Select ESS Job ‘Load Interface File for Import’
select the First Parameter : 'Import suppliers'
Second Parameter Data File : Select the File which have uploaded in the UCM (Step 10).
Once the program completed successfully. Then Run the Final Program Individually 'Import suppliers' in the Schedules processes. Once this program will be complete successfully then you supplier information's will be updated successfully.
0 comments:
Post a Comment