Do you have any BLOB/CLOB or special chars in the dataset?

Thanks for sharing, Looking forward to it.

Nice one!

Looks really good!

Thanks for the clarification. OTBI dashboards embedded in Fusion cannot automatically receive parent-page URL parameters unless the embedding container passes them via ADF pageFlowScope. The Goals Center page does NOT expose a mechanism to map its URL parameters into OTBI prompt variables.

There is no simple answer for this functionality because Oracle BI Publisher (BIP) Excel Templates do support Excel’s native Expand/Collapse (Outline Grouping) and the functionality can be preserved in the generated report IF the grouping is done correctly in the .xlsx template before uploading it to BIP. Oracle BI…

Thanks, Rahul, for this information. Is it possible to share the official oracle documentation or blogs where above steps are documented? Appreciate your help!

See if above Subject Area can help. Thanks

You should be able to run User Data Reports that can provide Successful logins and Unsuccessful logins.

Fusion does NOT expose database tables for user login data. Fusion Cloud login timestamps are stored in the Identity Domain (IDCS/IAM) audit logs.

As per my understanding, Oracle Fusion HCM does not support passing URL parameters into the “Goals Center” page in order to dynamically filter or drive dashboard parameters. You can build a custom OTBI dashboard in: OTBI → My Folders / Shared Folders

Here are few examples for AP Invoices … KPI Description OTBI Subject Area Total Invoices Received (Today/Week/Month) Count by status Payables Invoices – Transactions Real Time Total Approved Invoices Approved + Validated Payables Invoices – Transactions Real Time Invoices on Hold Count and aged buckets Payables Invoice…

I think I have provided some comments in the other thread. Absolutely agree with above reply, it is best suited for the Data Integration Community.

Thanks for bringing it again, it is going to be fun challenge and learning experience.

I cannot recall, please check if there is an option to change the Data Type to Double.

Great, hope it serves this requirement. Keep us posted!

Thanks SteveF for looking into it, appreciate it!

You might want to try to add the dashboard/report URL manually in the Agent body if it allows editing the email body. You can insert a normal dashboard/report URL like: https://your-oas-server:port/analytics/saw.dll?Dashboard&path=/shared/Finance/Sales Hope it helps!

Hope we get some response from the Oracle SME, in the meantime you may want to open a ticket with Oracle Support.