Forum Stats

  • 3,836,764 Users
  • 2,262,185 Discussions
  • 7,900,102 Comments

Discussions

Bug: import Nav menu list component removes menu list

Edwin van Meerendonk
Edwin van Meerendonk Member Posts: 194 Bronze Badge
edited Sep 9, 2018 8:31PM in APEX Discussions

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

Tagged:

Answers

  • Scott Wesley
    Scott Wesley Member Posts: 6,226 Gold Crown
    edited Sep 9, 2018 8:31PM

    I've experienced similar issues with component export of lists, and more recently, global page.

    Importing these shared components must have some internal reference problem, and would take extreme care.

    I wouldn't rule this out for other shared components, like LOVs and Authorisation Schemes, but I'm not sure if it's expected behaviour.

This discussion has been closed.