Oracle Apps DBA

Oracle Application Express Authentication with Oracle E-Business Suite (Apps 11i)

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 Next
10.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 Next
15.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 Scheme
17.Click Chanage current
18.Available Authentication Schemes: EBS_APEX_LOGIN
19.Click Make Current
20.Click Run Application
21. Username : sysadmin Password : xxxxxx