Hi,
I know this has been mentioned quit a bit, but after trying everything i still am stuck with this problem.
My application requires authentication and after successful login I want to set the first page in Apex depending on the user.
This is done with the default login process which exist on page 101
wwv_flow_custom_auth_std.login(
P_UNAME => :P101_USERNAME,
P_PASSWORD => :P101_PASSWORD,
P_SESSION_ID => v('APP_SESSION'),
P_FLOW_PAGE => :APP_ID||':1'
);
I've changed this to
if package_auth.user_is_advanced(:P101_USERNAME) then
wwv_flow_custom_auth_std.login(
P_UNAME => :P101_USERNAME,
P_PASSWORD => :P101_PASSWORD,
P_SESSION_ID => v('APP_SESSION'),
P_FLOW_PAGE => :APP_ID||':50'
);
APEX_UTIL.SET_SESSION_STATE('FSP_LOGOUT_PAGE',50);
else
wwv_flow_custom_auth_std.login(
P_UNAME => :P101_USERNAME,
P_PASSWORD => :P101_PASSWORD,
P_SESSION_ID => v('APP_SESSION'),
P_FLOW_PAGE => :APP_ID||':1'
);
APEX_UTIL.SET_SESSION_STATE('FSP_LOGOUT_PAGE',1);
end if;
depending on the user it works correctly and it branches to page 50 or page 1.
The problem is when i logout, logging in again will take me always to page 1. I found out that i have to change to default Home URL. So I've changed the Home URL from Application Properties->User Interfaces->User Interface Details to
f?p=&APP_ID.:&FSP_LOGOUT_PAGE.:&SESSION.
but the application item FSP_LOGOUT_PAGE resets to null, thus directing me to an invalid page. I have checked and FSP_LOGOUT_PAGE application item that i have created is set with the correct value after logging in.
Any ideas?
APEX version: 4.2.4.00.08
DB version: 10.2.0.1 under RedHad 4 update 5 32bit
Web server architecture: OHS running on DataBase server
Browser(s)/version(s): Firefox latest version
UI/Theme: Builder Blue custom changes
Edited message to include platform/application version information