1. Tables and Views for Financials
  2. AR_UPD_CONTACTS_ERRORS

AR_UPD_CONTACTS_ERRORS

AR_UPD_CONTACTS_ERRORS contains data validation error information for customer contact interface data that failed during upload.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

AR_UPD_CONTACTS_ERRORS_PK

CONTACT_ERROR_ID

Columns

Name Datatype Length Precision Not-null Comments
CONTACT_ERROR_ID NUMBER 18 Yes Unique identifier of the customer contacts upload error record.
BATCH_ID NUMBER 18 Yes Unique identifier for a customer import batch process.
ORIG_SOURCE_SYSTEM VARCHAR2 30 Yes Original source system for importing customer, customer account, address, and address purpose.
CUST_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the customer account.
CUST_SITE_ORIG_SYS_REF VARCHAR2 240 Original System Reference for the customer account site.
CUST_CONTACT_ORIG_SYS_REF VARCHAR2 240 Original system reference for the customer account contact.
REL_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the party relationship.
PARTY_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original System Reference for the customer party.
SITE_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the customer party site.
CP_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the customer contact point.
CONTACT_ROLE_ORIG_SYS_REF VARCHAR2 240 Original system reference for the customer contact role.
SUB_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the customer who is the subject of the relationship.
OBJ_ORIG_SYSTEM_REFERENCE VARCHAR2 240 Original system reference for the customer who is the object of the relationship.
ROLE_RESP_ORIG_SYS_REF VARCHAR2 240 Original system reference for the customer account contact role responsibility.
CONTACT_POINT_TYPE VARCHAR2 30 Contact point type. Values are from the lookup CONTACT_POINT_TYPE. For examples, phone, fax, e-mail, web, telex, instant messaging, or EDI.
PHONE_LINE_TYPE VARCHAR2 30 Values of the PHONE_LINE_TYPE lookup, such as general, fax, inbound, or outbound.
INTERFACE_TABLE_NAME VARCHAR2 30 Associated interface table for the error message.
ERROR_MESSAGE_NAME VARCHAR2 30 Name of a customer import error message.
ORIGINAL_ERROR_MESSAGE VARCHAR2 30 Original TCA error message raised during customer import.
TOKEN1_NAME VARCHAR2 80 Token name for the error message.
TOKEN1_VALUE VARCHAR2 80 Token value for the error message.
TOKEN2_NAME VARCHAR2 80 Token name for the error message.
TOKEN2_VALUE VARCHAR2 80 Token value for the error message.
TOKEN3_NAME VARCHAR2 80 Token name for the error message.
TOKEN3_VALUE VARCHAR2 80 Token value for the error message.
TOKEN4_NAME VARCHAR2 80 Token name for the error message.
TOKEN4_VALUE VARCHAR2 80 Token value for the error message.
TOKEN5_NAME VARCHAR2 80 Token name for the error message.
TOKEN5_VALUE VARCHAR2 80 Token value for the error message.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.

Indexes

Index Uniqueness Tablespace Columns
AR_UPD_CONTACTS_ERRORS_U1 Unique Default CONTACT_ERROR_ID