If they are sure (I never fully trust people: historically people lied more about things they didn't do or did wrongly than a server), maybe you have a cache issue? If you have cache enabled your condition could have perfectly missed the updates because it never really sent a query to the database. If you have logs on you…

Hi, There aren't tons of options... The first thing you should check is if the agent did execute correctly every day (or at least Tuesday-Saturday based on your description), then you should check the condition query: seeing a function is one thing, what the analysis really does can be quite different. Look at what the…

You add a filter and turn it into an exclusion instead of inclusion. Like in this example I did select "Null" and then clicking on the "..." option I switch from "Include Selections" to "Exclude Selections". Select all the values you don't want and then change the behavior from inclusion to exclusion.

In what part of OAC? There are 3 different places where you could be seeing data: a "classic" analysis, a DV workbook, a BI Publisher dataset.

So what you want to do is not directly to display the max date, but it is to filter your analysis for the max date for the 2 different status. Such kind of complex filter is probably more easily achieved by filtering based on another analysis, handling the logic of finding what rows have the max date for your 2 status. It…

Add the MAX formula to your date, remove the 2 type column and you will get the max date for your 2 status.

https://community.oracle.com/tech/apps-infra/discussion/comment/16842286#Comment_16842286 Yeah, I'm sure that deactivating a WordPress plugin or theme or using the WordPress WP Debugging plugin will help in fixing a HTTP-500 error in WebLogic. 🙄

If the "key icon" doesn't appear it maybe means you don't have the permission "change permission" on that object. Being an admin doesn't mean you have full access to everything, the catalog objects have permissions applying to everybody, admins included.

https://community.oracle.com/tech/apps-infra/discussion/4501171/hide-a-tab-to-a-group-of-users You know that writing some text in your question is free? Things like ... a version (as you said product is OBIEE) always helps. Then qualifying things a bit, like what do you call a "tab"? What kind of object is that? Is that a…

I personally like the idea to tell users to "learn" : never a bad thing :D

It does apply as well: you can't change the behavior of the GUI without heavy customization (that you don't want to do). You can try to display those columns somehow "grouped" (or at least one next the others) in the left pane, but there is no formal way to change what happen when you add your column to the criteria tab.…

Hi Dilek, BI Publisher is often not well covered in the public forum. If you have a valid MOS contract linked to your account, try posting your question in https://community.oracle.com/mosc/categories/bi_publisher , it's fully dedicated to BI Publisher (don't pay attention to the fact it is a subcategory of EBS, just…

Not possible, the GUI works in just one way. Presentation tables can be displayed as being in a "folder" (it's an empty presentation table acting as container for the other presentation tables and their columns). This mean you could visually "help" users by grouping together things that are related, but it would be only…

What product are asking about? You talk about report, which means you should be speaking about BI Publisher, but you talk about subject areas, presentation tables and presentation columns, which could mean you meant analysis instead of report. Knowing exactly the context will make replies more precise.

If you mean the DV plugin you did download from the public library, I doubt those things come with any form of support. It's a custom plugin, not a product plugin. As such you can't really expect much from Oracle I believe (even if that one seem to be written by Oracle). You have the code, you can debug it and fix it. It's…

As said everything work as designed in OAS 6.4, I believe it does as well in OAS 5.9 because there haven't been many changes on this topic. But as said, if you fully debug the situation, you will probably discover it's something else having the wrong CSP and not the OAS page itself (if you did set the right settings in…

Shared Folders is a special thing, setting "No access" there isn't enforced. But set it to anything else and it will work. And you said that this role should have access to just one directory inside Shared Folder, so your test was anyway for something you weren't interested in ;-) Test it on one of the folders inside…

https://support.oracle.com/ is where you can open an SR

Hi, Possible is possible, it's a fairly simple and common case. The things you have to define is what happen when a user has 2 roles: one being the restricted role and another not restricted: will the user be able to access any other directory? The answer to this will tell you what kind of approach you should take, if…

It's actually a = that you can use for timestamps. The easier way to get what you are after is to build an analysis in that subject area, and set a filter on that "dimension"."START_DATE" : if you look at the LSQL of the analysis you will get the exact syntax for a = with your timestamp/date.