groupAssignmentAuditReport

Creates a report listing users and groups that were assigned to or unassigned (removed) from IDCS and EPM groups for a specified number of days or a date range. This report can list the assignments and unassignments for a maximum of 14 days for IDCS groups and 120 days for EPM groups.

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 Fusion Cloud Enterprise Data Management, Narrative Reporting, Strategic Workforce Planning, and Sales Planning.

Required Roles

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

Usage

epmAutomate groupAssignmentAuditReport [nDays=NUMBER_OF_DAYS] [from_date=FROM_DATE to_date=TO_DATE] report_name=REPORT_NAME.csv, where
  • nDays, optionally, is the number of days, starting from today's date, for which the report is to be generated. Use this option to generate the report for a specific number of days.
  • from_date, optionally, is the start date of the period, in YYYY-MM-DD format, for which the report is to be generated.
  • to_date, optionally, is the end date of the period, in YYYY-MM-DD format, for which the report is to be generated.

    Note:

    Oracle Fusion Cloud Enterprise Performance Management ensures that only valid date range is used during report generation. These validations are performed for the nDays, from_date, and to_date values:
    • You must specify either ndays or a date range using the from_date and to_date parameters.
    • 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.
  • report_name is the name of a CSV file for the report. You can download the generated report using the downloadFile command.

Examples

  • Generating the report for a number of days:

    epmAutomate groupAssignmentAuditReport ndays=45 GroupAssignmentReport.CSV

  • Generating the report for a date range:

    epmAutomate groupAssignmentAuditReport from_date=2026-06-01 to_date=2026-09-30 GroupAssignmentReport.CSV