This is a known issue since 23D with Firefox. Oracle has not released a fix for it. You can download outputs without any issue with Chrome/Edge. Solutions in the doc id # Unable to download scheduled report output from the Report Job History page using FireFox (Doc ID 2996480.1) are given below. Alternate solution 1 Use…

Hi @chpriyanka , You may try adding a condition in the start of the line to check if all elements are not null and then print the tags. I have not checked but this comes to mind. Thanks, Abhilash

Hi Aaron, I think you should try using BICC for this. It helps extract good amount of raw data from tables. Thanks, Abhilash

Hi @Chainsyssupport , See if this helps. SELECT NVL (COUNT (DISTINCT fs.user_name), 0) cnt FROM fnd_sessions fs, per_users pu WHERE 1 = 1 AND fs.user_guid = pu.user_guid AND TO_CHAR ( FROM_TZ (TO_TIMESTAMP (fs.last_connect), DBTIMEZONE) AT TIME ZONE 'America/New_York', 'yyyy-MM-dd') >= '2020-02-28'; Warm regards, @Abhilash…

Check if Gaurav's response helps you. It is an add-on for us at the time. Its shows both BI and OTBI as far as I recall. Take a look at this Main Document : https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/view-audit-data-publisher-catalog-objects.html#GUID-6E05FC42-D2CF-4658-B9A1-595968CC8FA6 Download Sample…

Hi @Alejandro Castillo Angeles , This screen info is based on audit policies defined in Setup and Maintenance. If the audit is configured for products then you can find the information in the audit tables for the base tables. For example. for Product "Assets", it will be fa_additions_b as base table and fa_additions_b_ is…

Any luck with permanent fix?

Hi @Pradnya_Pampatwar , You can try creating this using a pivot table in RTF. Thanks, Abhilash

Check if the template name, locale and output format is correct in Bursting query. Also the parameter6 should be true. Please review and post results. Thanks Abhilash

https://docs.oracle.com/en/cloud/saas/financials/23b/oedmf/glfrcreportsb-7712.html#glfrcreportsb-7712

Hi @Sohel.IN-Oracle - You will be able to find the information using below tables. gl_frc_reports_b gl_frc_reports_tl Thanks, Abhilash

You can try may be the timezone conversion also as BI server by default uses UTC timezone. We can use like SELECT TO_CHAR ( FROM_TZ ( TO_TIMESTAMP (NVL ( :p_run_date, SYSDATE)), DBTIMEZONE) AT TIME ZONE 'America/Los_Angeles', 'yyyy-MM-dd') to get PST time for example. Below is one of sample email bursting query for any…

I think you directly use the tag in the RTF/XLS.

It appears you are using an xpt template for this. I am not so used to it for such requirements. Maybe try using an rtf template and use the <?call template?> feature in the header section in the rtf. Let know if it helps. Sample link for reference found in internet -…

Hi @Paul Hassall , Is the issue of urarchive happening also in non-prods post upgrade?

Hi @Paul Hassall , In our environment, we replaced the view with base table and report which was faulty was back working again. But we wanted to know the root cause of what changed in 23D which was not in documentation.

Hi @User_J3N5J This is mostly in bipublisher_v. Log in to BI Publisher with administrator privileges and click the Administration link. Under Data Sources, click JNDI Connection, then click Add Data Source. Enter the Data Source Name and JNDI Name jdbc/AuditViewDataSource. Click Test Connection to ensure that the data…

@Mallikarjuna Kuppauru-Oracle and @Paul Hassall - Is there a fix identified for this issue? We are replacing queries one after other for impacted reports and wanted to check if there are any alternative fixes.

@Paul Hassall - Did it work for you after the SR? We are also facing weird errors.

Sample table is for example : fa_additions_b , the audit table is fa_additions_b_