Saturday, January 30, 2010

Look, But Don't Touch

Joel Kallman had an interesting post about a customer who broke all of the rules and modified some constraints in the APEX_030200 schema.  In this case, there was a happy ending, as Joel went the extra mile to craft a custom patch to remedy the issue.  However, things don't always end up this way.

This reminds me of my early days with Oracle, when I used to work with the eBusiness Suite.  The first page of any documentation of the suite said something like this: "WARNING: Do not use SQL*Plus to modify any database object directly".  We used to laugh at this, as we used SQL*Plus & TOAD to modify these database objects several times a day, if not more frequently.

However, this was done on internal systems used to build demos.  If we messed something up - and boy did we ever - we could easily refresh the instance with little effort.

Fast-forward a few years to today:  FND & APPLSYS have been replaced by a single, much smaller schema called APEX_030200.  Despite this, the same rules apply:  NEVER modify anything in the APEX_030200 schema.  Period.  I always make it a point to emphasize this as much as possible during our training classes.

Now, if you MUST take a look at that schema - and many of you reading this will - please do it in a test environment that is not used for anything else.  This can easily be done by using VMWare or one of the many other virtual machine programs.  You can also do this in the Amazon Cloud.  It doesn't matter as much WHERE you set up a test instance, but rather that you DO set up a test instance, and then poke around there.  This way, nothing gets corrupted - now or in the future.

Wednesday, January 27, 2010

Introducing Sumneva

Early this morning (and well before the iPad), we launched a new company called Sumneva.

Sumneva (sum-NEE-va) is the collaborative effort between Sumner Technologies and APEX Evangelists. Since we were basically doing the same things in different parts of the world, we unanimously agreed that we would be able to cover more ground together. Thus, Sumneva was formed!

We have a lot of exciting plans that we're going to be implementing - starting with the best kind - FREE! We're hosting APEX 4.0 preview web seminars, where we can show you what to expect in the much-anticipated APEX 4.0. We're also planning to have monthly "Ask the Experts" web seminars, where you'll get to interact with all four us of over a live conference call.

In addition to the new services we're offering, we've also combined our training curriculum and have a number of new additions in our course catalog to offer both publicly and privately.

Now that the iPad announcement is done, come on over to sumneva.com and have a look!

Wednesday, January 20, 2010

ODTUG 2010 Registration Open

ODTUG 2010 promises to be the best ever, with close to 40 APEX sessions - many of which will focus on APEX 4.0!

There's also a lot of new & innovative ideas this year that have not been done in the past:
  • APEX Sunday Symposium
    In the past, the Sunday Symposiums have been less technical and more business and case study focused.  Well, that all changes this year, as we have a lineup that can't be matched!  This year, we have invited some of the top names in the APEX community to team up and show you how to design, develop, deploy, tune, secure, beautify and translate an application - right before your eyes!  Also, for the first time, you can sign up just for the Sunday Session - which makes it nice if you're local to DC and can't get the full time off for the bulk of the conference.

  • APEX Plugin Workshop
    Since APEX Plugins will dramatically change the way in which we build APEX Applications, we've decided to have a 1 1/2 hr session that focuses on this new amazing feature.  As an added bonus, you'll get to take the code used home with you!

  • APEX Open Mic Night
    Didn't get your presentation accepted or just have something cool you'd like to show off?  Then bring it to APEX Open Mic Night.  We'll give you 10 minutes and a laptop connected to the Internet; you do the rest.  Leave you slides at home, as this evening is demo-only!
You can register for ODTUG 2010 here: http://odtugkaleidoscope.com/registration.html

Hope to see you there!