Fusion 23B : Analytics Publisher Throws "FAILED TO LOAD SQL" Error
(Doc ID 2949558.1)
Last updated on MAY 18, 2023
Applies to:
Oracle Fusion Inventory Management Cloud Service - Version 11.13.23.04.0 to 11.13.23.04.0 [Release 1.0]Oracle Fusion Global Human Resources Cloud Service - Version 11.13.23.04.0 to 11.13.23.04.0 [Release 1.0]
Oracle Fusion Financials Common Module Cloud Service - Version 11.13.23.04.0 to 11.13.23.04.0 [Release 1.0]
Oracle Fusion Self Service Procurement Cloud Service - Version 11.13.23.04.0 to 11.13.23.04.0 [Release 1.0]
Information in this document applies to any platform.
Symptoms
Analytics Publisher Data Model Throws "FAILED TO LOAD SQL" error when trying to create or edit a data set containing a backslash along with another character.
There are 2 use cases here
1) Editing an existing Data Model after receiving 23B update
Steps for Case 1
- Login to BI Catalog
- Edit an existing Data Model
- The error "FAILED TO LOAD SQL" is thrown
2) Creating a new Data Model after receiving the 23B update
Steps for Case 2
- Login to BI Catalog
- Create a Data Model
- Create a Data Set inside the Data Model
- Select "Type of SQL" as "Standard SQL" in the Data Set dialog box
- Write an SQL containing a backslash and another character
- Click OK
- The error "FAILED TO LOAD SQL" is thrown
Examples of SQL containing a backslash and another character that can trigger this error
Changes
Fusion Environment Upgraded to 23B
Cause
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
| Symptoms |
| Steps for Case 1 |
| Steps for Case 2 |
| Examples of SQL containing a backslash and another character that can trigger this error |
| Changes |
| Cause |
| Solution |
| Workaround |
| Example showing this workaround |
| References |