Hi, Are you maybe based in India or a region in the area or have set that as your date/time? The 2 dates to me looks the same, once corrected of the time zone. For example I believe India is at GMT+5:30, if you take midnight and remove 5h30 you get 6:30pm, and that's why you get a date in your URL that is 5h30 earlier than…

That's a configuration of that forum. It's a bit weird: if you aren't connected to an Oracle account, it is visible. If you have a valid session with your Oracle account then you need extra steps. Read the content of that page, it does talk about an incomplete profile (point 2.). You need to go through those steps to…

Hi @Jorge Olmeda , Would you mind to post a new question for this? This one has been imported from a different forum (after having been migrated across at least another forum). Pictures have been lost and it was about OBIEE 10g. In your question, can you also make sure to say which part of OAS you are working with: DV,…

@User_74KN4 , You can follow the link provided by Rajesh and post there (find the best matching category). It's a parallel forum but the 2 platforms are independents and a question can't be moved from this forum to the Cloud Customer Connect forum.

Reading again your question: when we try connect to http://xxx:9502 it redirect to https://xxx:9502. That sounds like a browser thing. Browser try to enforce https:// on everything, there was even a plan to make that a default thing that any URL would be turned into https://, now I believe it is checkbox somewhere in…

Hi @LCDavis-Oracle , the links you posted are tags, a "virtual" labeling of posts. Do you have a category in mind instead of tags? If you do, the question can be moved there instead of the OBI Apps category where it is now.

Hi @Kristina P , The Fusion Apps products are covered in a parallel forum: Because it's an independent forum, the question couldn't be moved there. If you have the same issue with the same product, you could try to go in that forum and find the best matching category where to ask. If you aren't using Fusion Apps products,…

Hi @User_DA2EL , Could you please post a new question explaining your situation, the product (name and version) involved, the context and what you are trying to do and what you get instead of the expected result? This is an almost 8 years old question that was abandoned by the user and migrated across a few forums. Thank…

Hi, All the catalog is in the database, everything: /shared, /users and /system. All this is in the BIPLATFORM schema. Yes, OPSS is the piece containing the embedded LDAP and the security mappings and is stored in the database too. It is just not in an easily readable format… OPSS is one of the schemas created by the RCU…

In theory there are ways to do that in WebLogic, but it works better when you are deploying your own applications. In the case of OBIEE there is a lot deployed already, therefore it could be challenging to not break everything by trying to do it in WebLogic directly. As others said, you generally do that in a proxy in…

I'm not aware of a category here focused on Taleo as source, and moving this to OTBI will not help much (because it is more related to the Taleo kind of data than just generic OTBI). In a different forum ( ) they said Taleo is covered in CCC: Maybe have a look there as well to see if you find a category related to Taleo…

Hi Clare, Do your HR data comes from some Fusion application? Or do you use Fusion Data Intelligence? (ERP, SCM, HCM, CX?) Because I believe this category (maybe forum) isn't the ideal one for that kind of question, just trying to find out if there is a better category in this forum where to move the question, or if it…

The system settings mentioned by Mostafa are in DV > Console > System Settings. Search for time zone and you find all the configs related to that. Before setting something there, you should be sure about your data, because that setting will change your OAC behavior when dealing with dates and times. And if you have OAC…

Both users aren't active in this forum. This question was imported from another platform. Please post a new question in , post your product name and version and your question with all the details for other people to be able to provide replies.

Hi Helen, Was this meant to be a comment on your idea on that topic? Or is there a question in there that I'm missing? If you didn't mean to post it as question, we can make it "disappear"…

ExtractDateignore the time component and set it to 12:00:00 am (midnight), therefore doesn't really matter what was the time of your dates, and if you add an hours or 2 in there before calling the function… Because your data comes from a database, what data type is it there? (and what database?) Is it possible that it has…

a)The calculation output is still incorrect (screenshot below ) Why? What is your current calculation doing and what are you expecting instead? The product simply execute queries, therefore you can see what it is doing and then correct the behavior based on your expected result. The easiest way to see queries in a workbook…

What is your data source behind that dataset? Is it a database or a file or something else? I imagine you could workaround it in a "dirty" why by first adding some hours (a few more than your time zone, to safely handle daylight saving time changes etc.) to your date and then get the day from it. The time would be totally…

Hi @Babu Dass , You should consider posting a new question, providing all the details of your environments (from what version, to what version), what you observe as issue, what you did so far to debug the problem etc. This thread is a old, abandoned, question that was about a different situation. Thanks.

The change of date is probably a timezone effect: midnight in your timezone (probably GMT+1 or more) translated to UTC means a day earlier at 11pm or earlier (depending on your timezone).