The upgade from 4.0 to 4.2 went fine, existing applications work, Builder works fine. But none of the packaged applications install, all of them fail with that error. Is there some post-upgrade step to complete to get this to work?
Also, it doesn't appear like we can select the application id when installing these applications! Our environment has a convention, of sorts, for application ids. Is there a way to over-ride the app id?
To be honest I hadn't heard it was an issue until your post... Maybe someone from Oracle can jump in on that one... Sounds kinda weird to me.. Why they'd limit the application ID, unless its part of the locked/unlocked status off the sample applications..
When they talked about sample applications at KScope 2012, they made it sound like, you can install and run the sample apps, but once you unlock them, Oracle will NOT support the app..
Did you unlock the sample app that you want to modify the App ID on?
I had not played with these packaged apps during the Beta/EA phase either. I just assumed that clicking the Install button would go through the standard Builder wizard which lets you override the application id, database schema, supporting objects, etc. But when I tried this on apex.oracle.com, it offered just 1 prompt (a dropdown for Authentication Scheme with just 1 choice, Application Express accounts, so it's not really a choice) and that's it. It just installed the application in the default schema for the workspace, no chance to override anything.
I don't know what you mean by unlock the sample app. All I see when I click on the application name is a big blue Install button.
Seems to me that Oracle put in so much effort in building all these great-looking sample applications, some design effort could have been spent on the installation process. It would be a shame if folks ended up not reviewing these apps because of minor issues like these. Hope the APEX team is reading this thread.
In a way they do...
... There are two main types of applications, Productivity Applications and Sample Applications.
The productivity applications are locked by default and in their locked state are fully supported. However, these applications can also be unlocked to allow developers to customize the application or simply look at how it was made.
So in that sense, what you are wanting to do, modify the App Id, might be under the realm of customizing the application...
Once you have installed the applications.Go to Packaged Applications. Click on the applications. There will be a button Manage. Click on that and then you will see Unlock option.
Select that and proceed. It will unlock and you will be able to modify the application.
Patch 14749720 does not address the issue of being unable to install packaged applications, the install still throws the error begin wwv_flow.g_import_in_progress := true; end; ORA-01003: no statement parsed
This is on Oracle 11.1, APEX 4.2.0.00.27 with patches 14749720 and 14784118 installed.
Can someone from the APEX team please comment on what it would take to get packaged applications to install?