1. User's Guide
  2. Smart View and EPM Cloud
  3. Monitoring Job Status
  4. About the Job Console

About the Job Console

The Job Console displays the status of ongoing and completed jobs in Oracle Enterprise Performance Management Cloud.

Data source types: Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Tax Reporting

In Oracle Smart View for Office, you can do the following the Job Console:

  • You can view the status of jobs in the Job Status column.
  • You can filter the list of jobs as per their job type (for example, Clear Cell Details, Copy Data, Refresh Database, Rules, Data Map, or Smart Push), job name, status (for example, Completed, Completed with Errors, Error, Cancelled, or Processing), user executing the job, and start and end dates of jobs.
  • You can view the details of a job.
  • You can delete a job from the list, if required.
  • You cannot cancel or start jobs from the Job Console.

Starting Smart View 23.200, you can also view the substatus for ongoing jobs in the Job Status column. With the substatus information, you can:

  • Track the real-time progress of a job. This helps you stay informed, especially for jobs that run for long durations.
  • Get a better understanding of the ongoing activities. By receiving substantial information about ongoing jobs upfront, you save time and efforts required to open the details of each individual job.
  • Easily identify where a job is blocked or running slower than usual. This helps you understand incompatibilities within jobs, take quick actions, and improve job processes.

For jobs with no child jobs, the status appears in the format of Job Status: [Sub_Status]. For example, Processing: Merging Data

For parent-child job relationships, the substatus appears in the following format:

  • The parent job displays the ongoing child job. For example:

    Processing: [Executing Child Job 1 Of 1: %CHILD_JOB_NAME%]

  • Each child job displays the specific operation being performed as part of its execution. For example:

    Processing: [Step 3 Of 5: Fetching source data]

  • If a cube is busy with the current job, a Waiting indicator is appended to the status. For example:

    Processing: [Step 5 Of 5: Clearing and pushing data to target[Waiting].]

After a job is completed successfully, the substatus is cleared. However, if the job encounters any errors, then the job status and substatus where the error occurred continues to display, instead of getting cleared. For example, Error: [Step 2 Of 5: Fetching target data].

Video

Your Goal Watch This Video

Learn about basic Smart View functionality related to Planning, including a brief discussion on monitoring job status. Concepts are also applicable to Financial Consolidation and Close and Tax Reporting.

Video icon Entering and Saving Plan Data in Smart View with Oracle Planning and Budgeting Cloud