exportAppAudit

Exports data audit records into a ZIP file, which you can download and archive on a local computer. Audit information for up to 365 days is available in the environment. You can generate this report for a number of days or a date range.

The first character in the output CSV file is the Byte Order Mark (BOM) character \ufeff followed by an encrypted application identifier enclosed in double quotes. CSV file header follows the application identifier.

Applies to

Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Enterprise Profitability and Cost Management, Strategic Workforce Planning, and Sales Planning.

Required Roles

  • Service Administrator
  • Any application role and Audit - Manage granular role
  • Any application role and Audit - View granular role

Usage

epmautomate exportAppAudit EXPORT_FILE_NAME [userNames=USER_NAMES] [nDays=NUMBER_OF_DAYS] [startDate=START_DATE endDate=END_DATE][excludeApplicationId=true|false] [maxNumberOfRecordsPerFile=MAX_RECORDS_IN_FILE], where:
  • EXPORT_FILE_NAME is the name of the ZIP file that will store the exported audit data. This ZIP file will contain one or more CSV files depending on the value you set for the maxNumberOfRecordsPerFile parameter and the total number of audit records in the environment. You can use the downloadFile command to download files from an environment.
  • userNames, optionally, is a comma separated list of user login names. If specified, only the audit data created by these users will be exported. Do not specify this value if you want to export the audit data for all users.
  • nDays, optionally, identifies the number of days for which audit records are to be exported. Default is seven days. Possible values are: all to export available audit data for the last 365 days, 1, 2, 7, 30, 60, and 180. Do not specify this value if you are generating the report for a date range.
  • startDate and enddate, optionally identify the start and end dates for which audit records are to be exported. These values must be specified in YYYY-MM-DD format.
    • Start date must precede the end date. Both start and end date must be specified to generate a report.
    • These dates should not be future dates.
    • These dates are ignored if the nDays optional value is specified
  • excludeApplicationId, optionally identifies whether the application identifier is to be written to the export file. Default is false.

    Note:

    Data from exported files that do not contain the application identifier cannot be imported into Oracle Fusion Cloud Enterprise Performance Management environments.
  • maxNumberOfRecordsPerFile, optionally, identifies the maximum number of audit records to include in each export CSV file. This value must be between 100,000 and 1,000,000. Default is -1, which creates one CSV file containing all audit records. While exporting a large volume of audit records, use this parameter to limit the number of records in each CSV file to a number that Microsoft Excel can open in a worksheet. Generated CSV files are included in the ZIP file identified by the EXPORT_FILE_NAME parameter.

    Note:

    Export files are named based on the EXPORT_FILE_NAME value. If multiple CSV files are created, the file names follow EXPORT_FILE_NAME_1. EXPORT_FILE_NAME_2, EXPORT_FILE_NAME_n naming format.

Examples

  • Export audit data of the specified users from the last 30 days with the application identifier:

    epmautomate exportAppAudit auditData userNames=johnDoe,jane.doe@example.com ndays=30

  • Export audit data of the specified users from the last 30 days without the application identifier:

    epmautomate exportAppAudit auditData userNames=johnDoe,jane.doe@example.com ndays=30 excludeApplicationId=true

  • Export August 2024 audit data of all users with the application identifier:

    epmautomate exportAppAudit auditData startDate=2024-08-01 endDate=2024-08-31