Designing with Application Adapters

Customer Interface

The Customer Interface Errors are as listed in the table.

Table 1–23 Customer Interface Errors

Error Code 

Error Message 

SB-AR-PHONES-10700 

CREATED_BY cannot be NULL. 

SB-AR-PHONES-10701 

CREATION_DATE cannot be NULL. 

SB-AR-PHONES-10702 

INSERT_UPDATE_FLAG cannot be NULL. 

SB-AR-PHONES-10703 

LAST_UPDATED_BY cannot be NULL. 

SB-AR-PHONES-10704 

LAST_UPDATE_DATE cannot be NULL. 

SB-AR-PHONES-10705 

ORIG_SYSTEM_CONTACT_REF cannot be NULL. 

SB-AR-PHONES-10706 

ORIG_SYSTEM_TELEPHONE_REF cannot be NULL. 

SB-AR-PHONES-10707 

ORIG_SYSTEM_CUSTOMER_REF cannot be NULL. 

SB-AR-PHONES-10708 

CONTACT_JOB_TITLE does not exist in AR_LOOKUPS table. 

SB-AR-PHONES-10709 

CONTACT_TITLE does not exist in AR_LOOKUPS table. 

SB-AR-PHONES-10710 

ORIG_SYSTEM_CUSTOMER_REF does not exist in HZ_CUST_ACCOUNTS table. 

SB-AR-PHONES-10711 

ORIG_SYSTEM_ADDRESS_REF does not exist in HZ_CUST_ACCT_SITES_ALL table. 

SB-AR-PHONES-10712 

ORIG_SYSTEM_CONTACT_REF does not exist in HZ_ORG_CONTACTS table. 

SB-AR-PHONES-10713 

ORIG_SYSTEM_TELEPHONE_REF does not exist in HZ_CONTACT_POINTS table. 

SB-AR-PHONES-10714 

TELEPHONE_TYPE does not exist in AR_LOOKUPS table. 

SB-AR-PHONES-10715 

INSERT_UPDATE_FLAG should be either I or U. 

SB-AR-PHONES-10716 

TELEPHONE cannot be null if ORIG_SYSTEM_TELEPHONE_REF entered. 

SB-AR-PHONES-10717 

CONTACT_LAST_NAME cannot be null if ORIG_SYSTEM_CONTACT_REF entered. 

SB-AR-PHONES-10718 

ORIG_SYSTEM_TELEPHONE_REF cannot be null if TELEPHONE entered. 

SB-AR-PHONES-10719 

TELEPHONE_TYPE cannot be null if ORIG_SYSTEM_TELEPHONE_REF entered. 

SB-AR-PAY-10300 

ORIG_SYSTEM_CUSTOMER_REF is a required column. Enter a valid value. 

SB-AR-PAY-10301 

PAYMENT_METHOD_NAME is a required column. Enter a valid value. 

SB-AR-PAY-10302 

PRIMARY_FLAG is a required column. Enter a valid value. 

SB-AR-PAY-10303 

START_DATE is a required column. Enter a valid value. 

SB-AR-PAY-10304 

LAST_UPDATED_BY is a required column. Enter a valid value. 

SB-AR-PAY-10305 

LAST_UPDATE_DATE is a required column. Enter a valid value. 

SB-AR-PAY-10306 

CREATION_DATE is a required column. Enter a valid value. 

SB-AR-PAY-10307 

CREATED_BY is a required column. Enter a valid value. 

SB-AR-PAY-10315 

Valid values for PRIMARY_FLAG column are Y,N. 

SB-AR-PAY-10316 

Valid values for VALIDATED_FLAG column are Y,N. 

SB-AR-PAY-10317 

PAYMENT_METHOD_NAME does not exist in table AR_RECEIPT_METHODS. 

SB-AR-PAY-10318 

ORIG_SYSTEM_CUSTOMER_REF does not exist in table RA_CUSTOMERS and SB_RA_CUSTOMERS_INTERFACE. 

SB-AR-PAY-10319 

ORIG_SYSTEM_ADDRESS_REF does not exist in table RA_ADDRESSES and SB_RA_CUSTOMERS_INTERFACE. 

SB-AR-PAY-10320 

ORG_ID does not exist IN VIEW HR_ORGANIZATION_UNITS_V. 

SB-AR-BANKS-10200 

ORIG_SYSTEM_CUSTOMER_REF cannot be NULL. 

SB-AR-BANKS-10201 

BANK_ACCOUNT_NAME cannot be NULL. 

SB-AR-BANKS-10202 

