Well, it obviously depends on your whole query. If you have something like this: SELECT something FROM a_table WHERE location IN ( SELECT location_name FROM hr_locations_all_x WHERE active_status = &…

I remember that it was possible to switch the security model back to "Oracle Fusion Middleware" in the config file, there was a MOS note about it. You can try by stopping everything, look f…

If your analysis is built with LSQL directly, you can reference dashboard prompts only through variables. Make your prompt assigning the value to a session variable, and reference the variable with t…

Note: Even though the existing FMW is the same version (12.2.1.4), a new FMW need to be installed. This is because FMW is only one piece of the equation: the OAS binaries are injected right into that…

Guest access means no license access, this is also going to be an issue in case of audit of your licensing usage. OAS doesn't have that anymore because OAC doesn't have that, and OAS comes …