I probably got your question wrong... it will not give me every person that has the first name but not the last name and vice versa Did you try FIRST_NAME is not null AND LAST_NAME is not null ?

Can you test your settings by using them somewhere else (another program/tool)? Does the SMTP server have a public recognized SSL certificate? I didn't check right now on an OBIEE (I don't have a 12c running), but I believe it was also possible to set all the details (the CA etc.). SSL is always a lot of "fun", because it…

Not mandatory at all, it's just about disk space that it will take, and more in general having a clean folder structure on your disk. If you do it, you will maybe remember in 1-2 years why you have that kind of folder structure. But somebody else connecting to your server in 6 months knowing that OAS 6.4 is installed and…

Your install match what Christian called "wrong": your domain is right inside the Oracle home. If you do an in-place upgrade with this kind of folder structure, you will not be able to delete the 12.2.1.3 Oracle home, because it does contain the domain (and this one doesn't move during an in-place upgrade). You will never…

Hi, You just define the schemas first inside your physical database in the RPD, you then add tables inside the schemas. A schema isn't mandatory in the physical layer, but in that case all objects should be owned by the user you use to connect to the DB (and would require synonyms as you mentioned). If you define the…

Yes, but no. Manually you can, if you have some hours/days/weeks depending on the amount of things to do. But you can code all that. You can use WLST to code the creation of application roles, adding a "member" (app role, user, group) in an app role, removing "members" etc.

Do not confuse the definition of a user and a reference to a user. The BAR contains references to users and groups, because users and groups aren't created in EM, App roles are created in EM and therefore those are created based on what has been exported in the BAR. The OAS security has 2 sides: in WebLogic console you…

It has app roles and the members of app roles (so app roles being member of another app role, or accounts and groups being members of an app role). I didn't check lately the full format of how the user and groups are referenced, it's possible that because you change the source (AD now), they are referenced differently and…

A BAR doesn't contains the security done in WebLogic console and doesn't affect that at all.

https://community.oracle.com/tech/apps-infra/discussion/4495700/oas-5-9-ssl-setup-can-we-use-same-certs-for-dev-test-prod By the way, isn't it still time to move to OAS 6.4? ;-)

The OS/physical|virtual hardware doesn't, what could change my answer is if you did generate an open certificate covering all the possible subdomains (a wildcard certificate): in this case the same can be used for the 3 environments because the certificate will match the 3 different URL/domains (assuming they all share the…

You could, as long as the 3 environments have the same domain/url. So it depends, but probably you don't want it. If your 3 environments are behind 3 proxies installed locally (so that each can resolve the same domain/url to the local instance and not mix the 3), sure it can work. More realistically: I doubt you want that,…

https://community.oracle.com/tech/apps-infra/discussion/comment/16828162#Comment_16828162 So, the 3 layers you should be talking about the RPD: Physical layer, Business Model and Mapping layer and Presentation layer. That is the backend, the RPD is like all the knowledge that you feed into the brain to make decisions based…

The Docker image will work on any x86-64 OS with Docker. Both Windows, Linux and some Mac (on the new M1 macs no idea if Docker works and if it can run x86_64 images). It will give you a fully functional OAS (OBIEE 12c also available in another folder), but empty, no content out of the box, just a clean install. Here again…

Well, to become familiar with OBIEE the VM only works for half the work, and it would be the same half as the public demo instance that exist (it was linked somewhere on the official site, can't remember where). The VM, just like the demo OAC instance, will let you get familiar with the front end. For the backend, the RPD…

VBoxManage is a command coming with VirtualBox, go in the folder where VirtualBox is installed to find it (it's probably not into your path and therefore not visible without a full path). Also, because you are on Windows it's probably going to be VBoxManage.exe All the links inside the VM only works if the VM knows how to…

https://community.oracle.com/tech/apps-infra/discussion/comment/16823646 It has the required command (VBoxManage) you need to be able to fully switch off time sync, set the VM to a date in 2017 or 2018 (the VM has been released in 2016).

The VM is very old (too old), all the internal SSL certificates are expired by now. You need to turn off time synchronization and change the VM date back in the past. There is another thread in here covering exactly that, let me see if I can find it.

You can create BAR files by command line and schedule that. The front-end snapshop doesn't have a scheduler.

I did a "next next next" kind of import, didn't change anything and only clicked through the screen accepting what I had to accept.