Export Audit

Exports the audit records to a Comma Separated Values (CSV) file. The output CSV file contains the first character as a Byte Order Mark (BOM) character \ufeff. The API writes an encrypted application identifier following the BOM character. This application identifier is written between double-quotes. Headers for the CSV file follow the application identifier. For more information, see Auditing Tasks and Data.

You can use an optional excludeApplicationId parameter to not write the application identifier in the export file. Exported audit reports without the application identifier cannot be imported back into the application.

The generated CSV file is compressed and the output is a ZIP file. The file can be downloaded using the Download REST API.

Required Roles

Service Administrator

Using this REST API requires prerequisites, such as understanding how to use jobs. See Prerequisites. Be sure that you understand how to use jobs as described in Managing Jobs.


Supported Media Types: application/json


The following table summarizes the client request parameters specific to this job. For additional parameters that are common to all jobs, see Execute a Job.

Table 8-26 Parameters

Name Description Required Default
jobType Export Audit Yes None
jobName The job name to be used for this job execution. Example: ExportAudit No Export Audit
userNames Comma separated user names. Audit records created by only the specified users are exported. If not specified, audit records created by all users are exported. No None

The name of the file to which records should be exported. The file containing the exported data is stored in the Oracle Planning and Budgeting Cloud repository.

If fileName is not specified, a file is auto-generated with a name containing the user name, current date, and time stamp. For example, test_admin_AuditRecords_2019-02-26-04-34-45-420.zip

No The file name is auto-generated
nDays Number of days for which audit records should be exported.

Possible values are:

  • 1: Export audit records for the last 24 hours
  • 2: Export audit records for the last two days
  • 7: Export audit records for the last seven days
  • 30: Export audit records for the last 30 days
  • 60: Export audit records for the last 60 days
  • 180: Export all existing audit records for the last 180 days
  • All: Export all audit records

    Note: Audit information is maintained for up to 365 days from the current system date.

No 7

Optionally, you can specify if the application identifier should be written in the export file.

Possible values: true or false

This parameter can benefit those customers who do not want the application identifier to be included in the export file to help import into their own systems. This export file cannot be used to import into an EPM Cloud environment.

No false


  • This job does not export records based on group names.
  • If a user name contains a comma, escape the comma in the request. For example, if a user name is test,User then add test\\,User to the request.

For a sample URL, see Sample URL and Payload in Execute a Job.

Sample Payload

Example 1: Exports the last 180 days of audit records to the ExportAuditLast180Days.zip file.

    "jobType": "Export Audit",
    "jobName": "Export180DaysAudit",
    "parameters": {
        "fileName": "ExportAuditLast180Days.zip",
	      "ndays": "180"

Example 2: Exports the last seven days of audit records created by planner1 and planner2. Records are exported to a zip file with an auto-generated file name.

    "jobType": "Export Audit",
    "jobName": "AllAuditRecordsOfPlanners",
    "parameters": {
	     "userNames": "planner1, planner2"

Example 3: Exports the last 180 days of audit records to the ExportAuditLast180Days.zip file. The application identifier will be not written in the generated file. This export file cannot be used to import into an EPM Cloud environment.

    "jobType": "Export Audit",
    "jobName": "Export180DaysAudit",
    "parameters": {
        "fileName": "ExportAuditLast180Days.zip",
	  "ndays": "180",
        "excludeApplicationId": "true"