Saturday, June 16, 2007

HTMLDB Authentication with Oracle eBusiness Suite User Repository

Here we will see how to authenticate EBSO User Identity with HTMLDB that is Installed in the EBSO Instance.

Pre-Requisite:
1. Running EBSO Instance
2. HTMLDB Installed on the EBSO Instance

ADMIN URL :http://r11ilab01.r11.com:7777/htmldb/htmldb_admin
WORKSPACE :http://r11ilab01.r11.com:7777/htmldb

Setup Steps:
1. Create a Workspace


















2. Create the following function on the EBSO Instance and Grant execute to htmldb

SQL> create or replace function ebiz_suite_auth (p_username IN VARCHAR2, p_password IN VARCHAR2)
return boolean
as
begin
if fnd_web_sec.validate_login(p_username, p_password) = 'Y' then
return true;
else
return false;
end if;
end; 2 3 4 5 6 7 8 9 10
11 /

Function created.

SQL> grant execute on ebiz_suite_auth to htmldb;

Grant succeeded.

SQL>

3. Login into the WorkSpace



4. Select Shared Components



5. Create an Authentication Scheme and Select From Scratch



6. Name it as "eBusiness Suite Authentication"



7. Select "Use my custom function to authenticate" and give the function name



8. Give the logout URL as below ( it should be in a single line );
wwv_flow_custom_auth_std.logout?
p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:1:&SESSION




9. Create the Scheme



10. Change the Current Scheme to the Custom we created.



11. Make the Selection as the current Scheme



12. Access the Application
http://r11ilab01.r11.com:7777/pls/htmldb/f?p=100:1



13. Signon as SYSADMIN ( EBusiness Suite Administration User )



14. HTMLDB will get authenticated from our Custom Function.



Refered:
Note 373604.1 How to authenticate against Oracle eBusiness Suite User Repository

Popular Posts