Migrating Security in Oracle ERP Cloud

As security and Segregation of Duties (SoD) risks are becoming more scrutinized by the Public Company Accounting Oversight Board (PCOAB) and external auditors, it is increasingly important to establish a clean and compliant security role design in your Oracle ERP Cloud application. Whether you develop custom roles as part of your implementation or redesign security in your existing environment, role design and build may come with its own set of technical challenges – one of which includes role migration.

Like most configurations, custom roles are typically required to flow through the hierarchy of Oracle environments during their development lifecycle (e.g. roles are developed in a DEV environment, moved to a QA/UAT environment for testing, and finally migrated to Production only after they are fully vetted and approved). A major issue security teams face is that role migration in Oracle ERP Cloud can be a very tedious and time-consuming task. In fact, historically there was no feasible way to “migrate” roles at all – rather, security teams were forced to manually rebuild roles from the ground up in each environment.

New Role Migration Functionality

Starting with release 19A, Oracle introduced a new feature allowing users to export and import custom role hierarchies. The export function extracts the role hierarchies in three .csv files that together comprise the role to duty role to privilege mapping. Once exported from your source environment, the roles can be uploaded or imported into your target environment through the same navigation path.  This feature has reduced the level of effort required to migrate custom roles from one environment to another. As an added benefit, eliminating the need to manually recreate role hierarchies also reduces the risk of incomplete or inaccurate role configurations through manual error.

Navigation: Setup and Maintenance > Users and Security > Manage Job Roles > Actions > Export to CSV File or Import from CSV File

Items to Note

  • Using this feature does not require any prerequisite setups
  • The IT Security Manager role has access to this feature
  • You can migrate all custom roles or select only specific roles using available filter criteria

What Can’t be Migrated?

While the feature has dramatically increased the efficiency of migrating roles, there are some limitations around what can be exported and imported.  Some examples include:

  • Data Security Policies: Currently, the export and import utility only migrates the role hierarchy. The utility is not capable of migrating data security policies, which are critical for roles to function properly. This is a known Oracle design gap (#29337499). Unfortunately, this means the data security policies still need to be reconfigured manually for each role after migration between environments.
  • Seeded Roles: The export feature only allows the export of custom security artifacts. You cannot export seeded roles or seeded role to seeded privilege mapping. For example, if a custom job role contains a seeded duty role, the export data will include the job role to duty role mapping but will not contain the seeded duty role to seeded privilege mapping. In any case, it is best practice to never modify seeded security artifacts, so there should not be a requirement to migrate changes to these roles.
  • User Role Mapping: This specific feature does not support the export and import of user role assignments. Fortunately for teams going through a security design or redesign, the HCM data loader tool can be leveraged for this time-consuming task.

Conclusion

While the ability to migrate role hierarchies has been improved, the tool’s inability to migrate data security policies leaves significant challenges for organizations that need to build custom roles. Many teams who have leveraged the tool are left feeling as if the feature is incomplete or “half-baked” – and it has been nearly a year since Oracle has revisited the tool’s functionality.

To increase visibility of this issue, security teams who may require this functionality (or just want to help those that do) are encouraged to vote for the enhancement. If you would like to vote, visit the Oracle Cloud Customer Connect page and click the green thumbs up button. (If the link does not take you directly to the idea page, enter the idea number DF96E33E07 into the search box). Hopefully Oracle will hear us and include the functionality in a future release.

To learn more about how Protiviti can help with Oracle security, please visit our Oracle Solutions site or contact us.

 

Sriram Chandran

Senior Manager
Technology Consulting - Enterprise Application Solutions

Kristin Jenison

Senior Manager
Enterprise Application Solutions

Subscribe to Topics

Protiviti’s Sharon Stufflebeme and Ramesh Gupta share advice in @InformationWeek with organizations looking to update #LegacySystems and adopt the right amount of #EmergingTechnology to balance business needs. http://ow.ly/Jcpv50Nqlp0 #ProtivitiTech

We understand the challenges organizations face regarding #DataManagement and security. A structured data protection approach centered around people, processes and technology can help you tackle those challenges. Learn more: http://ow.ly/S93G50NqpNv #ProtivitiTech #Data

What is the #Metaverse? What does it mean for business? And how should companies prepare? @Protiviti’s Kim Bozzella tells @Forbes why now is the right time for businesses to leverage this immersive technology. http://ow.ly/ng6950NoAIS #ProtivitiTech

Is your organization post-quantum ready? Join Host @KonstantHacker for a chat with Skip Norton of @QuintessenceLab about real products available today that will be ready for post-quantum #encryption by 2024. http://ow.ly/GUvS50NpzX9 #QuantumComputing #ProtivitiTech

Maximize the value of your organization's #Data by building a modern enterprise #DataArchitecture. Find out how to get started with Protiviti's latest whitepaper: http://ow.ly/aQsZ50NpyBN #ProtivitiTech

Load More