
JasonS.70827 (Customer) asked a question.
I cannot find any documentation on fully integrating Okta Access Gateway with Oracle Application Express (Apex). Apex is an out-of-the-box application in Okta Access Gateway, however the documentation fails to have ANY steps for configuration in Oracle Apex (it only shows the steps to perform on the OAG side, which is half of the information required).
Hoping the community can help to describe the steps to get Apex working using HTTP Header Variable Authentication Scheme (which is what OAG uses).

Hello @JasonS.70827 (Customer),
Thanks for posting. From the Okta site here you can find the steps to add an Oracle Apex app, additional documents nested will help you:
https://help.okta.com/oag/en-us/Content/Topics/Access-Gateway/add-oracle-appx.htm
I made some research on the Oracle side using Header Variable Authentication Scheme and I found some interesting tutorials, I hope you find them useful:
https://apexapplab.dev/2021/05/31/okta-authentication-for-apex-in-5-minutes/https://docs.oracle.com/database/121/HTMDB/sec_authentication.htm#CIHEBJEH
Additionally, please refer to the following thread from Oracle:
https://community.oracle.com/tech/developers/discussion/4059530/custom-authentication-using-okta-single-sign-on-utility
Please let us know if this helps you or if you need additional assistance.
Regards,
Natalia
Okta Inc.