Can you please share the solution with community so that it will be helpful for anyone looking for a similar answer in future? Thanks.

Hi Jeff, Is this more related to querying the complete BPM information using OTBI or the changes that has happened (audit of changes)? Thanks.

Is this a question or an enhancement request? Thanks.

Hi Shravani, What I have observed is that not all the dates point to refresh/upgrade dates. Because sometimes it carries the date from the environment where the report was last saved. As normal user can't make any changes in seeded OTBI reports, so it is Oracle only. Thanks.

Even we have been asked recently to provide the audit information for successful delivery of email to each individual recipient. This is a much needed enhancement. Thanks.

Please check if you have the required duty assigned: Workforce Management - Sensitive Data Access Audit Real Time Also, check if you can see data in PER_SENSITIVE_DATA_AUDIT table from backend. Thanks.

Hi Ranjith, I wrote a query to extract these details. Please check the query on below link and you can use it accordingly as per your need: Thanks.

Can you please elaborate your query? Is it in Fusion Data intelligence or Fusion SaaS OTBI/BIP? Thanks.

If this request is for Fusion SaaS, then it is not possible. Thanks.

Upvoted. This will be helpful !!!

You can make use of RANK or RCOUNT function to pull only the latest record. Check below threads for samples: Duplicated records on OTBI Report linked to different assignments on Person data — Cloud Customer Connect How to get the latest record in OTBI — Cloud Customer Connect Thanks.

I don't think it is possible to upload .catalog files using web services. There is an idea submitted for a similar requirement, please evaluate and upvote: Upload BIP .catalog object via Web Services - Page 2 — Oracle Analytics Thanks.

These details are not stored anywhere in the database. Hence, not available in the subject areas. You need to write a custom BIP report to get these details. Thanks.

Can you give it a try to create under /custom folder instead of /myfolder? Thanks.

Hi Bhaskar, The note you shared is about creation of data set manually with a type of webservices. Not about creating the data set using webservices. Thanks.

Hi Sudhan, Did you try UpdateObject after creation of data model? I couldn't find any working example. Thanks.

Can you please confirm the steps that you have followed? Additionally, what the output format you are receiving on the SFTP? These details can help in finding the root cause. Thanks.

I think the only way is to get the required data using logical SQL. Thanks.

You can control this behavior at data set properties level. Click on Edit data model → choose properties and choose the case: Thanks.

Hi, Oracle provides a functionality where data can be loaded into multiple languages for most objects in HCM. This data is stored in _TL tables and can be reported using language attribute. For all languages enabled on customer environment, there will be a row in _TL table. If no translation is loaded, each row for a…