Hi,
We are trying to implement SSO using OAM.
The OAM and Oracle APEX integration is done by referring below document.
http://www.oracle.com/technetwork/developer-tools/apex/learnmore/apex-oam-integration-1375333.pdf
When I access Oracle APEX from OAM SSO Home page it gives error "Null Username Passed to login procedure".
Can you please let me know if there is anything missing to be done on APEX side?
Oracle DB-11g
ORacle APEX 5.1
Listener -Oracle HTTP server,Oracle weblogic,webgate setup
Authentication method used - HTTP Header variable. The home page Authentication page attribute is set to PAge needs Authentication.
OAM Reponse variables are set up by OAM admin as per above doc.
Tried to print CGI variable but it doesn’t show up variables HTTP_OAM_REMOTE_USER,HTTP_OAM_REMOTE_USER_EMAIL.
Also REMOTE_USER is set APEX_PUBLIC_USER instead of Windows network username. Shouldn't that show network username?
--Print CGI variable
begin
OWA_UTIL.print_cgi_env;
end;
--Output
PLSQL_GATEWAY = WebDb
GATEWAY_IVERSION = 2
SERVER_SOFTWARE = Oracle-Application-Server-11g
GATEWAY_INTERFACE = CGI/1.1
SERVER_PORT = 7777
SERVER_NAME = "****"
REQUEST_METHOD = GET
QUERY_STRING = p=100:1:9730399216464:::::
PATH_INFO = /f
SCRIPT_NAME = /pls/apex
REMOTE_ADDR = 10.23.103.5
SERVER_PROTOCOL = HTTP/1.1
REQUEST_PROTOCOL = HTTP
REMOTE_USER = APEX_PUBLIC_USER
HTTP_USER_AGENT = Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 10.0; WOW64; Trident/7.0; .NET4.0C; .NET4.0E; .NET CLR 2.0.50727; .NET CLR 3.0.30729; .NET CLR 3.5.30729; MS-RTC LM 8; InfoPath.3; wbx 1.0.0; Zoom 3.6.0)
HTTP_HOST = "host_name"
HTTP_ACCEPT = */*
HTTP_ACCEPT_ENCODING = gzip, deflate
HTTP_ACCEPT_LANGUAGE = en-US
WEB_AUTHENT_PREFIX =
DAD_NAME = apex
DOC_ACCESS_PATH = docs
DOCUMENT_TABLE = wwv_flow_file_objects$
PATH_ALIAS = r
REQUEST_CHARSET = AL32UTF8
REQUEST_IANA_CHARSET = UTF-8
SCRIPT_PREFIX = /pls
HTTP_COOKIE =