Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Integrating Oracle EBS and ApEx Aplication with Responsibilities and SSO.

608573Nov 14 2007 — edited Jan 3 2011
Good day all.

I am looking forward from getting somebody 's help, the trouble I am facing is described below:

a) I am currently working on SSO with EBS. I mean, my users can connect and work perfectly.

b) ApEx is Configured as Application Partner with SSO, and the application we built (it's call PR-Auto)
is working good under SSO platform. I mean I am able to login using TEST user and password TEST in
both applications (EBS and PR-Auto).

c) The thing is that I need to call PR-Auto from one responsibility in EBS;

Following my setup for the responsibility:

- I have created a function:
Name: APEX_FA_PR
Properties:
Function type: SSWA plsql
Web HTML :apps.apex_launcher.launch_fa_pr
Web Host agent: pls/apex

- I have created a menu, application and responsibility using the function APEX_FA_PR.


- I have create launcher package:

create or replace package apex_launcher is
procedure launch_fa_pr;
end apex_launcher;

create or replace package body apex_launcher as
procedure launch_fa_pr as
begin
/** 110 Is ID of PR-Auto, my app **/
/** 5 is my home page **/
f(p=>'110:5');
end;
end apex_launcher;


d) New responsibility shows on EBS menu page.


e) Click on responsibility, and the page shows 'redirecting to login server for authentication', but
nothing happens, page goes blank with this url:

http://fahorromex37.fahorro.com.mx:8004/pls/apex/wwv_flow_custom_auth_sso.process_success?urlc=v1.2~42
03F9A8A1D696097BEA96499E6B6845E80C14A56DF724C3FFF879578FC734C5E1DEEA9129A4117E62A3676A409528E8EB927AA55
0EA7B208C34F5A3FDB4472679EDE448F8971966BE9BADD22207FE90BDBA2800E6529F3967A18DEC76DCC17DE21D96A65CA2C424
319F159CC78ED78E8B99F69F1BA8297A1EECF6AD137A6C3896E1C4E8D5F93874A9A08887D3F95058D33F667D7B785FF0A065B53
891B8B393DFD24530BD0720150F05DE63F0CD5AFD86F0267BAF4C9CAE8C5AA693B4E488B3776BF43450FD412167B402C962BABE
A54707043AFA6FBB168B29EDB3BE120FFE0C30683D53283B036E781ABF1A5F7374ADF83463D57D2EE958765B0501CE2B0F4E3DF
24845A54A1CF02526FA39EF60644ED5A0D9D2A05EBFAD3BD01007D0817135989A4B97D68C92C6E2BA767CFDB0AF188054024BB1
EFFA7DEC8699BBA7485A349D87BA1C15475927E52110DF56FCC3FD560D2CBBA1C0D7D9D3ADFCDB975CD2

the address of my application pr-auto is http://fahorromex37.fahorro.com.mx:8004/pls/apex/f?p=110

f) DBA teams follow instructions from the following documentation
"Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On"
and "Note 261914.1 Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and
Oracle Single Sign-On"

g) We are using:
DB: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
SO: Linux 2.6.9-42.ELsmp
ApEx: 3.0.1.00.07


Any help will be greatly appreciated.

J.O.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 31 2011
Added on Nov 14 2007
15 comments
11,668 views