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…

What Brendan said: OAS still requires to be provided with the right tnsnames.ora for your connections to work (if not using a full connection string). And in OAS, you can still have the normal connections details in the connection pool, just like you had in OBIEE. OAS didn't remove them. The Semantic Modeler is the one…

Ok, I better see your case and how the current options aren't fully helping you much. I believe that what you would like is the "classic" SOAP webservice able to execute LSQL queries but in the new OAC REST API. There still isn't such a method documented in the REST API of OAC (but I believe there is an undocumented…

Hi @K Nowak , I'm not fully sure where the idea was posted, as it has a Cloud Customer Connect link (a separate forum, not in charge of Oracle Analytics products). The right place for it would be https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server Your idea doesn't show in…