You will need to compare data with main table and write your logic to extract what you are looking for using AUDIT_ACTION_TYPE_. The audit table doesn't capture what is shown directly on UI. Thanks.

Have you verified all the selected columns. filters etc? Some of the columns may be set to hidden at analysis level. Thanks.

These error mainly arise from missing DFF configuration in target environment when DFF attributes are used in your dashboard. Can you please verify if all DFF's used in dashboard are correctly configured in Target environment? Fusion OTBI: OTBI analysis failed with 'ADFService11G - JBO-25002: Definition dummy_view_link '…

Can you check if there are any surveys marked with internal survey flag as YES, have been responded? Can you try creating a sample test case and then recheck? Also, can you recheck if you select No as a value of Internal Survey Flag, you get some data? Thanks.

Isn't this for HCM FDI? Thanks.

Can you share what is the expected output in excel format? Thanks.

Hi, You will not be able to do a direct join in Fusion SaaS data model with ATP DBs. Either you bring in the data to Fusion first in to create a report or you need to take data out of fusion into ATP and create a report there. Thanks.

Hi, Thanks for the notes. However, in Fusion SaaS, I don;t see the option to run "Purge scheduler metadata" on demand. Thanks.

This looks great. And good to see the distribution of users across globe :) Waiting for the dashboard now !!

Apologies, missed this point. Can you try using @inlines after if statement. Check sample on below MOS: How To Prevent New Paragraph (Carriage Return) In BI Publisher RTF Template (Doc ID 2191520.1) Thanks.

Can you try with if else or choose statments? Thanks.

Can you put this whole thing in one tag instead of breaking it, something like below? And when you click it, it should have everything inside it. Thanks.

Can you try adjusting all piece of code in a single line? <?template:Name?><?choose:?><?When: G_1/ORG_2PT1_FLG='Y'?>Company2<?end when?><?When: G_1/ORG_2PT1_FLG='N'?>Company1<?end when?><?end choose?><?end template?> Thanks.

Hi, Have you checked below SA? Maintenance Management - Purchased Item Usage Real TimeReceiving - Purchase Receipts Real TimeMore information on: What is the purchased item quantity that was returned back to the supplier? (oracle.com) Thanks.

I haven't tried it but can you check below notes and see if they help: Approach for REST API Services Using Single Sign On (SSO) (Doc ID 2453655.1) How to Use JSON Web Token (JWT) For Authorization With Fusion Cloud Application REST APIs and SOAP Web Services ? (Doc ID 2572018.1) Thanks.

Hi @AlexSantos , I think it should be possible using object_id from transaction analysis to dor id from DOR Subject areas. There are many examples for different objects on customer connect. Check below posts: Assignment Approvals — Cloud Customer Connect (oracle.com) Goal Plan Approvals — Cloud Customer Connect…

Pls check if below helps: Fusion Applications - OTBI - BI Publisher - How To Display The Employee Image Stored In The Database OR XML Pulled into The Report ? (Doc ID 1940036.1) Dynamic Images in BIP report — Oracle Analytics Need to display Employee Image in the BIP report output — Cloud Customer Connect (oracle.com) Show…

Please post Fusion Cloud related queries on customer connect. This forum is specifically for Oracle analytics. Below forum will be a better place to get some traction on your query: Order Management — Cloud Customer Connect (oracle.com) Thanks.

This community is for Oracle analytics. For Fusion SaaS related queries, please use customer connect. You can ask your query in HCM forum: Human Capital Management — Cloud Customer Connect (oracle.com) Thanks.

Please elaborate your query. Is it a BIP or OTBI report that you are looking to build? Thanks.