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 126.96.36.199.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 188.8.131.52, 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 184.108.40.206 and 12c versions of BI Publisher.
BIP is upgraded to 220.127.116.11
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