PRIMARY_FLAG cannot be NULL. 

SB-AR-BANKS-10203 

START_DATE cannot be NULL. 

SB-AR-BANKS-10204 

LAST_UPDATE_DATE cannot be NULL. 

SB-AR-BANKS-10205 

LAST_UPDATED_BY cannot be NULL. 

SB-AR-BANKS-10206 

CREATION_DATE cannot be NULL. 

SB-AR-BANKS-10207 

CREATED_BY cannot be NULL. 

SB-AR-BANKS-10208 

BANK_ACCOUNT_CURRENCY_CODE cannot be NULL. 

SB-AR-BANKS-10209 

BANK_ACCOUNT_NUM cannot be NULL. 

SB-AR-BANKS-10210 

BANK_BRANCH_NAME cannot be NULL. 

SB-AR-BANKS-10211 

ORIG_SYSTEM_ADDRESS_REF cannot be NULL if the bank details are entered.Also it should be equal to BILL_TO address. 

SB-AR-BANKS-10212 

BANK_ACCOUNT_CURRENCY_CODE does not exist in FND_CURRENCIES table. 

SB-AR-BANKS-10213 

BANK_ACCOUNT_NAME does not exist in AP_BANK_ACCOUNTS table. 

SB-AR-BANKS-10214 

BANK_NUMBER does not exist in AP_BANK_BRANCHES table. 

SB-AR-BANKS-10215 

BANK_NUM should be unique in AP_BANK_BRANCHES table. 

SB-AR-BANKS-10216 

BANK_BRANCH_COUNTRY does not exist in FND_TERRITORIES table. 

SB-AR-BANKS-10217 

END_DATE should be greater than START_DATE. 

SB-AR-BANKS-10218 

ORIG_SYSTEM_CUSTOMER_REF does not exist in HZ_CUST_ACCOUNTS table. 

SB-AR-BANKS-10219 

PRIMARY_FLAG should be either Y or N. 

SB-AR-BANKS-10220 

BANK_NAME,BANK_BRANCH_NAME should be unique in AP_BANK_BRANCHES table. 

SB-AR-BANKS-10221 

BANK_NAME cannot be NULL. 

SB-AR-BANKS-10222 

ORIG_SYSTEM_ADDRESS_REF does not exist in HZ_CUST_ACCT_SITES_ALL or SB_RA_CUSTOMERS_INTERFACE table.The address specified must have an active BILL_TO site defined. 

SB-AR-CUST-10000 

ORIG_SYSTEM_CUSTOMER_REF cannot be NULL. 

SB-AR-CUST-10001 

SITE_USE_CODE cannot be NULL. 

SB-AR-CUST-10002 

ORIG_SYSTEM_ADDRESS_REF cannot be NULL. 

SB-AR-CUST-10003 

INSERT_UPDATE_FLAG cannot be NULL. 

SB-AR-CUST-10004 

CUSTOMER_NAME cannot be NULL. 

SB-AR-CUST-10005 

CUSTOMER_NUMBER cannot be NULL. 

SB-AR-CUST-10006 

CUSTOMER_STATUS cannot be NULL. 

SB-AR-CUST-10007 

LAST_UPDATED_BY cannot be NULL. 

SB-AR-CUST-10008 

LAST_UPDATE_DATE cannot be NULL. 

SB-AR-CUST-10009 

CREATED_BY cannot be NULL. 

SB-AR-CUST-10010 

CREATION_DATE cannot be NULL. 

SB-AR-CUST-10011 

LOCATION cannot be NULL. 

SB-AR-CUST-10025 

SITE_USE_CODE does not exists in AR_LOOKUPS table. 

SB-AR-CUST-10026 

CUSTOMER_TYPE does not exists in AR_LOOKUPS table. 

SB-AR-CUST-10027 

ORIG_SYSTEM_PARENT_REF does not exists in RA_CUSTOMERS table. 

SB-AR-CUST-10028 

CUSTOMER_CATEGORY_CODE does not exists in AR_LOOKUPS table. 

SB-AR-CUST-10029 

CUSTOMER_CLASS does not exists in AR_LOOKUPS table. 

SB-AR-CUST-10030 

DEMAND_CLASS_CODE does not exists in FND_COMMON_LOOKUPS table. 

SB-AR-CUST-10031 

CUST_SHIP_VIA_CODE does not exists in ORG_FREIGHT table. 

SB-AR-CUST-10032 

LANGUAGE does not exists in FND_LANGUAGES table. 

SB-AR-CUST-10033 

