Sunday 28 April 2019

How to Upload Customer Contact Informations in Oracle Cloud Through FBDI : Customer Contact Interface in Oracle cloud

How to Upload Customer Contact Information's in Oracle Cloud Through FBDI. Customer Contact Interface in Oracle Cloud

We maintain Customer Contact information's in Customer Master. Under Customer Master , We can store customer contact person and the other communication details for the customer like customer contact Phone , Email & Fax. In this post , I will share the steps to mass upload customer contact information in Oracle cloud. In Oracle Cloud , We have the FBDI/Interface to upload Customer & their contact information in Oracle cloud. Here below is the detail steps to upload new customers and their contact information in Oracle cloud.


Step to Upload Customer Contact Information's in Oracle Cloud Through FBDI

Step1:- Go to Receivables ==> Billing

How to Upload Customer Contact Informations in Oracle Cloud Through FBDI. Customer Contact Interface in Oracle cloud

Step2:- Under Tasks ==> Customer ==> Upload Customer from Spreadsheet.

How to Upload Customer Contact Informations in Oracle Cloud Through FBDI. Customer Contact Interface in Oracle cloud


Step3:-
As below this is the Customer Upload FBDI , here below is the multiple tabs inside which help to upload Customer Information's in Oracle cloud.


First Tab is uses to Upload customer Basic Information's like Customer Addresses , customer Sites details. In the Second Tab , We can upload the Customer Communications details. We can upload any type of Customer Contact information's  in this Tab. 

In the Third Tab , We can attached the Site to Different different Business Units and the can attach Other Important GL Accounts like REC , REV , TAX , FREIGHT for customers under Business Units.

First Tab is one of the Important Tab to upload information related to other Tab. We cannot upload customer contact In formations with out having this customer record in the First Tab 'Customers'
How to Upload Customer Contact Informations in Oracle Cloud Through FBDI. Customer Contact Interface in Oracle cloud


Step5:- 
We can Upload Customer Contacts under Customer Header Level and Customer Site Level.  Account number is the Customer Number and Site Number is the Party Site number , These two information or record should be exist in the First 'Customer' sheet too.

How to Upload Customer Contact Informations in Oracle Cloud Through FBDI. Customer Contact Interface in Oracle cloud




Step6:- Once the Data has been prepared then go to First Tab 'Instructions' and then click on 'Generate csv File' . 

Once the ZIP file has been created. Then we need to upload this in Oracle cloud.

Step7:- Go to Cloud application  Receivables ==> Billing

 Under Tasks ==> Customer ==> Upload Customer from Spreadsheet.








Step8:- Click on the 'Upload Customers from Spreadsheet' button to Upload customer Contact csv ZIP file in Oracle Cloud and to start processing of these records to upload in Oracle Cloud standard tables.

How to Upload Customer Contact Informations in Oracle Cloud Through FBDI. Customer Contact Interface in Oracle cloud






 How to Upload Customer Contact Information's in Oracle Cloud Through FBDI. Customer Contact Interface in Oracle cloud


1 comments:

Unknown said...

Any idea about how to upload the Contact's Role Type? It seems to not be a field available on the upload worksheet :(

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *