Sunday, 3 March 2019

"Exception Name: java.lang.ArrayIndexOutOfBoundsException - 1" While uploading the GL Daily Rates Integrator

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