OTBI in general only gives you the current row data unless it is based on Events like Assignment Event Real Time Subject Area. So this either has to be a Event type Subject Area or best is to have a Dedicated Table created and then individuals can build a BI report as per there needs and that is if a seeded report is not…

I know that for some big customers they do arrange a Read Only SQL utility (something which requires security authentication and GoldenGate setups....). Also, most probably Oracle Support team members has access to query directly.

Please check attached document.

There is an alternative if we build a Report from Analysis, then one can password protect PDF and EXCEL o/p. Kind Regards Ashish

It would be great to have this kind of info.

This would be very useful. Has been an ask for long time now. Kind Regards Ashish

Well one can always use the auto-generated template in that case and make changes. I mean , I can understand that one option could be that all columns of a data model is selected and then the report owner (developer / creator) can remove the ones not required, but sometimes the number of columns are so large that…

Not sure if this report (below) meets the requirement completely but maybe would give some insights. Have a look: https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/2336-bi-catalog-component-audit-report-a-custom-report-to-identify-bip-report-execution-details Kind Regards Ashish

Agreed! +1 Kind Regards Ashish

There used to be an option of auto-generate layout which would map all columns in same sequence automatically and if some one chooses excel as the default output then one will get report data in excel. However, in Release 12 i found that autogenerate option takes a lot of time and doesn't works sometimes Kind Regards…