Customer Interface Error Codes
Contents |
when you run Customer Interface. RA_CUSTOMERS_INTERFACE This table stores customer, address, and business purpose information. You do not
Fortigate Interface Errors
have to enter values in this table if you do not input errors on interface cisco router want to import customers, addresses, or business purposes. Column Name Value ADDRESS1 through 4 Enter the input errors on interface cisco switch address for your customer in these four columns. You can enter up to four lines of an address. Validation: If you enter a value in ORIG_SYSTEM_ADDRESS_REF, you http://oraappss.blogspot.com/2013/01/customer-interface-status-error-codes.html must enter a value in ADDRESS1. For multiple rows with the same address reference, insert values in address 1-4. Destination: RA_ADDRESSES.ADDRESS1, RA_ADDRESSES.ADDRESS2, RA_ADDRESSES.ADDRESS3, RA_ADDRESSES.ADDRESS4 CITY STATE PROVINCE COUNTY POSTAL_CODE COUNTRY Enter the city, state, province, county, and postal code for this customer's address. You must enter values that have already been defined in https://docs.oracle.com/cd/A60725_05/html/comnls/us/ar/cusimp08.htm AR_LOCATION_VALUES if Address Validation is set to 'Error' and you are calculating sales tax. You must do this for each address component on which your tax location flexfield structure is based. If Address Validation is set to 'No Validation' and you pass a value that does not exist in AR_LOCATION_VALUES, Customer Interface inserts this value into AR_LOCATION_VALUES. You must always enter a value for Country. Validation: The county must exist in FND_TERRITORIES. Destination: RA_ADDRESSES.CITY, RA_ADDRESSES.STATE, RA_ADDRESSES.PROVINCE, RA_ADDRESSES.COUNTY RA_ADDRESSES.POSTAL_CODE, RA_ADDRESSES.COUNTRY ADDRESS_KEY This column is not currently used by Customer Interface. BILL_TO_ORIG_ ADDRESS_REF Enter the Bill-To location that you want to associate with the Ship-To address on this record. Validation: You can enter a value only if the SITE_USE_CODE column in this record is 'Ship-To'. Also, the Bill-To address must exist for this customer or any related customers. Destination: RA_SITE_USES.BILL_TO_SITE_USE_ID CUSTOMER_ ATTRIBUTE_ CATEGORY Enter Descriptive Flexfield category information. These columns are optional. ADDRESS_ ATTRIBUTE_ CATEGORY SITE_USE_ ATTRIBUTE_ CATEGORY Validation: None
into your database.This chapter covers the following topics:Customer InterfacePreparing for ImportInterface Data Required to Run Customer InterfaceSystem Tables Updated by Customer InterfaceA https://docs.oracle.com/cd/E18727_01/doc.121/e13570/T172155T393841.htm Sample Customer ImportCreating Unique Customer ReferencesImporting Customers Using Customer InterfaceCustomer Interface Transfer Report Customer Interface Use Customer Interface to import current or historical customer information from other systems into your database. Once customer information is imported, you can use Customer Interface to import additional data for that customer (such as interface error additional contacts or addresses) and to update existing information. You can also manually update and enter new information using the Customers set of pages. Important: You can use Customer Interface to import both party and account information, including accounts that are associated with parties already loaded into your database. customer interface error However, customer Interface runs independently and does not regard party level information already loaded into your database using Bulk Import. If you plan to use Customer Interface to import accounts that are associated with parties that have already been imported using Bulk Import, you must ensure that the source ID alone is unique across all source systems in the bulk import process. While Bulk Import requires source IDs to be unique only within an identified source system, customer interface does not recognize the source system and therefore requires that the source ID is unique across all sources systems. See: Bulk Import Overview. Loading Data into the Interface Tables. Unique Source IDs for Importing Associated Accounts.
The following diagram shows how customer information is imported into the customer tables. Customer Interface Process This illustration demonstrates that an import program is used to format and load data fr