How to read HTTP variables in PlSql code with OWS 3.0 of Oracle Apps 11.0.3

In the process of enabling SSO for Oracle Apps 11.0.3 (Titan environment), we have enabled SSO Proxy, and SSO login works great. However, we can’t read the HTTP Header (SSO UserName coming from SSO) in PlSql code.

Here is how to achieve the same in later PlSQL versions such as 9iAS/10gAS/OHS11g/12c:

dads.conf

PlsqlCGIEnvironmentList EIN

pl/sql code

l_ein = owa_util.get_cgi_env (‘EIN '));

owa_util.get_cgi_env seems to be working fine with CGI variables and other HTTP headers such as HTTP_USER_AGENT. Please take a look at the attached dad configuration file (srvxxxx. App file).