CUST_TAX_CODE value should match with TAX_CODE value of AR_VAT_TAX Table. 

SB-AR-CUST-10034 

SITE_USE_TAX_CODE value should match with TAX_CODE value of AR_VAT_TAX Table. 

SB-AR-CUST-10050 

ADDRESS cannot be NULL. 

SB-AR-CUST-10051 

INSERT_UPDATE_FLAG should be either I - Insert or U - Update. 

SB-AR-CUST-10052 

CUSTOMER_STATUS should be either A - Active or I - Inactive. 

SB-AR-CUST-10053 

CUSTOMER_TYPE should be either I - Internal or R - External. 

SB-AR-CUST-10054 

PRIMARY_SITE_USE_FLAG should be either Y - Yes or N - No or NULL. 

SB-AR-CUST-10055 

BILL_TO_ORIG_ADDRESS_REFP cannot be NULL. 

SB-AR-CUST-10056 

ORIG_SYSTEM_ADDRESS_REF does not exist in RA_ADDRESSES table. 

SB-AR-CUST-10057 

ORIG_SYSTEM_CUSTOMER_REF Value should be validated against the RA_CUSTOMERS Table based on Insert_Update_Flag Value. 

SB-AR-CUST-10058 

CITY,PROVINCE,STATE,COUNTY,POSTAL CODE, and COUNTRY fields should not be null and have valid data when ADDRESS1 is Not Null. 

SB-AR-CUST-10059 

PRIMARY SITE USE FLAG Should not be null when ADDRESS1 is not null. 

SB-AR-PROFILE-10100 

INSERT_UPDATE_FLAG is a required column. Enter a valid value. 

SB-AR-PROFILE-10101 

ORIG_SYSTEM_CUSTOMER_REF is a required column. Enter a valid value. 

SB-AR-PROFILE-10102 

CREDIT_HOLD is a required column. Enter a valid value. 

SB-AR-PROFILE-10103 

LAST_UPDATED_BY is a required column. Enter a valid value. 

SB-AR-PROFILE-10104 

LAST_UPDATE_DATE is a required column. Enter a valid value. 

SB-AR-PROFILE-10105 

CREATION_DATE is a required column. Enter a valid value. 

SB-AR-PROFILE-10106 

CREATED_BY is a required column. Enter a valid value. 

SB-AR-PROFILE-10108 

Valid values for CREDIT_BALANCE_STATEMENTS column are Y,N. 

SB-AR-PROFILE-10109 

CREDIT_BALANCE_STATEMENTS must be N when STATEMENTS = N.Mandatory when STATEMENTS =Y. Must be null when STATEMENTS is null. 

SB-AR-PROFILE-10111 

Valid VALUES FOR CREDIT_CHECKING COLUMN are Y,N. 

SB-AR-PROFILE-10112 

Valid VALUES FOR CREDIT_HOLD COLUMN are Y,N. 

SB-AR-PROFILE-10113 

Valid VALUES FOR DISCOUNT_TERMS COLUMN are Y,N. 

SB-AR-PROFILE-10114 

Valid VALUES FOR DUNNING_LETTERS COLUMN are Y,N. 

SB-AR-PROFILE-10115 

Valid VALUES FOR INTEREST_CHARGES COLUMN are Y,N. 

SB-AR-PROFILE-10116 

Valid VALUES FOR STATEMENTS COLUMN are Y,N. 

SB-AR-PROFILE-10117 

Valid VALUES FOR OVERRIDE_TERMS COLUMN are Y,N. 

SB-AR-PROFILE-10118 

Valid VALUES FOR CHARGE_ON_FINANCE_CHARGE_FLAG COLUMN are Y,N.Required IF INTEREST_CHARGES IS SET TO Y AND no PROFILE class IS specified. 

SB-AR-PROFILE-10120 

CHARGE_ON_FINANCE_CHARGE_FLAG not required IF INTEREST_CHARGES IS SET TO N OR NULL. 

SB-AR-PROFILE-10121 

Valid VALUES FOR AUTO_REC_INCL_DISPUTED_FLAG COLUMN are Y,N. 

SB-AR-PROFILE-10122 

Valid VALUES FOR CONS_INV_FLAG COLUMN are Y,N. 

SB-AR-PROFILE-10123 

Valid VALUES FOR CONS_INV_TYPE COLUMN are SUMMARY,DETAIL,WHEN CON_INV_FLAG IS Y. 

SB-AR-PROFILE-10124 

CURRENCY_CODE required IF ANY one OF the following COLUMNS have VALUES. 

