I was looking for a similar solution and came across this. Some options presented in this could help to some extent. https://community.oracle.com/mosc/discussion/3976271/system-last-query-option-in-oracle-erp-cloud Thanks, AJ

Thanks @Swapnil Kashid

There could be various causes behind such date transformations. Usually, all dates are stored at DB level in Coordinated Universal Time (UTC) and are presented to user based on their set timezone settings. We'd come across such situations and the workaround/fix was to format the date in such a way that you don't extract…

It could be that those users might be having different Regional settings than other users .. Can you confirm what are the timezone settings at bip level in BIP as well as in general preferences - BIP regional settings - Regional settings in General Preferences -

Thanks for the insights @Nathan CCC. This helps.

Reference: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=207176341197037&id=2041756.1

We got it working by doing something similar to this - SELECT "Workforce Goals - Goal Status Overview Real Time"."Department"."Department Name" s_1, "Workforce Goals - Goal Status Overview Real Time"."- Goal Management Process"."Count of Goals in Different Status within a Goal Plan" s_2 FROM "Workforce Goals - Goal Status…

Thanks for the details @Robert Fighiroae-Oracle

It was helpful. Thanks @Nathan CCC

This is really very helpful. Thanks for sharing @Rajeev Nayan

Thanks for the suggestion, @Srinivas Malyala-Oracle I will try something on the same lines if I can get it working. The problem is that we don't want to use username explicitly to check/restrict the data as it may not be possible based on username as many data sets are controlled via roles.

Thanks for the suggestion @User_ZTN0B

More information can be found here - Unable To See an Image in Online Preview In Bill Management (Doc ID 2687509.1)

We were able to get this working by changing report properties 'Make HTML output accessible' and 'Embed images and charts in HTML for offline viewing' to TRUE.

@Adil Muhammad Exactly. We also started seeing it on 18-Oct-2021. Btw it's resolved now for us and we didn't do any changes to fix it. You can check if its working for you as well. Thanks.

Hey @Aloka Bhattacharyya . We are facing the same issue. Could you please update if there's any solution to this ?

May I know where can I find VO mappings for 21D (likely in Excel formats as we used to have earlier) ?

Hey @Srinivas Pendyala-Oracle I mean when I click on this link and go to Review Data Lineage, it take me to this URL (https://community.oracle.com/customerconnect/discussion/40268/r13-financials-otbi-subject-area-to-database-lineage-mapping-spreadsheet) which doesn't contain 21D data mappings.

Thanks. I came across this one already but it seems to be for an older version. Any idea where I can find the latest one?

Good information @Pulkit Kumar Jain