Customer Import

The template used to generate the Comma Separated Values (CSV) file for loading customer data from legacy and external sources to Trading Community Registry and Receivables.

Details

• Object owner: FIN:Receivables:Customer

• UCM account: fin/receivables/import

File Links

File	Link
XLSM template	CustomerImportTemplate.xlsm
Control files	Parties Import Control File Party Sites Import Control File Party Site Uses Import Control File Customer Accounts Import Control File Customer Account Sites Import Control File Customer Account Site Uses Import Control File Customer Account Relationships Import Control File Customer Account Contacts Import Control File Contact Points Import Control File Contact Roles Import Control File Contacts Import Control File Locations Import Control File Party Relationships Import Control File Party Role Responsibilities Import Control File Classifications Import Control File Person Languages Import Control File Customer Profiles Import Control File Customer Receipt Methods Import Control File Customer Bank Accounts Import Control File

Job and Table Links

Name	Link
Scheduled process	Import Trading Community Data in Bulk
Tables	HZ_IMP_ACCOUNTRELS HZ_IMP_ACCOUNTS_T HZ_IMP_ACCTCONTACTS_T HZ_IMP_ACCTSITES_T HZ_IMP_ACCTSITEUSES_T HZ_IMP_CLASSIFICS_T HZ_IMP_CONTACTPTS_T HZ_IMP_CONTACTROLES HZ_IMP_CONTACTS_T HZ_IMP_LOCATIONS_T HZ_IMP_PARTIES_T HZ_IMP_PARTYSITES_T HZ_IMP_PARTYSITEUSES_T HZ_IMP_PERSONLANG HZ_IMP_RELSHIPS_T HZ_IMP_ROLERESP RA_CUSTOMER_BANKS_INT_ALL RA_CUSTOMER_PROFILES_INT_ALL RA_CUST_PAY_METHOD_INT_ALL

Related Topics

• Defining the Import Process for Customers and Consumers: Points to Consider

• Defining the Import Process for Customers and Consumers: Worked Example

• External Data Integration Services for Oracle Cloud: Overview

• Import Trading Community Information FAQs

• Performing What-If Analysis on Data Import Batches: Worked Example

• Trading Community Model Data Import Objects: Explained