"Enter a value less than or equal to 8 characters for the account (CE-660079)."

Error:

error while uploading the bank account using spreadsheet.

"Enter a value less than or equal to 8 characters for the account (CE-660079)."

Solution:

Search with: Manage Cash Management Profile Options 

Please set country specified profile option at site level.

CE_DISABLE_BANK_VAL profile option to Yes at site or user level who trying to modify bank account.

You can provide at most one receivables account for a transaction (invoice, debit memo, or credit memo)

Issue:

You can provide at most one receivables account for a transaction (invoice, debit memo, or credit memo)

Solution:

This issue happen due to missing grouping Rules Setup - you expect the interface data to create multiple transactions but instead records are being grouped into one. Since there are multiple REC rows in the data this causes the error to be raised since a transaction can only have one REC row.

1. Verify the grouping rule associated to the Transaction Batch Source you are using

a. Search "Manage Transaction Sources" from Setup & Maintance Screen
Query for Batch Source Name = RA_INTERFACE_LINES_ALL.BATCH_SOURCE_NAME and check in AutoInvoice Options tab the value in Grouping Rule

2. Check your Grouping Rules setup

a. "Manage AutoInvoice Grouping Rules" from Setup & Maintance Screen

b. Ensure that you have defined a grouping rule setup for each type of transaction: Invoice, Credit Memo, Debit memo

Fusion Cloud customer upload error codes

Error Codes on Bank Interface Table (RA_CUSTOMER_BANKS_INT_ALL)

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
S7 - An active BILL_TO site must be defined for this customer and address
V2 - The bank account specified must be of type 'EXTERNAL'
W1 - BANK_NAME is mandatory when the bank account is not defined
W2 - BANK_BRANCH_NAME is mandatory when the bank account is not defined
W3 - BANK_ACCOUNT_CURRENCY_CODE is mandatory when account not defined
W4 - BANK_ACCOUNT_CURRENCY_CODE is not defined in FND_CURRENCIES
b7 - BANK_ACCOUNT_NUM is mandatory when the bank account is not defined
V3 - This customer bank is already active between the dates specified
V4 - Customer site bank account already active between these dates
V5 - This customer already has a primary bank account for the dates specified
V6 - Customer site has a primary bank account for the dates specified
V7 - Customer bank is already defined to be active for this date range
V8 - Duplicate primary customer banks defined within the interface table
W6 - Duplicate bank number in interface table
W5 - Bank number already existing.
f8 - Bank number and Branch number already exist.
W8 - Duplicate bank name & branch in interface table
W0 - Bank name & branch already existing
S6 - bank end date should be greater than start date
W7 - Bank primary flag specified is invalid .
B9 or w7 - territory code for bank is not defined in fnd_territories
w6 - bank home country is mandatory
Z1 - Bank Creation Failed
Z2 - Bank Branch or bank account creation failed.


Error Codes on Payment method Interface table (RA_CUST_PAY_METHOD_INT_ALL)


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
S7 - An active BILL_TO site must be defined for this customer and address
S4 - payment method name provided is not valid.
S6 - Start date should be less than end date.
T1 - Start date and end dates is invalid for the specified receipt method in account level.
W7 - primary_flag for the receipt method should be either Y/N or blank
T2 - Start date and end dates is invalid for the specified receipt method in site level.
T3 - Start date and end dates is invalid for the specified receipt method


Error Codes on Profiles interface table (RA_CUSTOMER_PROFILES_INT_ALL)

Z0 - if currency code is not specified, then interest rate ,maximum interest charge,minimum dunning amount,minimum dunning invoice amount, minimum fc balance amount,
minimum fc invoice amount, min statement amount,overall credit limit and transaction credit limit are not expected to be defined.

