Error Occurs When Importing A Table From An Excel Workbook (5.4 HF9)

(Doc ID 2380418.1)

Last updated on MARCH 30, 2018

Applies to:

Oracle Insurance Insbridge Rating and Underwriting - Version 5.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : Insbridge 5.4.0.0.0 version, RateManager

Error occurs when importing a table from an Excel Workbook (5.4 HF9)

We are currently testing the table import from an Excel Workbook. However, each time we tried to import an Excel file into a table, we got the following error : "Preview Creation failed. Please select a valid Excel (.xlsx) file.".

All tests in the Table Management Setup Diagnostics passed.


ERROR
-----------------------
Preview Creation failed. Please select a valid Excel (.xlsx) file




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Table edition tab -> Import Data -> MS Excel Workbook
2. Import Data File dialog -> Select the Excel file (a sample is joined to the SR)
3. Import Data File dialog -> Enter the Worksheet name, select Custom as the Excel format
4. Import Data File dialog -> Click Import button
The error appears.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use Table Import feature.

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