Hoping that it will be recorded and shared with folks who cannot join on Thursday!

There is another one, Access to favorite OTBI folder from OEC top — Oracle Please check it out, you can vote on either one or both based on your requirement. Hope it helps!

Hi Karthik, I do not have the required permissions to explore it, see if you can try it out in your env. If it still does not work then need to explore the Custom Subject Area. Thanks

Hello @Bhaskar Konar, I do not have the required permissions to work on it but see if you have access and try to create the dataset from the FND_LOOKUP_VALUES_VL. Refer the attached screenshot. If above does not work, then you have to extract FND LOOKUP data and push it to custom object and then use it in the OTBI. Hope it…

As you have mentioned, it is not easy to get out of because both Subject Areas - HCM Learning (for course completion) and HCM Workforce (for headcount) have no connection with each other. You might need to consider BIP datasets and see if it can get you what you need.

Thanks Benjamin. I hope webinar comes soon. Is it possible we can get the presentation deck for the time being? Appreciate it!

I do not think you are going to get a simple answer for your customer for the question. There was another Forum Post which has lots of conversation around retention, hope it can give you some pointers. Is there a way to extend the data retention period in FDI for longer than 3 months? — Oracle Hope it helps!

Consider working with Oracle Support via SR, I am sure they might have already seen this behavior from some other clients as well and already discussed with the Product Development team to come up with a viable approach. Alternative approach is going to be bit tedious in terms of using OTBL and finding the correct Subject…

I believe it is not available and few other clients already reported it. There should be already an Idea in the Idea Lab for this enhancement. You might want to review it and add your comments and upvote the idea as well. Hope it helps!

A Critical Patch Update is a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and in third party components included in Oracle products. These patches are usually cumulative, but each advisory describes only the security patches added since the previous…

I do not think you can directly join Sales – CRM Interactions Real Time with Receivables – Transactions Real Time. Each subject area pulls from separate transactional schemas within Fusion (Sales Cloud vs. Financials Cloud), and OTBI doesn’t have a shared join key across them (like Opportunity ID to AR Invoice ID).

Hi Gail, Thanks for sharing your document, appreciate it. Regards

Yes, your observation is correct, it is not supported. I cannot recall where I read but OTBI don’t maintain a local BI cookie or personalization file between logins. It will be a good idea to check if there is already an Enhancement Request logged for it, otherwise log a new one. Hope it helps!

Hello, OTBI SA is restricted to whatever data elements are exposed in the delivered subject areas. You can’t reference base table fields or write SQL to fetch them in the OTBI front-end. Hope it helps!

I did not get the question, is it related to OTBI Subject Area? Appreciate if you can please rephrase your question? Is it something related to APEX or UI?

Can you try Time.Calendar Week Start Date + 1 and see if it works for your customer?

Hi Aldwin, It could be related to security, does it work for any other user?

I see a lot of potential in this feature, would love to hear from others. Appreciate any feedback.

Dear Community, Working with Oracle Reports and Analytics for some time now, I always wondered why I need to drag each column one by one, please share your comments and vote if it will be useful for you. Thanks

Let me see when I can get some time on it. If you are in urgency, then you might need to still pursue with Oracle.