groupAssignmentAuditReport

Creates a report listing users and groups that were assigned to or unassigned (removed) from IDCS and EPM groups for a specified date range. This report can be generated for a maximum of 120 days.

This report, which is generated as a CSV file, can be used to support security audit operations. Each row of the generated CSV file provides the user or group that was added or removed, the group to which the user or group was added or removed from, the group type, the Service Administrator who performed the action, and the date and time when the action was completed.
Sample Group 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, Strategic Workforce Planning, and Sales Planning.

Required Roles

  • Service Administrator
  • Any predefined role and the Access Control - Manage granular role
  • Any predefined role and the Access Control - View granular role

Usage

epmAutomate groupAssignmentAuditReport FROM_DATE TO_DATE REPORT_NAME.csv where
  • FROM_DATE is the start date of the period, in YYYY-MM-DD format, for which the report is to be generated.
  • TO_DATE is the end date of the period, in YYYY-MM-DD format, for which the report is to be generated.
  • REPORT_NAME is the name of a CSV file for the report. You can download the generated report using the downloadFile command.

Note:

Oracle Fusion Cloud Enterprise Performance Management ensures that only valid date range is used during report generation. These validations are performed for the from and to dates:
  • The FROM_DATE cannot be earlier than the allowed maximum retention period (120 days) from the current date.
  • The TO_DATE cannot be later than the maximum retention period from the FROM_DATE.
  • The TO_DATE cannot be earlier than the FROM_DATE.

Example

epmAutomate groupAssignmentAuditReport 2025-10-01 2026-01-10 GroupAssignmentReport.CSV