Execute Reports for Data Management

The Data Management reporting framework represents a unified solution that incorporates source and target data, templates, and user-defined SQL queries. Templates, created in Oracle Business Intelligence Publisher, consume data in XML format and generate reports dynamically. You can add SQL queries to extract data from tables, or couple them with the report parameters to extend the definition of a standard report. Data Management reports can be generated as PDF, Excel, Word, or HTML output.

Required Roles

Service Administrator, Power User

REST Resource

POST /aif/rest/{api_version}/jobs


Supported Media Types: application/json

The following table summarizes the client request.

Table 10-11 Parameters

Name Description Type Required Default
api_version Version of the API you are working with, such as V1 Path Yes None
jobType The job type, REPORT Path Yes None

The name of the report to be executed, such as Dimension Map For POV (Dimension, Cat, Per)

Path Yes None
reportFormatType The file format of the report, pdf, xlsx, html, or excel Path Yes pdf
parameters Can vary in count and values based on the report Path Yes None
Location The location of the report, such as Comma_Vision Path Yes None

Example of Request Body

The following shows an example of the request body in JSON format.

"jobName":"Dimension Map For POV (Dimension, Cat, Per)",
  	 "Dimension Name":"ENTITY",

For sample code, see the code samples included in Running Data Rules.


The following table summarizes the response parameters.

Table 10-12 Parameters

Name Description


The process ID generated in Data Management for the job, such as 1885


The job status, such as RUNNING


Log file containing entries for this execution, such as outbox\logs\BESSAPP-DB_1885.log


Name of the output file generated; you can use this name to download the report


Type of process executed, EXECUTE_REPORT


Login name of the user used to execute the rule, such as admin


Returns the exception stack trace in case of an application error, or null

Supported Media Types: application/json


Example of Response Body

The following shows an example of the response body in JSON format.


For sample code, see the code samples included in Running Data Rules.