Creating New Report Using Data From Excel Sheet Via Wizard Fails With Error 'Fails to save Data model'
Last updated on OCTOBER 19, 2016
Applies to:BI Publisher (formerly XML Publisher) - Version 220.127.116.11.0 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 18.104.22.168, 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 22.214.171.124 and 12c versions of BI Publisher.
BIP is upgraded to 126.96.36.199
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