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.
Replace SQL procedures containing dynamic SQL query parameters with explicit SQL statements PRIOR to 20D.
- Review all custom BI Publisher data models that contain dynamic SQL procedure calls — interface programs, and query, reporting, or extract tools (including those provided by third parties)
- Create a new data model for each dynamic SQL -or- modify an existing data model using conditional queries to execute multiple SQL statements
- Please reference the BI Publisher Data Modeling guide (see Chapter 2.3.2: Creating Non-Standard SQL Data Sets) for more information.
If you have further questions, please contact Oracle Support.