Viewing Processing Details for Rules or Jobs Executed

After running a job in Data Management, view the Process Details in Data Management to check the status of Data Management jobs. If cells are rejected during a data load, view the submitted rule status and logs and download the validation report to try to resolve the issue.

Note:

Process Detail logs automatically clear every seven days.

To view data rule process details:

  1. Click the Navigator icon Screenshot of the Navigator icon in NSPB, and under Integration, select Data Management.

    The Data Management window displays.

  2. On the Workflow tab, under Monitor, click Process Details.

    The Process Details page displays and shows processes for all source systems.

    The following details display for each process in the upper pane:

    • Process ID – An automatically generated identification number.

    • Status – Displays a visual indicator for the status of the process. You can rest the cursor over the icon to view a Screen Tip. The statuses available are:

      • Green check mark icon that indicates the rule processed successfully. – Rule Processed Successfully

      • White x in red circle icon that indicates the rule did not execute successfully. – Rule Execution did not complete successfully

    • Log – Click Show to download the log file.

      Tip:

      If a process status is White x in red circle icon that indicates the rule did not execute successfully., you should download and review the log file to investigate what went wrong.

    • Location – Displays the location name.

    • Process Name – The type of process. For example, the job executed can be Data Load.

    • Rule Name – The name of the rule.

    • Source System – The name of the source system.

    • Target Application – The name of the target application.

    • 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.

    • Processed By – The user ID who initiated the process.

    • Link – Shows the log information for the process step.

      In the case of File Import, it shows skipped rows, and in the case of export to Planning, it shows rejected rows and so on.

    • Output File – Download the validation error report that shows the data cells that were rejected during the data load and the reasons for the rejection.

      A validation error report is only available when the Display Validation Failure Reasons option is set to Yes.

  3. Select a process from the upper pane update the details that are displayed in the lower Process Step pane.

    Note:

    Notice the search fields above the column headers for some of the details (Process ID, Location, Rule Name, Source System and Target Application). You can enter keywords in the search fields to filter the rows that are displayed based on your search.

    The text or partial text that you enter is case sensitive. For example, to find all target applications prefixed with HR, you cannot enter Hr or hr.

  4. Review the following details of the process under Process Step:

    • Status– For each process step, the status is displayed. You can troubleshoot a problem by viewing at which point the process failed.

    • Process Step– Displays the steps in the process.

    • Process Start Time – Time that the process step started.

    • Process End Time – Time the process step ended.

General Notices