My Oracle Support Banner

Getting Error of "Unable to Load XML Data" When Using Comma-Separated Values in Multi-Value Parameters Within Data Model (Doc ID 2435829.1)

Last updated on AUGUST 15, 2018

Applies to:

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


On : 12.2 version, Enterprise: User Interface

Using comma-separated values in the text input box for parameters in the text box of the data model.

It generates the following error:


Failed to Load XML

The issue can be reproduced at will with the following steps:

1. In a Data Model create an “optional” text input parameter which can accept comma-separated values.

2. Checked the “Text field contains comma-separated values” checkbox.

3. Navigate to “Data” tab to view sample data by entering comma-separated values in the text input box.


4.  When “View” button is clicked, displays an error message “Failed to load XML.”

5. Data is returned with one input value or with no input.

Note:  Using NVL function to return data if no value is entered for input parameter.


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.