It is good idea but I don't think it is posted in correct place. This is for Ideas related to cloud products. 

Good Idea

Yes, it is useful to analyze OTBI outputs, failures etc. 

Hi Don, Currently there is no option available for this in Fusion SaaS cloud. You can get seeded report information in following path. Go to cloud documentation -> Analyze and Report -> Review Prebuilt Analytics and Reports -> select the report links. For custom reports currently there is no option as the Catalog Manager…

Output image

RTF template. 

Hi Nalinee, The previous template that I attached already showing data as per your expected data. Made formatting changes also and attached a new template. You can open the template in word, load XML and preview to test the data. Thanks, Anil

Hi Prudence, Yes, the process is correct. Regards, Anil

Hi Prudence, You can create sample data model using 'AuditViewDB' data source with following query, but the other objects (apart from the view used in the audit data models) from the data source not useful for you. You can create data set with other data sources and join the data set with these audit view data sets. Query:…

HI Nalinee, Please share prototype of your expected output. Thanks, Anil

Sample Template

Hi Nalinee, You are trying to convert table to Pivot. You can directly create Pivot table in RTF template. Use following steps: Word -> Add ins -> BI publisher -> Upload XML to RTF -> Insert -> Pivot table -> Pull rows, columns and measures. You can select totals if required. Once the Pivot is generated you can change the…

Hi Ian, Currently that functionality is not available to store the details of email sent in database using a DFF/EFF. You can log an Enhancement request. As a work around use a hardcoded CC or BCC emails in the bursting query so that you can monitor those emails. That hard coded BCC, CC email will also receive every…

Hi Amitabha, You can get the ESS requestid from below two tables. FUSION.ESS_REQUEST_HISTORY FUSION.ESS_REQUEST_PROPERTY To get the job id based on their status then use STATE column. For Example STATE=3 for running jobs. Sample query: SELECT requestid FROM (SELECT rq1.requestid FROM FUSION_ORA_ESS.REQUEST_HISTORY rq,…

Check the fonts in BI publisher Administration -> Font mappings. If the expected font is not available then you have to upload the font. Also make sure you use the same font in Template, Report properties.

Hi Krishna, XDO_LOBS - FILE_DATA table doesn't exist in Fusion and similar tables also not available in Fusion. Currently it is not possible to identify the templates/reports with Oracle logos. All the notification reports have Oracle Logos. You can find all seeded report list here.…

Please share the screen shots of data filters from RPD and sample nqquery log. We can see how the filters applied in nqquery log.