Welcome to the Oracle Analytics and AI community. Your post is missing the main message, therefore there isn't much to work with. I suspect you may have posted in the wrong community. What product are you using exactly? Is that AIDP? If you are using the AI Agent Studio for Fusion Applications, that's covered in a…

A large number of patches are now delayed. Even the database patches are delayed. Some rumours linked this delay with some of the most recent AI models able to detect old hidden issues. Doesn't change much, delays are acceptable if properly communicated, which isn't always the case here…

Hi, There isn't a concept of "index" in the RPD because it doesn't have any impact in the modelling of your data. The keys are there with different meanings in the physical and business layer. The BI Server will generate queries based on how you model things in your RPD. You can influence the query produced by changing the…

By using opatch lsinventory you should be able to find the answer. In my case, as I always used the OWSM bundle patch, the version is listed explicitly. And if you can't find the version, try applying them from the older version to the newer. Opatch is supposed to be smart enough to know if it can apply the patch or not,…

Welcome to the Oracle Analytics and AI community. Your request is something related to Fusion HCM. Fusion HCM isn't an Oracle Analytics product, it does use Publisher for some reporting, but that's where it ends. Fusion is covered in a separate, and independent, forum: https://community.oracle.com/customerconnect Have a…

Hi Chad, Did you download the correct version? There are 7 versions of that patch, all covering different versions of Oracle Webservices Manager. If you check the list on the left of…

What are you trying to patch exactly? A database client you installed yourself? Or something that was provided as part of OBIEE? For the first, you probably just install a new one. It isn't related to OBIEE. For the second, you should look at all the available patches for the product. If you patch WebLogic, FMW and OBIEE…

I would follow the direction hinted by @Ambient . There isn't best practices for the semantic model explicitly, because the idea of the native git integration is to be able to use classic git strategies and best practices decided in your organisation. If somebody else there already use git for some other product, you could…

Your organisation using, internally, certificate expiring every 6.5 months is … a bit extreme :D Usually internally certificates are valid for 3-5 years, 2 when a bit more strict and 1 when they really want to be "picky". That's at least what I saw so far around. As you mention OAC, maybe you could explore the option to do…

Yes, to be "offline" and not mess around with the live system. Cleaning up the aliases I wouldn't bother much to be fair… If you don't need to renew your certificates every few months, you just get a new alias every year, or maybe every 2 years. The keystore will not really notice a difference if it contains 1 alias or 10.…

Hi, I usually take the lazy approach of minimum amount of changes. Replacing certificates by keeping the alias, so I don't need to change anything in the OAS config itself. Overall, as you already know how you configured SSL, you can also add your new certificates with a new alias, in that way you can first work freely on…

Hi, Welcome to the Oracle Analytics and AI community. In the "old" RPD, the joins are split in two parts. In the physical layer you define the rule of how 2 tables can be connected, but it's a physical representation of data, it still doesn't have a "business" meaning. The fact your join should be a left outer join instead…

When you create a physical join, you go directly in the Expression Builder before to click "Ok" and create it. There you can write your condition using functions or anything else you need. If the join already exists, and it is a "Physical Foreign Key", you can't change it. You need to delete it first and add the join…

In your semantic model (the RPD), you just define the physical join with the LOWER() function on your column. You can set "complex joins", where you are allowed to write formulas and not just select column1 = column2.

Hi, Welcome to the Oracle Analytics and AI community. First of all, this forum doesn't cover Oracle AI Database Private Agent Factory because it isn't an Oracle Analytics product. Oracle AI Data Platform is a very different product that doesn't share much (anything) with the Private Agent Factory product. The Private Agent…

Did you create your OAC instance yourself selecting it directly in your cloud tenancy console? Was your OAC fully empty and you had to build everything from scratch? Or is your Oracle Analytics part of your FDI product? And did your Oracle Analytics environment comes with a number of predefined things (both in the semantic…

Yes, that's the current rule that has been valid for every OAS release. As long as the yearly release keeps being in March, the rule of the 2 years support is valid. But that's why it's good to bookmark the Oracle Support site page linked above, just to have a formal document covering the topic (as you usually ask yourself…

@User_A63N1 , if you want to request that feature that is currently not available, you can do it by posting an idea for it. https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server You can have a look first if the idea already exist, and if it does, up-vote it. If an idea for…

So, you are using Fusion AI Data Platform (previously FDI, previously FAW), and not OAC, right? Fusion AI Data Platform doesn't have all the same features of OAC, or at least not at the same time. It follows different release schedules. And some features just aren't part of FAIDP compared to OAC. If you are using FAIDP,…

Hi, Welcome to the Oracle Analytics and AI community and forum. You can bookmark the following MOS link: https://support.oracle.com/support/?kmContentId=2775561 OAS has a very simple support timeline: latest version is supported, the previous one is supported for 1 year after the release of the next one. Therefore OAS 7.0…