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
The voice in my head may not be real , but they have some good ideas !!!
Fail Fast, Fail Forward, Fail Often, Fail Better , Standup Every Time
Every problem has at least one solution. Only some solutions are harder to find.
Popular Posts
-
FS_CLONE Phase It is a stand-alone command used for file system cloning. Standard cloning (using adcfgclone.pl) cannot be used to synch...
-
[oracle@testebsop3app01 ~]$ perl /u01/install/APPS/fs1/EBSapps/comn/clone/bin/adcfgclone.pl appltop /u01/install/APPS/fs1/inst/apps/SATURN_...
-
Abort Phase If for some reason either the prepare or apply phase failed or gave problems, you can abort the patching cycle. After runnin...
-
As a green field expert in data science, you would be responsible for designing and implementing data science projects from scratch. This i...
-
PRVG-2031 : Owner of file "/u01/app/oracle/diag/crs/rac01/crs/lck" did not match the expected value on node "HOST1". [Ex...
-
Suddenly all production reports in BI Publisher failed with message " ORA-01017: invalid username/password; logon denied" The da...
-
If you are an EBS administrator the first thing some asks you to do a health check of an environment , you return to him with a Request ID o...
-
EBS 12.2 ADOP Cycle Errors During Validation Cannot open XML file for load ADOP cycle will have validation errors in some cases. *****...
-
ADOP patching on a downtime mode with [ERROR] Patch service is not exist or running Please note , if you get ADOP issues on PROD ple...
-
Let me start telling a story , "Once upon a time there lived a great ♚EBS 12.2 instance , it was very kind to the DBAs and one fine day...