![](https://mytechnojournal.com/wp-content/uploads/2024/05/image-34.png)
Steps to Create Customer
Setup: Financials
Revenue Management: Create Customer
After click on create customer and then fill up required fields such as customer type, name, account address set, account established date
![](https://mytechnojournal.com/wp-content/uploads/2024/05/image-26-1024x450.png)
On the Address section, fill up the fields such as Site Name and the appropriate Address.
![](https://mytechnojournal.com/wp-content/uploads/2024/05/image-27-1024x549.png)
On the Address Purpose section, make sure to add the “Bill To” and “Ship To” purpose as these are the two most important purpose of a Customer Site.
![](https://mytechnojournal.com/wp-content/uploads/2024/05/image-28-1024x221.png)
Click on “Save and Close” to save your work
Setup: Financials
Revenue Management: Manage Customers
Search with organization name –>MAST_CUSTOMER_1
![](https://mytechnojournal.com/wp-content/uploads/2024/05/image-29-1024x289.png)
Continue….
And then click on Site Number (1343511) (This is my site number, your site number will be different)
After click on site number and then go to Extreme downward on the same page
And then click on + symbol ( Extreme right Downward)
![](https://mytechnojournal.com/wp-content/uploads/2024/05/image-30-1024x331.png)
Continue……
And then click on + symbol
![](https://mytechnojournal.com/wp-content/uploads/2024/05/image-31-1024x464.png)
Continue…
And then click on OK button
![](https://mytechnojournal.com/wp-content/uploads/2024/05/image-32-1024x353.png)
And then click on Save –> Save and close –> Done
Result of Create Customer (Order Management )
Customer –> MAST_CUSTOMER_1
![](https://mytechnojournal.com/wp-content/uploads/2024/05/image-33-1024x430.png)
How to Load Customers in Spreadsheet
Navigate to Receivable> Billing
![](https://mytechnojournal.com/wp-content/uploads/2024/06/image-1024x270.png)
In Billing Dashboard navigate to Task Panel.
Select Upload customer with Spreadsheet
![](https://mytechnojournal.com/wp-content/uploads/2024/06/image-1-1024x222.png)
download the Customer spredsheet template
![](https://mytechnojournal.com/wp-content/uploads/2024/06/image-2.png)
Open the Spreadsheet template and prepare the data for the customer
How to Upload customer through FBDI template
Download the FBDI template from Oracle Portal
Please click this link to get the FBDI template for customer upload
![](https://mytechnojournal.com/wp-content/uploads/2024/06/image-3-1024x368.png)
Download the FBDI template
![](https://mytechnojournal.com/wp-content/uploads/2024/06/image-4.png)
Prepare the data for customer template and convert to CSV file
Upload the data to UCM directory -staging table in Oracle Fusion
Navigate to Tools>File Import Export
![](https://mytechnojournal.com/wp-content/uploads/2024/06/image-5.png)
Select the UCM directory as Fin>Receivables>Import
![](https://mytechnojournal.com/wp-content/uploads/2024/06/image-6-1024x463.png)
Stage the Customer upload CSV file to this directory
Then run the Load Interface file for Import -Interface program to move the data to Interface
Navigate to Tools> Schedule Process
Select the Import process as- Upload Customer
![](https://mytechnojournal.com/wp-content/uploads/2024/06/image-8.png)
![](https://mytechnojournal.com/wp-content/uploads/2024/06/image-9-1024x622.png)
Once the data uploaded to Interface successfully run the Base program -Upload customer
Provide a Batch name and select the Import Process id
![](https://mytechnojournal.com/wp-content/uploads/2024/06/image-10.png)