My Oracle Support Banner

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 DECEMBER 05, 2021

Applies to:

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


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

In BI Publisher, 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 and 12c versions of BI Publisher.


BIP is upgraded to


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.