1.Login Oracle Application Express Workspace.
http://192.168.0.9:7777/pls/apex
2.Click SQl Workshop
3.Click SQL Commands
a.Create DB link in Oracle E-Business Suite (Apps 11i)
b.Create function apex_ebs_login
create or replace function apex_ebs_login (p_username IN VARCHAR2, p_password IN VARCHAR2)
return boolean
as
begin
if fnd_web_sec.validate_login@apps(p_username, p_password) = 'Y' then
return true;
else
return false;
end if;
end;
Note :- DB Link Name (@apps)
4.Select Application (exiting Application)
5.Click Shared Components
Select Authentication Schemes
6.Click Create 7.Select For scratch and Click Next
8.Name : EBS_APEX_LOGIN
Description :Oracle Application Express Authentication with Oracle E-Business Suite (Apps 11i) Click Next
9.Click Next10.Click Next
11.Select Application Express Built-in Login Page Click Next
12.Click Next 13. Select Use my custom function to authenticate
Authentication Function : return apex_ebs_login;
14.Click Next15.Click Next
15.Logout URL
wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:1:&SESSION
Click Next
16.Click Create Scheme17.Click Chanage current
18.Available Authentication Schemes: EBS_APEX_LOGIN
19.Click Make Current
20.Click Run Application
21. Username : sysadmin Password : xxxxxx
Posts
