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!

User Role Assignments are getting deleted while importing an APEX Application

SandipanMar 24 2025

While trying to import an Application from one environment to another, the existing user role assignments are getting deleted in target environment.

Is it an expected behavior?

We have multiple APEX environments including Sandbox, DEV, UAT and PROD. Each environment has different set of Application users and their role assignments. For any application upgrade (enhancement) when we are trying to export and import it to a higher environment, the existing user role assignments are getting deleted. We had to create everything from scratch. For UAT and PROD there are many more users who are continuously using the applications across the globe.

As an workaround we used to take back up of existing user role assignments, prepare script using APEX_ACL and execute after Import.

But, I don't think it's a best practice and right way to do so.

Any idea how to avoid this problem?

This post has been answered by Michael_A on Jul 24 2025
Jump to Answer
Comments
Post Details
Added on Mar 24 2025
4 comments
246 views