Tuesday, September 20, 2011

APEX Application Export from SQL Developer (issue)

I just deployed an APEX Application from one development to a test server. Therefore I used the great "Database Unload" feature of SQL Developer: it generates a script with all DDL and data - or a subset if you wish. I also used the "Quick DDL" option for creating a APEX Export file from with SQL Developer. Installation was a breeze, just run those two scripts and you're done...
You think...
But then I noticed something strange...in my Interactive Reports I only saw the ID's of the foreign key columns, instead of the description. And it wasn't just one, it was all over the place! It seemed that the SQL Dev export didn't handle the IR-columns that are defined as "Display as Text (based on LOV)" with a Named List of Values properly. The Named List of Values was just missing from the column definition. I don't know if this is solved in version 4.1 (as I was running 4.0.2 on this box), but be aware...
Also - and that may be more obvious - the Supporting Objects aren't exported either. So a little tip of advice here: Use the export functions of APEX itself....

Post a Comment