Redirect One Server App To Another Server App Without Second Time Login In Oracle Apex

1. Create Report With URL Generation                Source Server 

 SELECT   'http://URL/f?p=' 
          || '101'
          || ':'
          || 2
          || ':'
          || :APP_SESSION
          || '::::P2_USER,P2_SESSION_ID,P2_LOG_ID,P2_BRANCH_CODE:'
          || 'admin' -- :app_user (this user must be common between server)
          || ','
          || :APP_SESSION
          || ','
          || :AI_LOG_ID  -- This one is just for passing value
          || ','
          || :AI_BRANCH_CODE CARD_LINK,  --This one is just for passing value
          '48' CARD_TITLE,
          'Go Another Server App' CARD_TEXT
     FROM DUAL
 
2. Create A Public page with like below items               Destination Server           
     
P2_USER,P2_SESSION_ID,P2_LOG_ID,P2_BRANCH_CODE:'

3. Create a Process on load before header for authentication

begin
apex_authentication.login (p_username   =>:P2_USER,
                           p_password   => '123');
                                    
Exception
    when others then raise_application_error(-20001, sqlerrm);
End;

4. Create a Dynamic Action On Load with Submit event

5. Create a branch and select the page where you want to redirect.

6. Create Custom Authentication with boolean return function like below

function my_authentication (
    p_username in varchar2,
    p_password in varchar2 )
    return boolean
is
    
begin
    Return true;
exception
    when NO_DATA_FOUND then return false;
end;

Don't Forget to Copy past the function to Authentication Function Name