User Audit Report (v1) (Deprecated)

Generates a user audit report in the system and writes the report to the filename provided. 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. The report contains the details regarding the users logged into the system in a given time range.

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

This is an asynchronous command, so use the job status URI to determine whether the operation is complete.

Note:

Oracle Fusion Cloud EPM ensures that only valid date range is used during report generation. These validations are performed for the start and end dates:

  • The start date cannot be earlier than the allowed maximum retention period (120 days) from the current date.

  • The end date cannot be later than the maximum retention period from the start date.

  • The end date cannot be earlier than the start date.

Required Roles

  • Service Administrator

  • Any predefined role and the Access Control - Manage granular role

  • Any predefined role and the Access Control - View granular role

REST Resource

POST/interop/rest/{api_version}/reports? q=%7Btype%3Auserauditreport%2CfileName%3Auseraudit%20report.csv%2Csince%3A2025-04-01%2Cuntil%3A2025-04-31%7D

Table 13-86 Tasks for User Audit Report

Task Request REST Resource
User Audit Report POST

/interop/rest/{api_version}/reports? q=%7Btype%3Auserauditreport%2CfileName%3Auseraudit%20report.csv%2Csince%3A2025-04-01%2Cuntil%3A2025-04-31%7D

Request

Supported Media Types: application/x-www-form-urlencoded

The following table summarizes the request parameters.

Table 13-87 Parameters

Name Description Type Required Default
fileName File where report is to be populated Query Yes None
since Report generation start date Query Yes None
until Report generation end date Query Yes None
type Type of report being generated, provisionreport or userauditreport Query Yes None

Response

Supported Media Types: application/json

Table 13-88 Parameters

Parameters Description
details In case of errors, details are published with the error string
status See Migration Status Codes
links Detailed information about the link
href Links to API call
action The HTTP call type
rel Can be self and/or Job Status. If set to Job Status, you can use the href to get the status of the import operation
data Parameters as key value pairs passed in the request

Example of Response Body

{
   "links": [
      {
         "rel": "self",
         "href": "https://<BASE-URL>/interop/rest/{api_version}/reports?q={type:userauditreport,fileName:useraudit 
report.csv,since:2017-12-10,until:2018-06-10}",
         "data": null,
         "action": "POST"
      },
      {
         "rel": "Job Status",
         "href": "https://<BASE-URL>/interop/rest/v1/reports/3180621025673301",
         "data": null,
         "action": "GET"
      }
   ],
   "status": -1,
   "details": null
}

Sample cURL Command Basic Auth

curl -X POST -u '<USERNAME>:<PASSWORD>' -H 'Content-Type: application/x-www-form-urlencoded' 'https:///<BASE-URL>/interop/rest/v1/reports?q=%7Btype%3Auserauditreport%2CfileName%3Auseraudit%20report.csv%2Csince%3A2025-04-01%2Cuntil%3A2025-04-31%7D'

Sample cURL Command OAuth 2.0

curl -X POST --header "Authorization: Bearer <OAUTH_ACCESS_TOKEN>" -H 'Content-Type: application/x-www-form-urlencoded' 'https://<BASE-URL>/interop/rest/security/v1/reports?q=%7Btype%3Auserauditreport%2CfileName%3Auseraudit%20report.csv%2Csince%3A2025-04-01%2Cuntil%3A2025-04-11%7D'