Creating New Report Using Data From Excel Sheet Via Wizard Fails With Error 'Fails to save Data model' (Doc ID 2179135.1)

Last updated on OCTOBER 19, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.0 to 12.2 [Release 11.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When creating a New BIP Report and selecting Data from Excel spreadsheet, configuring an Excel spreadsheet as a Data Set Fails.

In BI Publisher 11.1.1.9, here are the steps that reproduces the issue.

1. Select the New > Report function 'Create Report' dialog box and the first function 'Select Data':
-- Upload, for example, the specialdiscount.xls file
-- the Sheet Name of SpecialDiscount is seen in the LOV

2. But then, in 'Guide Me' mode, the Next button is selected and then the error message returns: 'Failed to save draft data model'.

3. And in 'Use Report Editor' mode the Finish button is selected, a data model name entered, and then the Save button gives a slightly different error message returns: 'Failed to save data model'.

4. This function does work in both 11.1.1.7 and 12c versions of BI Publisher.

Changes

BIP is upgraded to 11.1.1.9

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