In OCI (Gen 2) environments, creates an audit report that lists the changes made to predefined and application role assignments over a period of time (maximum last 90 days). This report lists the User Login Name for which a role change (in Action column) was made. It also includes the role that was assigned or unassigned, the user who performed the role change (Administrator column), and the timestamp (UTC) when the action was completed.

Sample Role Assignment Audit report

Information on deleted users who were previously assigned to predefined roles in the environment is listed with the display name (first and last name) of the user in the User Name column. In such cases, the Role column indicates the predefined role that the user had before the user's account was deleted. This change does not apply to application roles, if any, that was assigned to the deleted user; such assignments are shown with the User Login Name of the user. For an example, see the information in the red box in the following illustration.

Sample Role Assignment Audit report

Applies to

Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Account Reconciliation, Profitability and Cost Management, Enterprise Profitability and Cost Management,Oracle Enterprise Data Management Cloud, Narrative Reporting, Oracle Strategic Workforce Planning Cloud, and Oracle Sales Planning Cloud.

Required Roles

Service Administrator


epmAutomate roleAssignmentAuditReport FROM_DATE TO_DATE FILE_NAME.CSV, where:

  • FROM_DATE indicates the start date (in YYYY-MM-DD format) of the period for which the report is to be generated.
  • TO_DATE indicates the end date (in YYYY-MM-DD format) of the period for which the report is to be generated.
  • FILE_NAME is the name of a CSV file for the report. You can download the generated report using the downloadFile command.


This report can be generated only for the last 90 days.


epmAutomate roleAssignmentAuditReport 2021-06-01 2021-07-30 RoleAuditReport.CSV