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