HZ tables Tables and Their Joins in Oracle Fusion Cloud -
Tuesday, 14 April 2020
Oracle Fusion Cloud - Customer Interface Status Error Codes
CUSTOMER INTERFACE STATUS ERROR CODES
Problem Description
-------------------
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.
Solution Description
--------------------
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
D4 --> Address reference has two different ADDRESS4 values
D5 --> Address reference has two different cities
D6 --> Address reference has two different postal codes
D7 --> Address reference has two different states
D8 --> Address reference has two different provinces
D9 --> Address reference has two different counties
D0 --> Address reference has two different countries
E1 --> Address reference has two identical site use codes
E2 --> Address reference has two different customers
F1 --> ORIG_SYSTEM_TELEPHONE_REF mandatory for telephone information
F2 --> TELEPHONE is mandatory when specifying telephone information
F3 --> TELEPHONE_TYPE is mandatory when specifying telephone information
F4 --> TELEPHONE_TYPE is not defined in AR_LOOKUPS
F5 --> Telephone reference for insert is already defined in RA_PHONES
F6 --> Telephone reference for update does not exist in RA_PHONES
G1 --> ORIG_SYSTEM_CONTACT_REF mandatory for contact information
G2 --> LAST_NAME is mandatory when specifying a contact
G3 --> CONTACT_TITLE is not defined in AR_LOOKUPS
G4 --> Contact reference for insert is already defined in RA_CONTACTS
G5 --> Contact reference for update is not defined in RA_CONTACTS
G6 --> The address reference specified is not defined for this customer
G7 --> CONTACT_JOB_TITLE must be defined in AR_LOOKUPS
H1 --> Contact reference has two different first names
H2 --> Contact reference has two different last names
H3 --> Contact reference has two different titles
H4 --> Contact reference has two different job titles
H5 --> Contact reference has two different customers
H6 --> Contact reference has two different addresses
I1 --> Telephone reference has two different phone numbers
I2 --> Telephone reference has multiple extensions
I3 --> Telephone reference has two different types
I4 --> Telephone reference has two different area codes
I6 --> Telephone reference has two different customers
I7 --> Telephone reference has two different addresses
J1 --> SITE_USE_CODE is not updateable
J2 --> PRIMARY_SITE_USE_FLAG is not updateable
J3 --> LOCATION is not updateable
J4 --> CUSTOMER_TYPE is not defined in AR_LOOKUPS
J5 --> PRIMARY_SITE_USE_FLAG has an invalid value
J6 --> CUSTOMER_NUMBER must be null when auto-numbering is set to "Yes"
J7 --> CUSTOMER_NUMBER is mandatory when auto-numbering is set to "No"
J8 --> INSERT_UPDATE_FLAG has an invalid value
J9 --> CUSTOMER_STATUS must have a value of 'A' or 'I'
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
R2 --> CUSTOMER_CATEGORY_CODE is not defined in AR_LOOKUPS
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
X5 --> GROUPING_RULE_NAME 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
e3 --> Bill_to_orig_address_ref is not a valid bill-to address
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
w3 --> You cannot update the PARTY_TYPE using Customer Interface.
Please do not specify a value for PARTY_TYPE when the
INSERT_UPDATE_FLAG is set to U.
w4 --> When you create a PERSON party_type, you must provide
PERSON_FIRST_NAME or PERSON_LAST_NAME.
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
y8 --> ADDRESS_CATEGORY_CODE does not exist. Please enter a valid adress
category code or define a new one using the Receivables Lookups
window.
y9 --> ADDRESS_CATEGORY_CODE is not enabled. Please enable this address
category by updating the Enabled flag in the Receivables Lookups
window.
Problem Description
-------------------
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.
Solution Description
--------------------
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
D4 --> Address reference has two different ADDRESS4 values
D5 --> Address reference has two different cities
D6 --> Address reference has two different postal codes
D7 --> Address reference has two different states
D8 --> Address reference has two different provinces
D9 --> Address reference has two different counties
D0 --> Address reference has two different countries
E1 --> Address reference has two identical site use codes
E2 --> Address reference has two different customers
F1 --> ORIG_SYSTEM_TELEPHONE_REF mandatory for telephone information
F2 --> TELEPHONE is mandatory when specifying telephone information
F3 --> TELEPHONE_TYPE is mandatory when specifying telephone information
F4 --> TELEPHONE_TYPE is not defined in AR_LOOKUPS
F5 --> Telephone reference for insert is already defined in RA_PHONES
F6 --> Telephone reference for update does not exist in RA_PHONES
G1 --> ORIG_SYSTEM_CONTACT_REF mandatory for contact information
G2 --> LAST_NAME is mandatory when specifying a contact
G3 --> CONTACT_TITLE is not defined in AR_LOOKUPS
G4 --> Contact reference for insert is already defined in RA_CONTACTS
G5 --> Contact reference for update is not defined in RA_CONTACTS
G6 --> The address reference specified is not defined for this customer
G7 --> CONTACT_JOB_TITLE must be defined in AR_LOOKUPS
H1 --> Contact reference has two different first names
H2 --> Contact reference has two different last names
H3 --> Contact reference has two different titles
H4 --> Contact reference has two different job titles
H5 --> Contact reference has two different customers
H6 --> Contact reference has two different addresses
I1 --> Telephone reference has two different phone numbers
I2 --> Telephone reference has multiple extensions
I3 --> Telephone reference has two different types
I4 --> Telephone reference has two different area codes
I6 --> Telephone reference has two different customers
I7 --> Telephone reference has two different addresses
J1 --> SITE_USE_CODE is not updateable
J2 --> PRIMARY_SITE_USE_FLAG is not updateable
J3 --> LOCATION is not updateable
J4 --> CUSTOMER_TYPE is not defined in AR_LOOKUPS
J5 --> PRIMARY_SITE_USE_FLAG has an invalid value
J6 --> CUSTOMER_NUMBER must be null when auto-numbering is set to "Yes"
J7 --> CUSTOMER_NUMBER is mandatory when auto-numbering is set to "No"
J8 --> INSERT_UPDATE_FLAG has an invalid value
J9 --> CUSTOMER_STATUS must have a value of 'A' or 'I'
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
R2 --> CUSTOMER_CATEGORY_CODE is not defined in AR_LOOKUPS
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
X5 --> GROUPING_RULE_NAME 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
e3 --> Bill_to_orig_address_ref is not a valid bill-to address
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
w3 --> You cannot update the PARTY_TYPE using Customer Interface.
Please do not specify a value for PARTY_TYPE when the
INSERT_UPDATE_FLAG is set to U.
w4 --> When you create a PERSON party_type, you must provide
PERSON_FIRST_NAME or PERSON_LAST_NAME.
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
y8 --> ADDRESS_CATEGORY_CODE does not exist. Please enter a valid adress
category code or define a new one using the Receivables Lookups
window.
y9 --> ADDRESS_CATEGORY_CODE is not enabled. Please enable this address
category by updating the Enabled flag in the Receivables Lookups
window.
Thursday, 9 April 2020
Query to list All User Roles in Oracle ERP Cloud Fusion
SELECT *
FROM
(SELECT user_info.user_login,
user_info.user_id,
user_roles.role_name,
user_info.creation_date,
user_info.first_name,
user_info.last_name,
user_info.location_code,
user_info.location_name,
user_info.town,
user_info.country,
user_info.department,
user_info.username,
user_info.active_flag
FROM
(SELECT DISTINCT pp.creation_date creation_date,
ppf.first_name first_name,
ppf.last_name last_name,
hl.location_code location_code,
hl.location_name location_name,
hl.town_or_city town,
hl.country country,
pd.name department,
pu.username username,
pu.active_flag active_flag,
au.user_id user_id,
au.user_login user_login
FROM per_persons pp,
per_all_people_f papf,
per_person_names_f_v ppf,
hr_locations_all_f_vl hl,
per_departments pd,
per_all_assignments_m paaf,
per_users pu,
ase_user_vl au
WHERE au.user_guid = pu.user_guid(+)
AND pu.person_id = papf.person_id(+)
AND papf.person_id = pp.person_id(+)
AND pp.person_id = ppf.person_id(+)
AND ppf.person_id = paaf.person_id(+)
AND paaf.location_id = hl.location_id(+)
AND paaf.organization_id = pd.organization_id(+)
AND TRUNC(sysdate) BETWEEN NVL(ppf.effective_start_date,TRUNC(sysdate)) AND NVL(ppf.effective_end_date,TRUNC(sysdate))
AND TRUNC(sysdate) BETWEEN NVL(papf.effective_start_date,TRUNC(sysdate)) AND NVL(papf.effective_end_date,TRUNC(sysdate))
AND TRUNC(sysdate) BETWEEN NVL(paaf.effective_start_date,TRUNC(sysdate)) AND NVL(paaf.effective_end_date,TRUNC(sysdate))
AND TRUNC(sysdate) BETWEEN NVL(hl.effective_start_date,TRUNC(sysdate)) AND NVL(hl.effective_end_date,TRUNC(sysdate))
AND TRUNC(sysdate) BETWEEN NVL(pd.effective_start_date,TRUNC(sysdate)) AND NVL(pd.effective_end_date,TRUNC(sysdate))
AND TRUNC(sysdate) BETWEEN NVL(au.effective_start_date,TRUNC(sysdate)) AND NVL(au.effective_end_date,TRUNC(sysdate))
)user_info
LEFT JOIN
(SELECT u.user_login user_login,
r.role_name role_name,
r.description description ,
aurm.user_id user_id
FROM ase_user_vl u,
ase_role_vl r,
ase_user_role_mbr aurm
WHERE r.role_id = aurm.role_id
AND aurm.user_id =u.user_id
AND r.effective_end_date IS NULL
AND aurm.effective_end_date IS NULL
)user_roles
ON user_info.user_login=user_roles.user_login
) qrslt
WHERE 1 = 1
AND UPPER(QRSLT.username) = UPPER('abcd@oracletechcenter.blogspot.com')
ORDER BY user_login
FROM
(SELECT user_info.user_login,
user_info.user_id,
user_roles.role_name,
user_info.creation_date,
user_info.first_name,
user_info.last_name,
user_info.location_code,
user_info.location_name,
user_info.town,
user_info.country,
user_info.department,
user_info.username,
user_info.active_flag
FROM
(SELECT DISTINCT pp.creation_date creation_date,
ppf.first_name first_name,
ppf.last_name last_name,
hl.location_code location_code,
hl.location_name location_name,
hl.town_or_city town,
hl.country country,
pd.name department,
pu.username username,
pu.active_flag active_flag,
au.user_id user_id,
au.user_login user_login
FROM per_persons pp,
per_all_people_f papf,
per_person_names_f_v ppf,
hr_locations_all_f_vl hl,
per_departments pd,
per_all_assignments_m paaf,
per_users pu,
ase_user_vl au
WHERE au.user_guid = pu.user_guid(+)
AND pu.person_id = papf.person_id(+)
AND papf.person_id = pp.person_id(+)
AND pp.person_id = ppf.person_id(+)
AND ppf.person_id = paaf.person_id(+)
AND paaf.location_id = hl.location_id(+)
AND paaf.organization_id = pd.organization_id(+)
AND TRUNC(sysdate) BETWEEN NVL(ppf.effective_start_date,TRUNC(sysdate)) AND NVL(ppf.effective_end_date,TRUNC(sysdate))
AND TRUNC(sysdate) BETWEEN NVL(papf.effective_start_date,TRUNC(sysdate)) AND NVL(papf.effective_end_date,TRUNC(sysdate))
AND TRUNC(sysdate) BETWEEN NVL(paaf.effective_start_date,TRUNC(sysdate)) AND NVL(paaf.effective_end_date,TRUNC(sysdate))
AND TRUNC(sysdate) BETWEEN NVL(hl.effective_start_date,TRUNC(sysdate)) AND NVL(hl.effective_end_date,TRUNC(sysdate))
AND TRUNC(sysdate) BETWEEN NVL(pd.effective_start_date,TRUNC(sysdate)) AND NVL(pd.effective_end_date,TRUNC(sysdate))
AND TRUNC(sysdate) BETWEEN NVL(au.effective_start_date,TRUNC(sysdate)) AND NVL(au.effective_end_date,TRUNC(sysdate))
)user_info
LEFT JOIN
(SELECT u.user_login user_login,
r.role_name role_name,
r.description description ,
aurm.user_id user_id
FROM ase_user_vl u,
ase_role_vl r,
ase_user_role_mbr aurm
WHERE r.role_id = aurm.role_id
AND aurm.user_id =u.user_id
AND r.effective_end_date IS NULL
AND aurm.effective_end_date IS NULL
)user_roles
ON user_info.user_login=user_roles.user_login
) qrslt
WHERE 1 = 1
AND UPPER(QRSLT.username) = UPPER('abcd@oracletechcenter.blogspot.com')
ORDER BY user_login
Subscribe to:
Posts (Atom)