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 and later
Information in this document applies to any platform.


On : 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:

TEST (1)


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

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



 Upgraded to 22A


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.