|
|
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. |