Applications

Expand all | Collapse all

Cloud ERP BI Reports: Dynamic SQL functionality deprication in 20D

  • 1.  Cloud ERP BI Reports: Dynamic SQL functionality deprication in 20D

    OATUG Star Partner
    Posted 07-02-2020 18:43
    Hi Folks

    Just a heads up that if you make use of dynamic SQL vi a BI Report with ERP cloud then it looks like it will be deprecated in 20D.

    "If you currently have custom BI Publisher reports that pass dynamic SQL statements in a BI Publisher data model in production, you must replace SQL procedures containing dynamic SQL query parameters with explicit SQL statements PRIOR to 20D."

    Normally this isn't something I'd post about, however this is a loss of functionality without a viable alternative.  You can still use IF statements in BI reports to provide some flexibility but it doesn't address the core requirement on being able to run SQL on the fly.

    If this is something that affects you or your customers please add your voice to the following Post on the Oracle Ideas Lab to help Oracle understand the importance of this feature.

    https://cloudcustomerconnect.oracle.com/posts/2c9d3f56e0?

    Regards,

    David

    ------------------------------
    David Wright
    Founder and Product Champion
    More4apps
    Hamilton
    (642) 749-94941
    ------------------------------


  • 2.  RE: Cloud ERP BI Reports: Dynamic SQL functionality deprication in 20D

    Oracle Ace
    Posted 08-03-2020 12:18
    Thank you. I appreciate sharing with the group. May be it is a good idea to keep in mind while developing XML Publisher Reports in Oracle EBS R12.2 as well.

    ------------------------------
    Venkanna Mittakanti
    Lead Oracle Apps Analyst
    Siemens Corporation - GSSNA
    Houston TX
    (408) 2035083
    ------------------------------