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.

Thanks for the message, appreciate it!

@SharonAtGorilla , I am very glad to see your issue is resolved. As per community guidelines, appreciate if we can mark the Answer as Accepted Answer. It will help the community for future references. Thanks

Thank you!

Excellent stuff, good to know you have resolved it.

I think it is normal. Can you see if you can use /silent option from CLI option?

How about ROW_COUNT? Can you try this one … case when row_count("Financials - GL Balance Sheet"."Time"."Fiscal Year") > 1 

Thanks for the update, appreciate it.