Full Large SQL Query/Datamodel and Record Count for all cloud screens incl BIP for SOX Audit DRLs — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Full Large SQL Query/Datamodel and Record Count for all cloud screens incl BIP for SOX Audit DRLs

42
Views
2
Comments

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)

  1. Full custom SQL query used in the report
  2. Record count of the number of rows extracted and it matches with the output generated
  3. Output in xlsx considering the is close to million rows, the xls has the limitation.
  4. 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

  1. Enlarge and/or Full Screen of SQL Query screen formatted in SQL language.
  2. 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.
  3. Ability show row counts for the report output generated on the Screen (This was available in EBS)
  4. 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.

1
1 votes

Submitted · Last Updated

Comments