Categories
Ability to Adhoc SQL using REF CURSOR based BIP Report not supported anymore
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
Comments
-
This will result in a huge loss of productivity if this feature is no longer supported.
Thanks!
0 -
If we do not have ability to run Adhoc SQL using REF CURSOR then it's a big loss to us.I know pain of a development team to run queries in BI Publisher. WE NEED THIS FEATURE BADLY.
0 -
Second that. This tool helps save time even when Oracle request us to run adhoc SQLs to debug issues reported in SR's as we dont have to create data models, reports etc to get the data into an excel.
0 -
This helps our developers to be able to test out their reporting data before releasing it back to the users. Also for use with ad hoc data requests from executive teams.
0 -
This tool is needed badly as it saves lot of time and helps in quick turnarounds. Besides the fact that it is required for inbound integrations from Middleware, the dev team is virtually handicapped without this tool as they rely on it during analysis and debugging.
0 -
HR Functional team cannot run adhoc sql queries for their business needs. Not every SQL has a built in report, functional teams runs several adhoc queries on a daily basis...It is very painful to run through BI Publisher as it is time consuming and not as easy to use as a SQL tool. We need this tool very badly to support our customer requests and deliver results in time.
0 -
This helped us to increase productivity since the workaround of using BI Reports are time-consuming. Desupporting this feature / tool will impact the Support time.
0 -
This is very useful tool to run adhoc sql queries and fetch data in a quick manner. It should not stop it.
0 -
Please continue to support this tool as it enables us to support our end users with providing adhoc data quicker. It also helps us with troubleshooting application issues.
Loosing this tool will be a major drawback.
0 -
A very helpful tool for us to support users. This tool should be kept on.
0