tag:blogger.com,1999:blog-21122514.post2227236187935136706..comments2024-03-14T09:05:49.445+01:00Comments on Dimitri Gielis Blog (Oracle Application Express - APEX): Change default (first) page in APEXDimitri Gielishttp://www.blogger.com/profile/16295721159626839167noreply@blogger.comBlogger30125tag:blogger.com,1999:blog-21122514.post-48857736755374593132024-02-07T07:58:20.997+01:002024-02-07T07:58:20.997+01:00Hi All,
i Wrote like this on Login page-> logi...Hi All,<br /><br />i Wrote like this on Login page-> login Process<br />but unable to redirect to reference page.<br /><br />I wrote like this :<br />-------------------<br />DECLARE<br /><br />l_routeto number;<br />l_errordesc varchar2(4000);<br />lc_clob CLOB;<br />LN_COUNT NUMBER;<br /><br />BEGIN<br /><br />IF upper(trim(:P101_USERNAME)) = 'ABC' THEN<br />l_routeto := 1;<br />elsif upper(trim(:P101_USERNAME)) = 'DEF' THEN<br />l_routeto := 201;<br />elsif upper(trim(:P101_USERNAME)) = 'HIJ' THEN<br />l_routeto := 301;<br />else<br />l_routeto := 1;<br />END IF;<br /><br />wwv_flow_custom_auth_std.login<br />(<br />P_UNAME => :P101_USERNAME,<br />P_PASSWORD => :P101_PASSWORD,<br />P_SESSION_ID => v('APP_SESSION'),<br />P_FLOW_PAGE => :APP_ID||':'||l_routeto<br />);<br /><br />exception<br />when others then<br />NULL;<br /><br />END;<br /><br />Please Help...ARhttps://www.blogger.com/profile/18099230810870201544noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-63006203883511686792021-01-21T15:14:19.726+01:002021-01-21T15:14:19.726+01:00Called you Geert... should have been Dimitri
My ap...Called you Geert... should have been Dimitri<br />My apologies.Ronnynoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-25080885080071353502021-01-21T15:12:51.161+01:002021-01-21T15:12:51.161+01:00Hi again,
I already found I need to use this
wwv_...Hi again,<br />I already found I need to use this<br /><br />wwv_flow_custom_auth_std.login(<br /> p_uname => :P9999_USERNAME,<br /> p_password => :P9999_PASSWORD,<br /> p_session_id => v('APP_SESSION'),<br /> p_flow_page => :APP_ID||':2'<br /> );<br /><br />Page 2 is the page I want to end up on.<br />But it doesn't happen. There is no error, just it lands on the home page I guess.<br />Is there anything els e I can look at?<br /><br />thanks<br />Ronny<br />Ronnynoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-12663925737320662232021-01-21T14:09:13.089+01:002021-01-21T14:09:13.089+01:00Hi Geert,
In version 20.1 the code behind apex_aut...Hi Geert,<br />In version 20.1 the code behind apex_authentication.login() no longer seems to have the additional 2 parameters to specify.<br />What is the way to do this in that version?<br /><br />thanks<br />Ronny<br />Ronny EelenRonnynoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-54424001798107113502020-09-09T13:47:41.439+02:002020-09-09T13:47:41.439+02:00In Oracle apex. If i open 2nd page it is opening f...In Oracle apex. If i open 2nd page it is opening fine. again i open 6th page near to that tab by using URL. I am navigating to Home page<br /><br />As i wanted those two pages to linked to other application it is difficult to make it further. Could you suggest me on thisdsfhttps://www.blogger.com/profile/02556560516363349459noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-36359744199739855562017-03-07T13:58:28.581+01:002017-03-07T13:58:28.581+01:00We are at version 5.1.0.00.45.
I have solved my p...We are at version 5.1.0.00.45.<br /><br />I have solved my problem by manipulating the FSP_AFTER_LOGIN_URL (session item?).<br /><br />It not a very elegant solution, but is seems to work.<br /><br />Thank you for help!Geert Engbershttps://www.blogger.com/profile/04756001334589585316noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-56881227102087553092017-03-06T10:56:01.075+01:002017-03-06T10:56:01.075+01:00Hi Geert,
What version of APEX are you using?
Th...Hi Geert,<br /><br />What version of APEX are you using?<br /><br />Thanks,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-3439379859855373022017-03-06T10:01:27.574+01:002017-03-06T10:01:27.574+01:00I have tried both but unfortunately still have not...I have tried both but unfortunately still have not got it to work. The application process does not seem to work whith a Process Point of 'After Authentication'. Changing this to 'On Load: Before Body' does seem to work, but the code to redirect to the change password page throws an error. I am using the htp.init; owa_util.redirect_url procedure to navigate to the change password page.<br /><br />I have the same problem with the post_login procedure. Redirecting using the owa_util.redirect_url does not seem to work.<br /><br />What am I doing wrong?Geert Engbershttps://www.blogger.com/profile/04756001334589585316noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-29741020631257128362017-03-02T16:37:58.572+01:002017-03-02T16:37:58.572+01:00You can have an application process always being f...You can have an application process always being fired that checks if they need to change their password.<br />If so, you redirect them to the password change page.<br /><br />Or you could do that with a post_login procedure in your authentication.Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-11269202095781410332017-03-02T16:29:36.021+01:002017-03-02T16:29:36.021+01:00I want users that have not yet changed their stand...I want users that have not yet changed their standard password to be forced to change it the first time they login. This seems to work fine when the first page they visit is the Login Page (I have added a brank to a Change password page with the condition that looks at the used password and compares this to the standard password). But I also want this same functionality to work when the user selects a url that point to another page (not the login page). As they cannot use that page whitout logging in, the users is first forced to go to the login page. In those situations, the branching in the login page to the Changes Password page is skipped and after logging in the users sees the page the expected. But in those cases the users has not yet changed the standard password. <br />I just cannot get this to work. Any suggestions?Geert Engbershttps://www.blogger.com/profile/04756001334589585316noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-4021451191577309322014-11-11T23:20:27.051+01:002014-11-11T23:20:27.051+01:00Bare with me here.... I am using the Authenticatio...Bare with me here.... I am using the Authentication Scheme using Application Express Authentication. 101 is my login page ... 36 is my change password page. I edited page 36 set the Security -> Authentication = "Page is Public". I click on the Change Password button and it does go to the change password page however when I put in the username = '', Old password = '', New password and confirm password it comes back with Invalid Old Password. I am typing in the correct password for the Old password. For the Old Password field -> Source, Source Used = Always, replacing any existing value in session state, Source, Source Type = Database Column, Source value or expression = 'PASSWORD'. Once I changed the page to public it put "NOBODY" in the User Name field on the change password field. So when I type in an APEX user and the old password new password, confirm the password...it always indicates that the old password is invalid. Anonymoushttps://www.blogger.com/profile/07452612315615834723noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-44171464329952125722014-11-11T22:33:41.032+01:002014-11-11T22:33:41.032+01:00Hi Beverly,
You need to set your page as Public (...Hi Beverly,<br /><br />You need to set your page as Public (in security section of your Page attributes).<br /><br />That way for the reset password page they don't need to login.<br /><br />Hope that helps,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-36307939422231043432014-11-11T21:07:18.739+01:002014-11-11T21:07:18.739+01:00Dimitri,
I just started in APEX. I have a require...Dimitri,<br /><br />I just started in APEX. I have a requirement to add a change password page so that the user can change his/her password if it is expired or if they just want to. I had added a button to the login page and on the login page process had it go to my new change password page. However, it makes the user login first. I don't want the user to have to login. The only way this currently works is that they select the change password button -> login and it does take them to the change password page. I would like to have them push the change password button and have it go directly to the page without having them login. Any ideas? Thanks. Beverly SelbyAnonymoushttps://www.blogger.com/profile/07452612315615834723noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-57648912211275579992014-04-23T13:52:04.816+02:002014-04-23T13:52:04.816+02:00What error did you get? Maybe the page didn't ...What error did you get? Maybe the page didn't exist or has an authorization on?Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-67335275478137266612014-04-23T13:04:32.090+02:002014-04-23T13:04:32.090+02:00My requirement has slight change where different u...My requirement has slight change where different users type should be directed to different pages. So<br /><br />I wrote like this :<br />-------------------<br />DECLARE<br /><br /> l_routeto number;<br /> l_errordesc varchar2(4000);<br /> lc_clob CLOB;<br /> LN_COUNT NUMBER;<br /><br />BEGIN<br /><br /> IF upper(trim(:P101_USERNAME)) = 'ABC' THEN<br /> l_routeto := 1;<br /> elsif upper(trim(:P101_USERNAME)) = 'DEF' THEN<br /> l_routeto := 201;<br /> elsif upper(trim(:P101_USERNAME)) = 'HIJ' THEN<br /> l_routeto := 301;<br /> else <br /> l_routeto := 1; <br /> END IF;<br /><br />wwv_flow_custom_auth_std.login<br /> (<br /> P_UNAME => :P101_USERNAME,<br /> P_PASSWORD => :P101_PASSWORD,<br /> P_SESSION_ID => v('APP_SESSION'),<br /> P_FLOW_PAGE => :APP_ID||':'||l_routeto<br /> );<br /><br />exception<br />when others then<br />NULL;<br /> <br />END;<br /><br />I was able to land into respective pages allocated to Username 'ABC ' and ' DEF ' but got an error when i try to login with username 'HIJ'.<br /><br />Please help me out.<br /><br /><br />Thanks & Regards,<br /> Vikram SAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-45514908591326716892013-05-02T05:55:09.907+02:002013-05-02T05:55:09.907+02:00I agree with your with.Thanks you share with me th...I agree with your with.Thanks you share with me this nice post.Keep it up...Anonymoushttps://www.blogger.com/profile/12553037166481678759noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-8637809259101702532013-04-15T11:30:58.947+02:002013-04-15T11:30:58.947+02:00Actually as soon as I posted my comment I realised...Actually as soon as I posted my comment I realised the page direction was been set by the login page (call to wwv_flow_custom_auth_std.login, p_flow_page)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-10039854126029227882013-04-15T11:27:08.669+02:002013-04-15T11:27:08.669+02:00Thanks for this. I'm having a problem though ...Thanks for this. I'm having a problem though that if someone tries to log in and fail page security, if they press ok and log in with a user who passes page security Apex tries to take them to page 1 (ignoring my settings of page 2). Do you know how to stop this. ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-13548409411168087932013-04-13T13:07:20.698+02:002013-04-13T13:07:20.698+02:00my apex homepage is not working after i run forms ...my apex homepage is not working after i run forms builder and forms application. could you please give solution for this.<br />Thanks in advance.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-91220109153579527722012-07-30T13:22:28.042+02:002012-07-30T13:22:28.042+02:00Hi Dimitri,
I am facing issue on setting up defau...Hi Dimitri,<br /><br />I am facing issue on setting up default page even I have checked my all 3 settings which you have described in this post.<br />My default page should be 7 but sometimes users are redirecting to page 1.<br /><br />Please suggest.<br /><br />Regards,<br />JackJackhttps://www.blogger.com/profile/01789286609221960802noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-7929776171537825202012-07-19T14:05:23.845+02:002012-07-19T14:05:23.845+02:00Worked perfect. thanksWorked perfect. thanksApex -Xhttps://www.blogger.com/profile/06448321310144042191noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-48156790074503356622011-06-27T23:09:11.152+02:002011-06-27T23:09:11.152+02:00Thank you.Thank you.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-55879222062194281162011-03-17T09:21:32.647+01:002011-03-17T09:21:32.647+01:00Thanks for this complete and compact Tip!
Kind Reg...Thanks for this complete and compact Tip!<br />Kind Regards, FrankFrank Schmidthttps://www.blogger.com/profile/01431368240616743269noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-20717247983547559052010-06-09T10:51:47.663+02:002010-06-09T10:51:47.663+02:00Hi,
Making the changes as you said will take me t...Hi,<br /><br />Making the changes as you said will take me to a specific page. But if i want to send user to different pages how can I do that.<br /><br />e.g if user is dummy he should go to page 3 and if user is abc he should go to page 1.<br /><br />How can I achieve this? <br />please respond as soon as possible. <br /><br />Thanks in advance.Unknownhttps://www.blogger.com/profile/01731568460142796059noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-81662799186541757312010-05-19T08:05:50.525+02:002010-05-19T08:05:50.525+02:00thanks, most helpfullthanks, most helpfullAnonymousnoreply@blogger.com