Total Pageviews

Saturday, April 6, 2013


Oracle Apps Customer Interface Status error codes


If you are running Customer Interface - RACUST and there is an error message in the
INTERFACE_STATUS column, but you don't know what it means. Then here is the meaning for every error code.

INTERFACE_STATUS appears in the following tables:
RA_CUSTOMERS_INTERFACE_ALL
RA_CUSTOMER_PROFILES_INT_ALL
RA_CONTACT_PHONES_INT_ALL
RA_CUSTOMER_BANKS_INT_ALL
RA_CUST_PAY_METHOD_INTERFACE


These are the message codes and their meaning:
A1 --> The customer reference for update does not exist in RA_CUSTOMERS
A2 --> The address reference for update does not exist in RA_ADDRESSES
A3 --> Customer reference for insert is already defined in RA_CUSTOMERS
A4 --> Site use for this address reference already exists in the database
A5 --> Customer Number already assigned to a different customer
B1 --> ORIG_SYSTEM_ADDRESS_REF is mandatory when specifying an address
B2 --> ADDRESS1 is mandatory when specifying an address
B3 --> COUNTRY is mandatory when specifying an address
B4 --> SITE_USE_CODE is mandatory when inserting an address
B5 --> PRIMARY_SITE_USE_FLAG is mandatory when inserting an address
B6 --> CUSTOMER_CLASS_CODE is not defined in AR_LOOKUPS
B7 --> CUSTOMER_PROFILE_CLASS_NAME has an invalid value
B8 --> STATE is not defined in AR_LOCATION_VALUES
B9 --> COUNTRY is not defined in fnd_territories
B0 --> SITE_USE_CODE is not defined in AR_LOOKUPS
C1 --> This customer reference has two different customer names defined
C2 --> This customer reference has two different customer numbers defined
C3 --> This customer reference has two different parent customer references
C5 --> Customer reference has two different customer class codes defined
C6 --> This customer reference has two identical primary site uses defined
D1 --> Address reference has two different ADDRESS1 values
D2 --> Address reference has two different ADDRESS2 values
D3 --> Address reference has two different ADDRESS3 values
K1 --> Concurrent request failed
K3 --> This customer reference has two different customer types defined
L1 --> COLLECTOR_NAME is mandatory when no profile class specified
L2 --> TOLERANCE is mandatory when no profile class specified
L3 --> DISCOUNT_TERMS is mandatory when no profile class specified
L4 --> DUNNING_LETTERS is mandatory when no profile class specified
L5 --> INTEREST_CHARGES is mandatory when no profile class specified
L6 --> STATEMENTS is mandatory when no profile class specified
L7 --> CREDIT_BALANCE_STATEMENTS mandatory when no profile class specified
L9 --> DUNNING_LETTER_SET_NAME is mandatory when DUNNING_LETTERS is "Yes"
L0 --> CHARGE_ON_FINANCE_CHARGE_FLAG mandatory when INTEREST_CHARGES is "Yes"
M1 --> INTEREST_PERIOD_DAYS is mandatory when INTEREST_CHARGES is "Yes"
M3 --> COLLECTOR_NAME has an invalid value
M4 --> CREDIT_CHECKING has an invalid value
M5 --> TOLERANCE has an invalid value
M6 --> DISCOUNT_TERMS has an invalid value
M7 --> DUNNING_LETTERS has an invalid value
M8 --> INTEREST_CHARGES has an invalid value
M9 --> STATEMENTS has an invalid value
M0 --> CREDIT_BALANCE_STATEMENTS has an invalid value
N1 --> CREDIT_HOLD has an invalid value
N2 --> CREDIT_RATING has an invalid value
N3 --> RISK_CODE has an invalid value
N4 --> STANDARD_TERM_NAME which contains the payment terms has an invalid value
N5 --> OVERRIDE_TERMS has an invalid value
N6 --> DUNNING_LETTER_SET_NAME has an invalid value
N7 --> STATEMENT_CYCLE_NAME has an invalid value
N8 --> ACCOUNT_STATUS has an invalid value
N9 --> PERCENT_COLLECTABLE has an invalid value
N0 --> AUTOCASH_HIERARCHY_NAME which contains the AutoCash rule has an invalid value
O1 --> STATEMENT_CYCLE_NAME is mandatory when STATEMENTS is "Yes"
O2 --> LOCATION must be null when auto-numbering is set to "Yes"
O3 --> LOCATION is mandatory when auto-numbering is set to "No"
O4 --> CREDIT_CHECKING is mandatory when profile class is null
O5 --> CHARGE_ON_FINANCE_CHARGE_FLAG must be null if INTEREST_CHARGES is No
O6 --> INTEREST_PERIOD_DAYS must be null if INTEREST_CHARGES is "No"
O7 --> INTEREST_PERIOD_DAYS must be greater than zero
P1 --> Postal Code is not in the defined range of system options
Q1 --> A new location was created for a value in an address segment field
Q2 --> Validation failed for the key location flexfield structure
R1 --> CUST_SHIP_VIA_CODE is not defined in ORG_FREIGHT
R3 --> CUSTOMER_CATEGORY_CODE is not enabled in AR_LOOKUPS
R4 --> CUST_TAX_CODE is not defined in AR_VAT_TAX
R5 --> CUST_TAX_REFERENCE cannot be null when CUST_TAX_CODE is 'EXEMPT'
R6 --> SITE_USE_TAX_CODE is not defined in AR_VAT_TAX
R7 --> SITE_USE_TAX_REFERENCE is required when SITE_USE_TAX_CODE is 'EXEMPT'
R8 --> Invalid demand class code.
R9 --> SITE_SHIP_VIA_CODE not defined in ORG_FREIGHT
S1 --> The customer reference specified is invalid
S2 --> The address reference specified is invalid
S3 --> The address reference specified is not valid for this customer
S4 --> Payment Method is not defined in AR_RECEIPT_METHODS
S5 --> A bank account does not exist for the specified customer
S6 --> The end date specified cannot be before the start date
S7 --> The address specified must have an active BILL_TO site defined
T1 --> Customer payment method already active between the dates specified
T2 --> Customer site payment method already active between the dates specified
T3 --> Customer already has a primary payment method for specified dates
T4 --> Customer site has a primary payment method on the dates specified
T5 --> This customer payment method is already active in this date range
T6 --> Multiple primary payment methods defined
V2 --> The bank account specified must be of type 'EXTERNAL'
V3 --> Customer bank account is already active between the dates specified
V4 --> Customer site bank account already active between these dates
V5 --> This customer already has primary bank account for specified dates
V6 --> Customer site can have only 1 primary bank account for the dates specified
V7 --> Duplicate rows exist in Interface table for this Customer Bank and date run
V8 --> Duplicate primary customer banks defined within the interface table
W1 --> BANK_NAME is mandatory when creating a new bank account
W2 --> BANK_BRANCH_NAME is mandatory when creating a new bank account
W3 --> BANK_ACCOUNT_CURRENCY_CODE is mandatory creating a new bank account
W4 --> BANK_ACCOUNT_CURRENCY_CODE is not defined in FND_CURRENCIES
W5 --> Bank number already exists.
W6 --> Duplicate bank number in interface table.
W7 --> Primary flag should be 'Y' or 'N'.
W8 --> Duplicate bank and branch name in interface table.
W9 --> Duplicate Location
W0 --> Bank and branch name already exists.
X1 --> AUTO_REC_INCL_DISPUTED_FLAG mandatory when profile class is null
X2 --> TAX_PRINTING_OPTION is mandatory when no profile class specified
X3 --> GROUPING_RULE_NAME is mandatory when no profile class is specified
X4 --> CHARGE_ON_FINANCE_CHARGES_FLAG has an invalid value
X6 --> CURRENCY_CODE has an invalid value
X7 --> CREDIT_BALANCE_STATEMENTS is mandatory when STATEMENTS is "Yes"
X8 --> CREDIT_BALANCE_STATEMENTS must be "No" when STATEMENTS is "No"
X9 --> STATEMENT_CYCLE_NAME must be null when STATEMENTS is "No"
X0 --> OVERRIDE_TERMS is mandatory when no profile class is specified
Y1 --> PARTY_NUMBER must be null when auto-numbering is set
Y2 --> PARTY_NUMBER is mandatory when auto-numbering is set to "No"
Y3 --> Party Number already assigned to a different party.
Y4 --> This party reference has two different party numbers defined in RA_CUSTOMERS_INTERFACE.
Y5 --> PERSON_FLAG has an invalid value
Y6 --> Party Site Number already assigned to a different address
Y7 --> Address reference has two different party site numbers defined in RA_CUSTOMERS_INTERFACE.
Y8 --> PARTY_SITE_NUMBER must be null when auto-numbering is set
Y9 --> PARTY_SITE_NUMBER is mandatory when auto-numbering is set to "No"
Z1 --> CREDIT_BALANCE_STATEMENTS must be null when STATEMENTS is null
Z2 --> STATEMENT_CYCLE_NAME must be null when STATEMENTS is null
Z3 --> CHARGE_ON_FINANCE_CHARGE_FLAG must be null when INTEREST_CHARGES is null
Z4 --> INTEREST_PERIOD_DAYS must be null when INTEREST_CHARGES is null
Z5 --> DISCOUNT_GRACE_DAYS must be null when DISCOUNT_TERMS is null
Z6 --> DISCOUNT_GRACE_DAYS must positive
Z7 --> DISCOUNT_GRACE_DAYS must be null when DISCOUNT_TERMS is "No"
Z8 --> DUNNING_LETTER_SET_NAME must be null when DUNNING_LETTERS is "No"
Z9 --> DUNNING_LETTER_SET_NAME must be null when DUNNING_LETTERS is null
Z0 --> CURRENCY_CODE is mandatory when a profile amount value is populated
a1 --> Customer record for insert must have validated profile record defined
a2 --> TAX_PRINTING_OPTION has an invalid value
a3 --> The customer profile for this customer reference already exists
a4 --> The customer profile class for update does not exist
a7 --> Duplicate record within the interface table
a8 --> Conflicting profile classes specified for this customer/site
b1 --> Both TRX_CREDIT_LIMIT and OVERALL_CREDIT_LIMIT must be populated
b2 --> TRX_CREDIT_LIMIT may not be greater than the OVERALL_CREDIT_LIMIT
b3 --> DUNNING_LETTER_SET_NAME must have a unique value
b4 --> COLLECTOR_NAME must have a unique value
b5 --> STANDARD_TERM_NAME must have a unique value
b6 --> STATEMENT_CYCLE_NAME must have a unique value
b7 --> BANK_ACCOUNT_NUM is mandatory when creating a new bank account
b8 --> AUTO_REC_INCL_DISPUTE_FLAG has an invalid value
b9 --> PAYMENT_GRACE_DAYS must be a positive value
e2 --> Bill_to_orig_address_ref should only be defined for Ship-to Addresses
f1 --> You may have only one active Dunning site use for each customer
f2 --> For each customer, you may only have one active "Statements" type
f3 --> For each customer, you may only have one active Legal site
f4 --> Clearing Days must be greater than or equal to zero
f5 --> Address language is not installed
f6 --> Address reference has different languages
f7 --> Duplicate telephone reference in table RA_CONTACT_PHONES_INTERFACE
f8 --> A bank and branch with this bank number and branch number already exists
f9 --> Customer Prospect Code must be either CUSTOMER or PROSPECT
g1 --> This customer reference has two different customer prospect codes
u5 --> Contact reference has two different e-mail addresses
w2 --> CREDIT_CLASSIFICATION must have a valid value
y0 --> CONTACT_JOB_TITLE is not defined
y1 --> PHONE_COUNTRY_CODE is not defined in HZ_PHONE_COUNTRY_CODES
y2 --> This customer is already assigned to a different party
y3 --> This customer is already assigned to a different party
y4 --> LOCKBOX_MATCHING_OPTION must have a valid value
y6 --> TELEPHONE_TYPE cannot be updated from telex to any other type or any other type to telex.
y7 --> You cannot update this address. A printed, posted, or applied transaction with an associated tax line exists for this address

No comments:

Post a Comment