Symptoms:
When trying to upload GL Daily Rates Integrator, the following error occurs.
Error:
Exception Name: java.lang.ArrayIndexOutOfBoundsException - 1
Log File Bookmark: 786581
Steps:
1. Login the application.
2. Navigate to R) General Ledger Superuser > Setup > Currencies > Currency Rates Manager >Daily Rates.
3. Click on Create in Spreadsheet button.
Cause:
Excel 2003 is not available in WEB ADI viewer LOV.
Solution:
1. Login the application.
2. Navigate to R) System Administrator > Application > Function
3. Search the function with "GL_CRM_DR_WEBADI_CREATE" (Daily Rates Web-ADI Spreadsheet).
4. Go to Web HTML tab and change the viewer value from EXCEL2003 to EXCEL2007.
5. Save the function and re-test the issue.
Previous HTML Call Value:
BneApplicationService?bne:page=BneCreateDoc&bne:reporting=N&bne:integrator=SQLGL:GL_DAILY_RATES&bne:layout=SQLGL:GL_DAILY_RATES_ORIGINAL&bne:content=GL_DR_NONE&bne:viewer=EXCEL2003&bne:noreview=anything
Changed HTML Call Value:
BneApplicationService?bne:page=BneCreateDoc&bne:reporting=N&bne:integrator=SQLGL:GL_DAILY_RATES&bne:layout=SQLGL:GL_DAILY_RATES_ORIGINAL&bne:content=GL_DR_NONE&bne:viewer=EXCEL2007&bne:noreview=anything
When trying to upload GL Daily Rates Integrator, the following error occurs.
Error:
Exception Name: java.lang.ArrayIndexOutOfBoundsException - 1
Log File Bookmark: 786581
Steps:
1. Login the application.
2. Navigate to R) General Ledger Superuser > Setup > Currencies > Currency Rates Manager >Daily Rates.
3. Click on Create in Spreadsheet button.
Cause:
Excel 2003 is not available in WEB ADI viewer LOV.
Solution:
1. Login the application.
2. Navigate to R) System Administrator > Application > Function
3. Search the function with "GL_CRM_DR_WEBADI_CREATE" (Daily Rates Web-ADI Spreadsheet).
4. Go to Web HTML tab and change the viewer value from EXCEL2003 to EXCEL2007.
5. Save the function and re-test the issue.
Previous HTML Call Value:
BneApplicationService?bne:page=BneCreateDoc&bne:reporting=N&bne:integrator=SQLGL:GL_DAILY_RATES&bne:layout=SQLGL:GL_DAILY_RATES_ORIGINAL&bne:content=GL_DR_NONE&bne:viewer=EXCEL2003&bne:noreview=anything
Changed HTML Call Value:
BneApplicationService?bne:page=BneCreateDoc&bne:reporting=N&bne:integrator=SQLGL:GL_DAILY_RATES&bne:layout=SQLGL:GL_DAILY_RATES_ORIGINAL&bne:content=GL_DR_NONE&bne:viewer=EXCEL2007&bne:noreview=anything