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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

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!