Hi @Kay Pagatpatan , Welcome to the Oracle Analytics community and forum. Your question is about Oracle BPM, but posted in the OBIA category of the Oracle Analytics forum. Is your question related somehow to an Oracle Analytics product? Because if it's only about Oracle BPM, then this is the wrong place. The BPM public…

As Philippe said, the catalog doesn't have any versioning logic in place, therefore it can't provide information about previous versions. There is a temporary "content versioning" because one of the table keeps the content of the object (workbook in this case) till a scheduled task clean up the un-linked rows. But those…

Hi, The forum use English as common language. Nobody here will look at your grammar, as long as the message is understood that's what matter. You should consider writing in English if you want to benefit from the whole, global, community (don't expect hundreds of people to use a translator to understand your post).

Hi, This forum is about Oracle Analytics products. BICC is not part of them, it comes with Fusion apps. You should visit , which is the forum covering Fusion applications, and find the best matching category in there for your question.

If they said the translations were fine, it would have been less funny than telling you that you (being French) are wrong, and them (not speaking French) are right because Google Translate said so. Imagine the quality of translations of other languages if Google Translate is the reference. Still, that reply is just not…

Hi @Sophiya , Sorry to ask that again, but I suspect there is (still) some misunderstanding on the question… Are the "OAC reports" you mention publisher reports in OAC? Or do you mean "classic" agents (delivering classic analyses or dashboards)? Or DV workbooks scheduled for delivery? These are the 3 ways content can be…

Hi Sandeep, Welcome to the Oracle Analytics community and forum. BICC is not an Oracle Analytics product, it's part of the Fusion family. Fusion applications are covered in a parallel, but independent, forum: Have a look there, they have lot of categories. Pick the one that sounds like being the most adapted and ask about…

Hi @LukePa , Do you mind mentioning on what part of the 3 possible places in OAC/OAS you are working? The above reply is for "classic" (the /analytics url), while in the past you asked questions about DV, therefore the above doesn't apply. Before to post answers for DV or Publisher, I wait to know what piece of the product…

Hi, What debugging and analysis steps have you done for this? Because I can easily imagine you are fully into this issue for some time and therefore everything you posted make sense for you. But from an external point of view, there is just nothing on which to even guess what you are really seeing or doing. What product…

For Option-1, if you plan to only add that column in the presentation layer, nothing forbid you to create a new presentation table and put your column in there. If you didn't mean to say "presentation", you can model it as a degenerate dimension: physically coming from the fact table, but logically in it's own dimension to…

but we were uncertain if that could affect the catalog integrity, if it could be corrupted or with missing things on it. The catalog only recognize objects having a .atr file with the same name. If you don't have a .atr file, the object doesn't exist for the catalog. That's why when deleting content from outside OBIEE, you…

Hi, The catalog in 11g is on disk, you can just delete the content of the folders (I would leave the folder as it doesn't take much space) on disk (by a script or a find + delete at the OS level) and job done (always delete the file and the corresponding .atr, to not confuse the catalog with ghosts).

Valid point Steve, but it's still a change of default that was set for the past 10 years, from the very first OBIEE 12c release. They will not call it a bug, but that's how it feels to anyone who had the product before OAS 8.2 (2025). And this kind of things is quite annoying for an "enterprise" solution. Mostly because…

Confirmed: port 9515 works for online connection with the Model Administration Tool. @Chad Williams , you could raise a SR to report this as a bug. It isn't documented, therefore at least a documentation bug, but I don't see why this port has been changed, because it breaks an in-place upgrade of OAS. Therefore, in my…

Thanks for all these details Chad. I didn't try connecting online so far, and your post made me test: same issue, can't connect. Then I looked into EM for the ports, and … surprise… Apparently obis1 is now listening on 9515 instead of 9514 where it has been for many years. It doesn't seem to be documented, therefore it's…

Hi @Chad Williams, I just tried on my install and, same issue. Do you mind starting a new thread for this? Because it does definitely look like an issue that more than one person will face soon or late…

Absolutely, it's a parallel forum and therefore content can't be moved across the two. Your only option was to post again there. And because that one is the place of the product your data is from, they should have the ability to provide you a valid answer.

Hi, The tables you name sounds like Fusion tables. Even if you use Publisher to report on those tables, Publisher isn't the owner of those tables, they are owned by your Fusion App. Publisher is only the technical solution running the query for you. You should consider posting in the forum covering Fusion applications, as…

Hi, In OAC March 2025 you have a new feature named "Create and save multiple personalized workbook states". Watch the video below for details on what it is. You can't rename anything in the UI that isn't defined by a user. The word "Workbook" is part of the product, because those are workbooks. It's maybe easier to teach…

When looking at the physical query generated with the CASE WHEN formula, you see that it's a very complex query for what should be very simple. The query start doing the right thing, in a very complicated way, then go into analytical functions for summing over partitions and it finally decide to only take the first row for…