As said before, you should ask the question in the forum of Oracle University as it's them handling and certification part: Of course, if somebody in here took the certification recently in a different language they can give you their opinion, but for a formal answer I would still ask Oracle University.

Hi, Certification questions have to be asked in the forum covering that topic: PS: the forum is in English only, for many of us it isn't our main language, but we aren't here to look after grammar or anything like that as long as we understand each other ;-)

Hi, Can you at least explain what is the meaning, the expected result? Because more than trying to convert 1:1 calculations, you should know what you want to achieve. The 2 products being different, there are chances that things can be done differently to get the best experience with OAC instead of replicating exactly an…

If you search about EM and processes showing as down in MOS you find some references. It isn't always an OAS specific topic but more a Fusion Middleware thing. For example (but not saying these apply to your case, also because each product has a bit of a different setup inside FMW EM, some being mostly managed servers,…

Yes, you can use a calculation where you enter your formula. The functions you will use are just 2: TIMESTAMPADD to add or substract days and months, and DAYOFMONTH to have the number of the day of the month. The logic is just what I said above. For a given date, you will subtract (1 - number of the day of the month for…

Hi, It looks like a quite old OBIEE? When there are errors with .cpp involved, it's always difficult to debug something, and your query also doesn't look good at all (nothing personal, but when a LSQL is a wall of text, there isn't much to debug…). Did you search for that .cpp in MOS? There is one document mentioning it,…

@User_S6RKR : Is that a piece of GenAI copy/paste? (Yes, it is) Looks like this is the second reply from GenAI. What is the target? OP could have asked ChatGPT himself if that was the expected result… Steve answered the question, I will just add a comment on one point: We are deploying a significant number of OAC…

The above answer sounds like a piece of GenAI output, don't blindly trust it… (or not at all, it isn't the best GenAI output you could get) Can you add inside the column with Product Category another grouping? This is what I am looking for. What do you mean by "another grouping"? Are you saying that you want to concatenate…

Hi, OAS isn't going to send SMS by itself. You will need to use an external service for that (can it be a webservice or sending an email or whatever the provider/service you select for the job requires). As Jacques said above, data actions if you are in DV, or action links if you are in "classic" will do the job. If your…

Hi, In what place of OAC are you trying to do that? Because the last day of a month is something "dynamic" (28, 29, 30 or 31), you can generally easily get it by combining a number of simple functions available in the tool (assuming "classic", DV workspace or RPD): subtract the day of month from a date, add 1 month,…

@User_FWBDT , As a quick fix I would say you can just comment out the call to the logoff at the end of your script: the open session will timeout and be closed anyway. I didn't use the webservice in OAS 7.6 (2024), but based on Mike's comment above, I see a connection. The error seems to be saying that you can't call the…

TL;DR: There is no API that is built to work between different environments. All the APIs only operate in a single environment. This doesn't prevent you from connecting to the 2 environments, read on one side and write the content you did read on the other one. But it's separate read and write calls. Or, if you just want…

The example in does exactly that: it does a LISTAGG on a the names by department. And it does definitely work as I just gave it a try in OAS 7.6: If you add more columns, the LISTAGG will be done by each combination of all the values of all the other attribute columns. That's just standard SQL behaviour.

It does depends on everything else going on in your analysis, in what you model is built on. One of the first results of a random Google search: There are a number of blog posts covering it…

Hi, Your need is to concatenate text, and for that you need to use LISTAGG itself. You call it by using EVALUATE (or EVALUATE_AGGR). That's how it is done because there isn't a "natural" (universal) was to aggregate text.

OAS 6.4 (2022) is out of support being more than 2.5 years old. Parameters are a OAS 7.0 (2023) feature, and they kept evolving with more pieces added over time. If you use DV, it’s very important to have a yearly upgraded planned because all the changes between OAS releases are mostly DV features (packaging 12 months of…

Oh, wait, I maybe misread your initial post. So you mean OAS is available, not EM. In that case discard my previous reply. Ok, in that case, there are situation when EM "lose" connection with the real status of the product. You see it down in EM, but the services are up and running. In your case, having a a cluster with 4…

In DV, the "parameter" is the equivalent of the presentation variables you have in "classic" analyses and dashboard. You can read more about parameters at Because you have different data sets in your 2 canvases, you can't just pin your filter at the workbook level directly, because that would be a column of one of the…

Hi, EM, just like the WebLogic Admin Console, aren't BI services, they are both deployed on the weblogic AdminServer. EM is part of FMW, not of OAS itself.

Hi, Welcome to the forum. The detail of your question maybe got lost somewhere, or maybe you didn't enter it in the first place. Not a big deal… It would help if you could reply with the details, or edit the question to add them. Starting with a product name and version, just in case that plays a role. Then you should…