Loading Banks and Bank Accounts using ISetup is erroring out (Doc ID 1558545.1)

Last updated on JULY 05, 2013

Applies to:

Oracle Cash Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On EBS 12.1.3 version, iSetup Migrator

When attempting to load bank and bank accounts using iSetup, the following error occurs.

ERROR
-----------------------
AZR12LOADER module: iSetup R12 Loader

Feb 11, 2013 11:28:21 AM oracle.adf.share.config.ADFConfigFactory findOrCreateADFConfig
INFO: oracle.adf.share.config.ADFConfigFactory No META-INF/adf-config.xml found
[021113_112908475][][ERROR] Could not create an image. Set html-image-dir and html-image-base-uri correctly.
[021113_112911271][][ERROR] Could not create an image. Set html-image-dir and html-image-base-uri correctly.
[021113_112914699][][ERROR] Could not create an image. Set html-image-dir and html-image-base-uri correctly.


******************************************
Entity Name: Bank Accounts
Ignore Warnings and Continue: Yes
Update Existing Records: Yes
Time Taken(seconds): 22.0
Importing rows from xml file, and validating rows ......
The following exception has occured while processing:
Object Name : Branches PLSQLVO_Bank Accounts VO_Branch To Bank Acct VL_Bank Accounts
Record Identifiers : Bank Account Name = 'HSBC Bank'
 Branch Name = 'HSBC Bank'
 Bank Account Id = 'null'
Exception : OAAttrValBundledException
 Message not found. Application: CE, Message Name: AR_API_INVALID_DELIMITER. Tokens: REASON = SourceDelimiter null is not valid;
 Message not found. Application: CE, Message Name: AR_API_INVALID_COA. Tokens: REASON = ChartOfAccountsId -99 is not valid;
 Message not found. Application: CE, Message Name: AR_API_INVALID_DELIMITER. Tokens: REASON = Delimiter null is not valid;
 One or more validations have failed.
 ( Reason: AssetCodeCombinationName = null is null )
 Proceeding to the next record.
 OAAttrValBundledException
  Message not found. Application: CE, Message Name: AR_API_INVALID_DELIMITER. Tokens: REASON = SourceDelimiter null is not valid;

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to iSetup> Migrations> Selection Sets
2. Select "Financial Setups" and Click--> Continue
3. Select "Bank Accounts" from the section "Cash Management" and Click on filters
4. Put the filter as "%"
5. Extracted the Details from Source and Load to Target


BUSINESS IMPACT
-----------------------
Due to this issue, users cannot migrate the information to another instance.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms