Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dynamic SQL support for Fusion Applications Update 20D

Received Response
32
Views
1
Comments
User769699-Oracle
User769699-Oracle Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

Dynamic SQL support for Fusion Applications Update 20D

Content

"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.

Version

20A

Code Snippet

Select * from HZ_PARTIES where PARTY_ID = :partyId
Tagged:

Answers

  • Raghavan p-Oracle
    Raghavan p-Oracle Rank 5 - Community Champion

    No, it's not about the parameter.

    Dynamic SQL is a programming technique that enables you to build SQL statements dynamically at runtime.

    If you are using any such in your custom reports you need to modify them with explicit SQL.