Ability to Adhoc SQL using REF CURSOR based BIP Report not supported anymore

Ravi Patil-74669

Organization Name

National Oilwell Varco

Description

Our IT & HRIS Team is currently using a Tool to query Oracle HCM Cloud Database for information while debugging an Issue or providing adhoc data request from Management. Teams runs 10s of different SQL every day to perform their Job duties. This tool uses REF CURSOR based BIP Report which takes SQL as a parameter and returns results as XML which is parsed by the tool and presented to users as an excel format. User can view results from SQL for debugging an issue or easily export results to Excel if they are answering some one time data extract requests from Management.

We also have several inbound interfaces submitted from Middleware environment. Middleware team relies on REF CURSOR based BIP Report to run SQLs to fetch cloud data needed to prepare inbound Interface file.

REF CURSOR based BIP Report is no longer supported from 20B onwards. This would mean we will have to build individual BIP Report for each SQL executed from Middleware to prepare inbound Interface.

The biggest productivity loss is for IT & HRIS resources. They cannot run adhoc SQL from BIP Data model as it has 200 row limit and cannot export results to Excel if team is answering adhoc data request from Management. They would have to build a BIP report for each adhoc SQL to be executed which will lower IT & HRIS resource productivity by at least 50%.

If you are experiencing similar challenges and agree with the challenege, please vote for this Idea for a adhoc SQL query solution in BIP.

Use Case and Business Need

Needed to prepare inbound Integrations from Middleware Environment

A must have feature to help IT & HRIS resources query data easily to boost their Productivity,

Original Idea Number: 2c9d3f56e0