b1 - if transaction credit limit is a positive value , overall credit limit is Mandatory and should be greater than transaction credit limit
if transaction credit limit -1 or NULL , overall credit limit should be -1 or NULL.
b2 - transaction credit limit should be less than overall credit limit
K4 - late charge type specified is not valid
K5 - late charge calculation trx specified is not valid
K6 - When late charge calculation trx is specified to be AVG_DAILY_BALANCE, cons inv flag should be Y.
K7 - When late charge calculation trx is specified to be AVG_DAILY_BALANCE, Null is expected in late charge type,interest period days,interest calculation period,
hold charged invoices flag columns .
K8 - interest calculation period specified is not valid
K9 - multiple interest rates flag should be either Y/N or blank .
K10 - hold charged invoices flag should be either Y/N or blank .
K11 - late charge term id specified is not valid
K12 - late charge type cannot be ADJ when late charge term id is defined.
K13 - credit items flag should be either Y/N or blank .
K14 - disputed transactions flag should be either Y/N or blank .
K15 - exchange rate type specified is not valid
K16 - min fc invoice overdue type specified is not valid
K17 - min fc balance overdue type specified is not valid
K18 - Interest type specified is not valid
K19 - if interest type is FIXED_RATE then interest rate column is mandatory and interest fixed amount and interest schedule id should be null
if interest type is FIXED_AMOUNT then interest fixed amount column is mandatory and interest rate and interest schedule id should be null .
if interest type is CHARGES_SCHEDULE then interest schedule id is mandatory and interest fixed amount and interest rate should be null .
K20 - Penalty type specified is not valid
K21 - if penalty type is FIXED_RATE then penalty rate is mandatory and penalty fixed amount and penalty schedule id should be null .
if penalty type is FIXED_AMOUNT then penalty fixed amount is mandatory and penalty rate and penalty schedule id should be null .
if penalty type is CHARGES_SCHEDULE then penalty schedule id is mandatory and penalty fixed amount and penalty rate should be null .
K22 - interest fixed amount cannot be negative
K23 - penalty fixed amount cannot be negative
K24 - min interest charge cannot be negative
K26 - penalty rate specified cannot be less than 0 or greater than 100
K27 - min fc invoice percent specified cannot be less than 0 or greater than 100
K28 - min fc balance percent specified cannot be less than 0 or greater than 100
K29 - interest schedule id specified is invalid
K30 - penalty schedule id specified is invalid
K31 - match by autoupdate flag should be either Y/N or blank
K32 - preferred contact method specified is invalid
K33 - exception rule name specified is invalid
K34 - automatch rule name specified is invalid
K45 - CONS_BILL_LEVEL must be null when CONS_INV_FLAG is N or null.
w2 - credit classification value specified is not valid
a2 - tax printing option value specified is not valid
X6 - Currency Code specified is not valid
X5 - grouping rule name specified is not valid.
y5 - autocash hierarchy name adr specified is not valid.
N0 - autocash hierarchy name specified is not valid.
N9 - percent collectable cannot be less than 0 or greater than 100
N8 - account status specified is not valid
N7 or b6 - statement cycle name specified is not valid
b8 - auto rec incl disputed flag should be either Y/N or blank
N5 - override terms should be either Y/N or blank
b4 - payment grace days cannot be a negative value.
N4 or b5 - standard term name specified is not valid
y4 - lockbox matching option specified is not valid
N3 - risk code specified is not valid
N2 - credit rating specified is not valid
N1 - credit hold specified is not valid
X4 - charge on finance charge flag should be either Y/N or blank
Z6 - when discount terms is Y then discount grace days should be a positive number
Z7 - when discount terms is N then discount grace days can only be -1 or NULL
Z5 - when discount terms is NULL then discount grace days can only be -1 or NULL
M6 - discount terms should be either Y/N or blank
M5 - tolerance should be between -100 and +100
M4 - credit checking should be either Y/N or blank
b4 or M3 - collector name specified is not valid
B7 - You should provide a valid profile class name or atleast one seeded profile class should exist in the system
f4 - clearing days should be a positive value.
O7 - if interest charges is Y then a positive value for interest period days is expected.
L1 - Collector name cannot be null provided customer profile class name is not null
L2 - tolerance cannot be null provided customer profile class name is not null
L3 - discount terms cannot be null provided customer profile class name is not null
L4 - dunning letters cannot be null provided customer profile class name is not null
04 - credit checking cannot be null provided customer profile class name is not null
L5 - interest charges cannot be null provided customer profile class name is not null
L6 - statements cannot be null provided customer profile class name is not null
L7 - credit balance statements cannot be null provided customer profile class name is not null
X1 - auto rec incl disputed flag cannot be null provided customer profile class name is not null
X0 - override terms cannot be null provided customer profile class name is not null
M7 - dunning letters should be either Y/N or blank
L9 - When dunning letters are enabled , dunning letter set name Cannot be null
Z8 - When dunning letters are disabled , dunning letter set name is not supposed to have a value.
Z9 - dunning letter set name should be null when dunning_letters column is NULL.
M0 - credit balance statements should be either Y/N or blank
M8 - interest charges should be either Y/N or blank
M1 - interest period days is mandatory when interest charges is Y
O5 - charge on finance charge flag should be either N or NULL when interest charges is N
O6 - interest period days should be NULL when interest charges is N
Z3 - charge on finance charge flag Must be blank when interest charges is not specified
Z4 - interest period days Must be blank when interest charges is not specified
M9 - statements should be either Y/N or blank
O1 - statement cycle name Cannot be null when statements is Y
X7 - credit balance statements Cannot be null when statements is Y
X8 - credit balance statements should be N when statements is N
X9 - statement cycle name Should be Null when statements are specified to be N
Z1 - credit balance statements should be left blank when statements are not specified
Z2 - statement cycle name should be left blank when statements are not specified
J8 - insert Update flag should be either I or U
a4 - account/site profile exists cannot do the insert
a3 - account/site profile doesn't exist to update
S1 - invalid account/site specified for profile insert
a7 - two profiles cannot be of same currency code.
a8 - two profiles cannot be of same name.

Unable to see direct SQL option under subject area in fusion BI

Issue:

Unable to see fusion Direct SQL option under subject area in fusion BI after upgrade R11 to R12

Solution:

1. Login to Fusion Application and choose the "Security Console" option

2. Under the Roles Tab, click on Create Role button and fill out the form as seen in the screen shot

3. Click next till you get to the "Role Hierarchy" and then click on the Plus sign (+) to add the seeded BI Administrator Role

4. Search for the BI Administrator Role and then click on "Add Role Membership"

5. Click Next and then Submit the request

6. To assign the newly created "Custom BI Administrator Role" to a user, you need to query up the Role and click "Edit Role"

7. Click Next or jump to "Users" and then click on "Add User"

8. Search for the user and then click on "Add User to Role" button

9. Then click on Next and then "Save and Close"

10. Now run the "Retrieve Latest LDAP Changes" ESS Job.


The user should now have the BI Administrator Role. Please allow up to 20 minutes for the change to take effect.