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