Hi Joyce, Welcome to Oracle Analytics Community. You can log an idea for FDI in the idea lab below: Oracle Fusion Data Intelligence Idea Lab — Oracle Check the Ideas tab on home page to access idea labs for other products. Post your idea and share it with other community member through various channels. Once you have…

Welcome to Oracle Analytics Community. Can you please elaborate a bit more on your requirement? Is your query related to reporting? If no, please post your query on the cloudcustomerconnect for better traction and response. Thanks.

Hi Sophiya, I request you to search this topic on cloudcustomer connect to check if there is something available already? "doo_fulfill_lines" - Cloud Customer Connect How to map FOB code from DOO_FULFILL_LINES_ALL to its text value in Sales Order UI? — Cloud Customer Connect Thanks.

Congratulations all !!!

Yes, this query will return you the same. Thanks.

Hi Nivya, You can write a query based on per_all_assignments_m position_id. Get the latest effective start date from assignments table when a position was assigned. Thanks.

Hi, You need to get it from area of responsibilities tables. Check the query on below thread: Query to find the HRBP Representative of an Employee in HCM Database — Oracle Thanks.

In addition, please make sure you run Refresh Manager Hierarchy. Manager Name not updating in Analysis — Cloud Customer Connect Thanks.

Hi Nivya, This only works for PDF. Thanks, Mandeep.

You will need to upload the FAQ to content server and then write a SQL to pull it from there in attachments section. Please check the step by step instructions on below link: Adding External PDF attachments to bursted PDF output Thanks.

Hi Arafat, Welcome to Oracle Analytics community. Can you give some more details on what the report does? Does the report query use any secured views? Can you check if the other user trying to run the report has permissions to see the data from UI? Thanks.

Hi Mayur, You can write a with clause CTE in your query which will give you the schedule start date and time and then use that in your main query. Thanks.

If you are talking about Flexfields available on Data model screen, please go through the below documentation: 6 Adding Flexfields Thanks.

Hi Flying, Welcome to Oracle Analytics community. You don't need any special steps to display flexfields in BIP. Once the DFF attribute is configured, relevant table column will be populated with data. You can then write a simple SQL statement to display data from that DFF field in your parameter. Or if your question is…

Hi @Shounese A , Welcome to Oracle Analytics community. You can add per_person_secured_list_v in your query. It will restrict the data based on role data security. Please add and retry. Thanks, Mandeep.

Hi Prithvi, As confirmed by Kevin, JWT token authentication is not yet support: JWT Token Support for Fusion Applications BIP Webservice (Doc ID 2772939.1) I have submitted an idea for same. Please upvote if you think it will be helpful: Enable JWT token-based authentication for BIP web service calls — Oracle Thanks,…

Hi Gina, Are you looking for a report in FDI? Or in fusion BIP/OTBI? Thanks.

Hi, Can you please ask the concerned users to clear browser cache? This should resolve the issue. Thanks, Mandeep.

Hi Oriana, Can you please check data for these two workers in per_periods_of_service table and scan through the context and other attributes if there is any existing data? Thanks, Mandeep.

Hi Manjunath, Welcome to Oracle Analytics community. This community is specific to Oracle Analytics tools. For any other questions, I would suggest you to log your query on Oracle University forum. Oracle University Learning Community Thanks.