Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bug: import Nav menu list component removes menu list

Edwin van MeerendonkSep 7 2018 — edited Sep 9 2018

This looks like a bug to me or am I missing something:

We have relative large applications, so we export/import pages and components and not entire applications.

Let's take an UT application with a list in the User interface/Desktop settings Navigation Menu list.

- Export this list via Application Component export

- Import the list again. 

In the user interface settings the menu list has been decoupled. You have to select the imported list by hand, which is "undesirable" in production

Small analysis ( by a trace of the import):

The CREATE_LIST API seems to delete the list from WWV_FLOW_LISTS

The FK on WWV_FLOW_USER_INTERFACES.NAVIGATION_LIST_ID is defined as an ON DELETE SET NULL

So the deletion of the list nullifies the FK in the user-interface, and the API doesn't correct this nullification after creation of the list.

APEX 5.0.3

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2018
Added on Sep 7 2018
1 comment
236 views