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.

What data type is your "dimension"."START_DATE" column? Because the LIKE %...% syntax only works on strings, if it's a real date you can't just expect it will work with some magic conversion from date/time to text.

Also worth knowing that DV has its own CSP apparently, if you go in DV, Console, Safe Domains you can add domains to set in CSP directive, and the "Embedding" checkbox is the one for frame-ancestors .

How to change the frame-ancestors for the bi-security-login deployment? No idea, if it isn't a checkbox somewhere in WebLogic but it requires to change a file in the WAR archive (like web.xml or anything else), you would be outside of the supported scope I believe. I imagine this problem doesn't happen when you have a full…

I did just try in a new OAS 6.4, without '<InIFrameRenderingMode>allow</InIFrameRenderingMode>' by default it is: frame-ancestors 'self'. Without '<InIFrameRenderingMode>allow</InIFrameRenderingMode>' and with a CSP directive: frame-ancestors 'self' https://mywebsite.com . With…

Ok, so in OAS there is a setting (in instanceconfig.xml) named "InIFrameRenderingMode" (<ServerInstance><Security><InIFrameRenderingMode>): As you can see you will need to set this one to "allow" and then you also have a reference telling you that you also need to set the CSP settings. As you can see they say that you…