My Oracle Support Banner

User Role Assignments is Dropped During Export / Import of the APEX Application (Doc ID 2505456.1)

Last updated on FEBRUARY 11, 2021

Applies to:

Oracle Application Express (APEX) - Version 5.1.4.00 and later
Information in this document applies to any platform.

Goal

Why User Role Assignments associated with Application Access Control are dropped when an application which includes "User Role Assignments" is exported and then imported?

The following steps show the issue:

1. Create a simple application
2. Create a Role in Shared Components > Application Access Control
3. Assign the role to a user, it is shown at "User Role Assignments" section in the same page.
4. Export the application
5. Import it
6. Confirm the imported new application drops "User Role Assignments" which were created  at step 3.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.