Supplier Banking Interface in Oracle Cloud : How to Import Supplier Bank Information in Oracle Fusion
We need to have Supplier banking information's in Oracle cloud to do the payments for their invoices or bills. These banking information's involved Supplier Bank , Branch , Bank Account , IFSC code , BIC code and many other banking related important information's. We can maintain these information in Oracle cloud manually in the supplier master but if you are importing the supplier form external application then you will definitely have the mass banking data for the supplier and the manual job is very time consuming so for this oracle cloud has given the standard interface in oracle cloud to import the mass banking information of the suppliers.
Oracle cloud has given the FBDI tool to import the supplier banking information in Oracle cloud. FBDI is the standard template given by the Oracle cloud to import the data from the external applications in the oracle cloud. Here I will share the details steps for Supplier Banking Interface in Oracle Cloud.
Steps to Import Supplier Bank Information in Oracle Fusion
1.First we need to download the Supplier Banking Information FBDI template from the Oracle Repository.
You can refer this url : https://docs.oracle.com/cloud/farel11/financialscs_gs/OEFBF/Supplier_Bank_Account_Import_10138496_fbdi_22.htm#10138496
2. You need to prepare the Supplier banking data according to this FBDI template and then this templates will create the ZIP folder having csv files.
3. Once the ZIP folder created from FBDI template then you need to upload this folder in the UCM folder under the specified path.
4.Once the File uploaded in UCM then we need to run the Schedule process ' Load Interface File for Import'.
5.In the Last we need to run the program 'Import Supplier Bank Accounts'.
Example of Importing Supplier Banking Information in Oracle Fusion/Cloud
1. Download the Import Supplier Bank Information Template from below
You can refer this url : https://docs.oracle.com/cloud/farel11/financialscs_gs/OEFBF/Supplier_Bank_Account_Import_10138496_fbdi_22.htm#10138496
2. Here below you need to click as highlighted below.
3. This is the FBDI template for the Supplier Banking which have three tabs , we need to enter the Data in all these three tabs or sheets.
Step4:- Enter data in the First sheet like that.
Step5:- Enter data in the Second sheet like that.
Steo6:- Enter data in the Third sheet like that.
Once you have prepared the data in all these three sheets then we need to create the ZIP folder of this Data to upload in the Oracle Cloud.
Go to 'First Tab' 'Instructions and CSV Generation' and then click on the Highlighted button and this will create the ZIP folder having csv files.
Step7:- Then Go to Schedule Processes.
Step8:- Run the Program 'Load Interface File for Import'
Step9:- Enter the Parameters as below
Import Process : Import Supplier Bank Accounts
In the Data File Paraters , You need to Upload the ZIP folder of the Bank FBDI file.
Step10 :-
Once the Program 'Load Interface File for Import' completed successfully then we need to run the second program 'Import Supplier Bank Accounts' as below
One the Program will be created your supplier Banking information's will start appearing in the supplier Master.
How to Import Supplier Bank Information in Oracle Fusion
0 comments:
Post a Comment