Thanks for looking into it. It was meant for the OAC snapshot.

Congrats everyone, keep it up!

Thanks for the update, sounds like a good plan.

Can you provide more details about your requirement?

Can you add and see it works OR ( "HCM - Workforce Core"."DFF - Action"."PER_ACT_LASTUPDATEDATE" IS NULL )

Oracle Fusion Applications (ERP/HCM/SCM/CRM) are intentionally designed so customers cannot directly connect to the application database using tools like SQL Developer, unlike Oracle E-Business Suite (EBS). This is an architectural, security, and supportability decision, not a technical limitation. Fusion runs in a…

Good advice, thanks for providing the update.

Please log a Service Request with Oracle Support and explain your case.

Have you looked at following tables Budget transactions header → XLA_AE_HEADERS Budget transactions lines → XLA_AE_LINES Control budgets → XLA_CONTROL_BUDGETS Hope it helps!

Please refer the following post https://community.oracle.com/products/oracleanalytics/discussion/26810/how-i-access-the-oracle-tables-in-oracle-bi-ee-publisher

Hi Nivya, have you checked with Oracle Support, if RTF content is supported?

Here is the one example showing join between "Workforce Management - Worker Assignment Event Real Time" and "Human Capital Management - Transaction Administration Real Time" SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',PREFERRED_CURRENCY='User Preferred Currency 1';SELECT Person_Number saw_0, Name saw_1,…

Thanks, Brandon, for the feedback. Agreed, it needs to be zoomed out to get to the real data.

Thanks for sharing the blog, will definitely read thru it.

You definitely need a strategy to overcome this issue. I would advise to engage Oracle Product team considering it is such a large OBIA deployment.

It is definitely not supported, and you might need to look at a custom solution. Please research and see if there is a BI Privilege Export provided by Oracle, you might be able to create a custom role without this privilege. Assign this to the User whom you do not want to give the default Export functionality and then look…

Thanks for providing the update here. Yes, there is no generic rule, it will be on case-by-case basis. For some workbooks based on the design, it will work and for others it won't.

You can specify data to be refreshed at specific times in a day; up to a maximum of three time per day. For example, you could set refreshes at 10AM, 2PM, and 5PM because that's when you want the intra-day data to be refreshed.

Looks interesting, thanks for this custom extension.

I believe this is expected because Role-playing worker dimensions (Incumbent vs Candidate) cannot always be combined because they map to different fact tables with different grains. You might try building two datasets: Succession Plan + Candidate details Succession Plan + Incumbent details Then: Use UNION ALL OR Join them…