Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Full Large SQL Query/Datamodel and Record Count for all cloud screens incl BIP for SOX Audit DRLs

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Airbnb
Description (Required): Oracle BI Reporting Tools - SQL Query screen needs enlarged/Full Screen
In all the SOX audit reports and Internal Audit and Security review they will need the following to be added in each DRL (Audit Document Request List)
- Full custom SQL query used in the report
- Record count of the number of rows extracted and it matches with the output generated
- Output in xlsx considering the is close to million rows, the xls has the limitation.
- Screens of the Parameters used to generate the report
Use Case and Business Need (Required):
The SQL Query /Data model Screen is too small and we have to take ten's off-screen shots for showing
the full query used in the report generation process for SOX audit purpose.
Oracle Cloud Screens including BIP reports need to show number of records queried/extracted.
Formatted in SQL language along with line numbers
Requirements
- Enlarge and/or Full Screen of SQL Query screen formatted in SQL language.
- Ability to show the SQL line numbers along with the SQL query line number which is having syntax errors so we can show the number lines the SQL is coded.
- Ability show row counts for the report output generated on the Screen (This was available in EBS)
- Generate output in xlsx instead of xls so the data is fully extracted for the query used.
Enhancement Request / Service Request:
New Request, created because of limitations which every Oracle cloud customer is facing, this is more of compliance and SOX requirement in adding to giving some more visibility to the developer to help in their day to day job for better performance. Especially the SQL query screen which was designed with old technology, the new technology like Visual builder cloud has far more features in designing and developing the screens.
Comments
-
This is logged by Airbnb IT team no consulting partner involved.
0 -
Definitely will be very helpful. I would like to see this implemented.
0