Excel to CI does not work when trying to load 2 or more External Accounts

Hi

We have a requirement to configure close to 4000 External Bank Accounts under 20 SETIDs (approx. 200 External Accounts under each SETID). Also, these accounts should support automatic bank statement reconciliation.

We tried using excel to CI for uploading these accounts. However, we are getting below error message while uploading the accounts:

PCPC:727 Statement:9
Called from:FUNCLIB_BANK.SQL_FUNCTION.FieldFormula Name:Bld_Bank_CFI_SQL Statement:98
Called from:BANK_ACCT_CHRT.BANK_ACCT_LED_TYPE.SavePreChange Statement:10
#2 - Error saving Component Interface. {MCA_BANK_EXTERNAL_CI} (91,37)
#3 - Error saving Component Interface. {MCA_BANK_EXTERNAL_CI}

As per Oracle, excel to CI will not work as BANK_EXTERNAL component contains Grid objects, such as BANK_ACCT_CHRT, BANK_ACCT_RECON. It will be suitable for online processing, not for batch processing as in the case of CIs and AE programs.