My Oracle Support Banner

Bug 33841635 Custom BI Function Stopped Working In 22A (Doc ID 2849225.1)

Last updated on JUNE 18, 2022

Applies to:

Oracle Supply Planning Cloud Service - Version 11.13.22.01.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.22.01.0 version, Technology Management - Reports/Analytics

Created a custom BI Data Model Function that use a cursor in oracle BI that has stopped working in 22A.

When Query has WITH clause function with in-line cursor fetch statements, the BI Data Model saves, but when clicking on the View button, it errors with:

ORA-00933: SQL command not properly ended

 


With Type of SQL : Non-Standard
the Data Model saves ok.
And, when clicking on the View button, with the mode Tree structure, no error occurs and the results show:

ROWSET
ROW
TEST (1)

 

However, when selecting the Table View, the following error occurs:

Table view output is not available for this type of data set

 

Changes

 Upgraded to 22A

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
Changes
Cause
Solution
References


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