Skip to Main Content
Forums

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

Scott Wesley

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.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 7 2018
Added on Sep 7 2018
#apex-discussions, #bug, #component, #export
1 comment
240 views