Unable to update Bill Plans via File Import (Doc ID 2208688.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Fusion Enterprise Contracts - Version 11.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.2.0.0 version, File Import/Export

When attempting to update the bill plans associated to a contract via FBDI
the following error occurs.

ERROR
-----------------------
The process fails to load data into import interface tables. Cause: java.lang.ArrayIndexOutOfBoundsException: 199. The data line #1 is mismatched at the mapping column #199. The data may not exist in that column.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Fill in the appropriate csv and zip them into one zip file
2. Perform the import
3. Import completes without errors but does show some warnings. Then when the UI is checked the Bill Plans were not updated.
4. Grab the Process log and find the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update Bill Plans via FBDI

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