- Administering Data Integration for Oracle Enterprise Performance Management Cloud
- Reviewing Process Details and Viewing Results in the Workbench
- Viewing Process Details
Viewing Process Details
Use Process Details to view the status and logs of a submitted integration.
To view process details:
- From the Data Integration home page, then the Actions drop-down, select Process Details.
To view process details for a specific integration, click to the right of the data integration, and then select Process Details.
- Select the Process ID of the integration to view the status of the submitted integration.
The Process Details page shows the processes executed for the integration. The following columns are displayed for each process:
-
Process ID—A system generated identification number for each submitted integration
-
(Status)—Displays a visual indicator of the process status. You can rest the cursor over the icon to view a Screen Tip.
Available statuses:
-
—Data Integration was processed successfully.
-
—Data integration did not complete successfully.
- —Integration was processed with warnings.
-
-
Log—Click to show the log for the submitted integration. For each integration, the log shows the status, process step, process start time, and process end time.
-
Output File —When an output file has been generated for the integration, a is shown in this field.
An output file is generated when the option to export the data file is enabled. The name of the data file is <target application name>_<process ID>.dat, and it is written to the <application root folder>/outbox directory. If you open the output file from the Process Details page, the output file is available in pdf format. You open or save the output file by clicking .
The output file may also contain a validation error report, which shows rejected data cells, intersections and the rejection reason when you load data. The validation error report option is enabled when the Display Validation Failure Reasons target option is enabled. See Defining Target Options.
When a data load fails during the run integration step, an error message output file is generated and made available in this field. For more information, see Viewing an Error Messages Output File.
-
Process By—User ID of the person who submitted the integration.
-
ODI Session Number—The session number in Oracle Data Integrator. You can use this to look up a session in Oracle Data Integrator.
Note:
The ODI Session number is present in Process Details only when the data is processed during an offline execution.
-
Output
-
Error Message—Shows the reason why a submitted integration failed.
-
Last Execution—Shows the last date the submitted integration was run.
-