As you probably know, in our industry nothing stays the same for long. Less than six months ago I posted about this topic and provided screen shots of the Microsoft UI for registering an application. That UI has been deprecated, due to be gone shortly. I also found that it lacked some of the features that can be found in the MS Azure portal. So, here is a revision to my January 31, 2019 post. My co-worker Adrian Png has written a few great posts on social sign-on with APEX. I'd like to provide a quick cookbook with some interesting details here. If you get a chance, take a look at Adrian's po ..read more

 I had someone ask me how to get the think time after someone views an Interactive Report. I think the query below does it. with page_views_with_previous_view_id as    (select application_id, page_id, apex_user, apex_session_id, page_view_type, view_timestamp,            lead(view_timestamp, 1) OVER (ORDER BY view_timestamp desc) AS prev_view_ts     from apex_workspace_activity_log al     where application_id = :APP_ID     )   select pv.*,          pv.view_timestamp - ppv.view_timestamp thi ..read more

I can't say for certain that this came up during the 19.1 to 19.2 upgrade. It is possible it showed up during an earlier upgrade but that it was just caught during regression testing from 19.1 to 19.2. In any case, you may come across the following APEX error in an Interactive Report region (and possibly other places): report error:ORA-20001: Error fetching column value: ORA-20987: Invalid LOV type specified. The debug error stack might include: Error Stack: ORA-20001: Error fetching column value: ORA-20987: Invalid LOV type specified.Backtrace: ORA-06512: at "APEX_190200.WWV_RENDER_REPO ..read more

I just finished giving my first presentation at RMOUG Training Days 2019. So far it has been a great event. The venue is very nice and convenient. The presentations cover interesting topics and are presented by experts. The organization has been flawless. A big thank you to the RMOUG team. During my presentation I mentioned that I would provide a link to the artifacts of my presentation on this blog...so here it is: https://github.com/ainielse/rando/tree/master/peer_review There are three files: The presentation itself (a_nielsen_peer_code_rmoug.pptx) An APEX application for tracking peer ..read more

Sorry for the brevity, but I hope this helps someone. If you have configured APEX Social Sign-In with Google, Facebook, Okta, Azure--pick your poison--you may have struggled with figuring out what user information is available to you. If you know the name of the value you are looking for, it is pretty easy to get, but figuring out just what is being returned is not documented anywhere (at least not that I can find). So, here is what you can do... Create an application item A_SOCIAL_INFO Edit your Social Sign-In authentication scheme and add the following pl/sql  procedure post_authent ..read more

How much is a click worth? I was recently asked if I could have an APEX form page load automatically when an Interactive Report (IR) resulted in exactly one row returned. I spent about 5 minutes coming up with a solution, followed by about 15 minutes working with Jorge Rimblas to improve my solution. This assumes you are using an IR with the link built within the IR Attributes. To do this with your own column you need to set a Static ID and use that in place of "LINK" in the code below. Create a Dynamic Action (DA) It will be On Refresh of your IR And it will have the Client-side Cond ..read more

I've recently had the opportunity to reflect on what makes a great, not just good, but great Oracle APEX consultant. Michael, a principal at C2, recently announced that he's moving on to another opportunity. Michael has been with C2 for over a decade and we will miss him--though we're certain we'll stay in touch. Over the years I've seen many a client shed a tear, literal salty trembling teardrops, when Michael rolled off a project. It's part of the consulting life cycle--if we do a project correctly, we eventually hand it off and move on. I've seen those same clients rejoice when Michael retu ..read more

My co-worker Adrian Png has written a few great posts on social sign-in with APEX. I'd like to provide a quick cookbook with some interesting details here. If you get a chance, take a look at Adrian's posts: https://fuzziebrain.com/content/id/1709/ https://fuzziebrain.com/content/id/1711/ Here is the quick cookbook. Let's assume your APEX url is https://myapex.com/ords/ Log in to the Azure registration portal https://apps.dev.microsoft.com/ and click "Add an app" Enter a name and click "Create" Click "Generate New Password" COPY THAT PASSWORD! You won't have another chance! hbU ..read more

A ..read more

A ..read more