Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Dynamic SQL support for Fusion Applications Update 20D — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Dynamic SQL support for Fusion Applications Update 20D

Received Response
edited May 22, 2020 12:21AM in Oracle Analytics 1 comment


Dynamic SQL support for Fusion Applications Update 20D


"IMPORTANT: Please share this notification with your Report Developers and System Administrators

In Fusion Applications Update 20D, BI Publisher data models will NO longer support dynamic SQL as a parameter value in a procedure call. This desupport WILL NOT affect existing BI Publisher data models that use explicit SQL statements in procedure calls or user-defined report filter parameters."

I have received the above statement from Oracle Cloud.

What does it mean? Does it include input parameter as well? For e.g. Select * from HZ_PARTIES where PARTY_ID = :partyId

Where partyid is the input parameter.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!