So I've created an App, and used a custom authentication scheme that uses EBS login credentials.
That works, as a standalone app.
Then I wanted to integrate, wherein the app is called from a menu within EBS.
Using the Oracle Whitepaper ("Extending Oracle EBS R12 using Oracle APEX") I was able to get it to sort of work.
So, when I don't have/use an Authorization Scheme, I can get to the Apex APP Login page from EBS, and at that point log in and continue.
However I can't get it to seamlessly log in using the credentials from the calling Function from EBS.
What I have so far is a SSWA jsp function with the call GWY.jsp?targetAppType=APEX&p=116:10:::::EBS_RESP_ID,EBS_APP_ID,EBS_SEC_GROUP:[RESPONSIBILITY_ID],[RESP_APPL_ID],[SECURITY_GROUP_ID]
That produces:
Access denied by Application security check  | Error | Access Denied - User does not have Oracle E-Business Suite Responsibility | | OK | | |
| |
My Auth scheme is copied from the whitepaper
DECLARE
l_user_id NUMBER DEFAULT 0;
L_RESP_ID NUMBER DEFAULT 0;
L_APP_ID NUMBER DEFAULT 0;
L_SEC_GROUP NUMBER DEFAULT 0;
BEGIN
FOR C1 IN (SELECT USER_ID FROM FND_USER WHERE USER_NAME = :APP_USER) LOOP
L_USER_ID := C1.USER_ID;
END LOOP;
BEGIN
SELECT NVL(TO_NUMBER(:EBS_RESP_ID),0) INTO L_RESP_ID FROM DUAL;
SELECT NVL(TO_NUMBER(:EBS_APP_ID),0) INTO L_APP_ID FROM DUAL;
SELECT NVL(TO_NUMBER(:EBS_SEC_GROUP),0) INTO L_SEC_GROUP FROM DUAL;
EXCEPTION
WHEN OTHERS THEN
L_RESP_ID := 0;
L_APP_ID := 0;
L_SEC_GROUP := 0;
END;
IF L_RESP_ID <> 0 THEN
APPS.APEX_GLOBAL.APPS_INITIALIZE(L_USER_ID,L_RESP_ID,L_APP_ID,L_SEC_GROUP);
ELSE
RETURN FALSE;
END IF;
RETURN APPS.APEX_GLOBAL.FUNCTION_TEST('APEX_QW');
END;
I realize it's pretty difficult to troubleshoot remotely, but can anybody give me some pointers as to where to look?
Thanks
-Jerry