SB-AR-PROFILE-10125 

CURRENCY_CODE does not exist IN TABLE FND_CURRENCIES. 

SB-AR-PROFILE-10126 

CUSTOMER_PROFILE_CLASS_NAME does not exist IN TABLE HZ_CUST_PROFILE_CLASSES. 

SB-AR-PROFILE-10127 

IF COLUMN CUSTOMER_PROFILE_CLASS_NAME IS NULL,THEN enter the following COLUMNS COLLECTOR_NAME, CREDIT_BALANCE_STATEMENTS, CREDIT_CHECKING,’ || ’AUTO_REC_INCL_DISPUTED_FLAG, DISCOUNT_TERMS, DUNNING_LETTER, DUNNING_LETTER_SET_NAME, INTEREST_CHARGES, INTEREST_PERIOD_DAYS, CHARGE_ON_FINANCE_CHARGE_FLAG,’ || ’STATEMENTS, STATEMENT_CYCLE_NAME, TOLERANCE, TAX_PRINTING_OPTION, OVERRIDE_TERMS, GROUPING_RULE_NAME, STATEMENTS, CHARGE_ON_FINANCE_CHARGE_FLAG, AUTOCASH_HIERARCHY_NAME. 

SB-AR-PROFILE-10128 

ACCOUNT_STATUS does not exist IN TABLE AR_LOOKUPS. 

SB-AR-PROFILE-10129 

AUTOCASH_HIERARCHY_NAME does not exist IN TABLE AR_AUTOCASH_HIERARCHIES. 

SB-AR-PROFILE-10130 

COLLECTOR_NAME does not exist IN TABLE AR_COLLECTORS. 

SB-AR-PROFILE-10131 

CREDIT_RATING does not exist IN TABLE AR_LOOKUPS. 

SB-AR-PROFILE-10132 

DISCOUNT_GRACE_DAYS Must be greater than OR equal TO 0 AND, must be NULL WHEN DISCOUNT_TERMS IS NULL OR No. 

SB-AR-PROFILE-10133 

DUNNING_LETTER_SET_NAME does not exist IN TABLE AR_DUNNING_LETTER_SETS. 

SB-AR-PROFILE-10134 

DUNNING_LETTER_SET_NAME mandatory WHEN DUNNING_LETTERS IS Yes.Must be NULL WHEN DUNNING_LETTERS IS No OR NULL. 

SB-AR-PROFILE-10135 

GROUPING_RULE_NAME does not exist IN TABLE RA_GROUPING_RULES. 

SB-AR-PROFILE-10136 

INTEREST_PERIOD_DAYS must be greater than OR equal TO zero, mandatory when INTEREST_CHARGES value is Y. Must be NULL when INTEREST_CHARGES value is N OR NULL. 

SB-AR-PROFILE-10137 

ORIG_SYSTEM_CUSTOMER_REF does not exist IN TABLE RA_CUSTOMERS AND SB_RA_CUSTOMERS_INTERFACE. 

SB-AR-PROFILE-10138 

ORIG_SYSTEM_ADDRESS_REF does not exist IN TABLE RA_ADDRESSES AND SB_RA_CUSTOMERS_INTERFACE. 

SB-AR-PROFILE-10139 

TRX_CREDIT_LIMIT AND OVERALL_CREDIT_LIMIT must both be filled IN,OR both be NULL. 

SB-AR-PROFILE-10140 

RISK_CODE does not exist IN TABLE AR_LOOKUPS. 

SB-AR-PROFILE-10141 

STANDARD_TERM_NAME does not exist IN TABLE RA_TERMS. 

SB-AR-PROFILE-10142 

STATEMENT_CYCLE_NAME does not exist IN TABLE AR_STATEMENT_CYCLES. 

SB-AR-PROFILE-10143 

STATEMENT_CYCLE_NAME must be NULL WHEN STATEMENTS IS No OR NULL. Mandatory WHEN STATEMENTS IS Yes. 

SB-AR-PROFILE-10144 

TAX_PRINTING_OPTION does not exist IN TABLE AR_LOOKUPS. 

SB-AR-PROFILE-10145 

CLEARING_DAYS must be greater than OR equal TO zero. 

SB-AR-PROFILE-10146 

PAYMENT_GRACE_DAYS must be greater than OR equal TO zero. 

SB-AR-PROFILE-10147 

TOLERANCE must be BETWEEN -100 AND 100. 

SB-AR-PROFILE-10148 

ORG_ID does not exist IN VIEW HR_ORGANIZATION_UNITS_V.