Jobs Overview

Jobs are actions, such as exporting data or refreshing the database, which you can start right away or schedule to run at intervals.

The Jobs console enables administrators to manage jobs in a central location.

You can manage these types of jobs in the Jobs console:

  • Rules—Launches a business rule. The Business Rules page lists the business rules that were created for the application.

  • Import Data—Performs a data import operation that was saved as a job.

  • Import Metadata—Performs a metadata import operation that was saved as a job.

  • Export Data—Performs a data export operation that was saved as a job.

  • Export Metadata—Performs a metadata export operation that was saved as a job.

  • Refresh Database—Refreshes the application database.

  • Invalid Intersection Reports—Runs a report that shows where data exists at invalid intersections.

  • Restructure Cube—From Cube, select the cube to restructure. Performs a full restructure of a Block Storage cube (BSO) to eliminate or reduce fragmentation. This will also remove empty blocks. It is not applicable for an Aggregate Storage cube (ASO). See Restructuring Cubes.

  • Import Journal—Performs a journal import operation.

  • Import Journal Template—Performs a journal template import operation.

  • Export Journal—Performs a journal export operation.

  • Export Journal Template—Performs a journal template export operation.

  • Run Intercompany Report—Runs an Intercompany Report.

  • Run Consolidation Trail Report—Runs a Consolidation Trail Report.

  • Administration Mode—Changes the login level for an application. If you select Administrators, all non-administrative users will be logged off from the application after job execution. To restore access to an application for all users, select All users.

  • Execute Bursting Definition—Runs a saved bursting definition for Reports. You can run a single report or book for more than one member of a single dimension for one data source, and publish a PDF output for each member. See the "About Bursting" section in Designing with Reports for Oracle Enterprise Performance Management Cloud.

  • Import Invalid Intersections—Performs an Invalid Intersection import operation.

  • Export Invalid Intersections—Performs an Invalid Intersection export operation.

  • Integration Pipeline—Runs a Pipeline definition. This job supports running a Pipeline based on the parameters and variables that were defined for the Pipeline in the Data Integration user interface; for example, Start Period and Import Mode.

    For descriptions of the job parameters and variables, see the following topics:

    • Using an Integration Job Type in Administering Data Integration for Oracle Enterprise Performance Management Cloud

    • Running a Pipeline in REST API for Enterprise Performance Management Cloud

    • For information about creating a Pipeline definition, see Using the Pipeline in Administering Data Integration for Oracle Enterprise Performance Management Cloud.

You can also manage non-Consolidation type jobs, such as Task Manager, Supplemental Data, and Enterprise Journal jobs See Viewing Non-Consolidation Jobs.

Note:

To prevent automatic backup from failure due to scheduled jobs, EPM Cloud disallows certain scheduled jobs to start while the daily maintenance process is running. The following jobs are prevented from starting during the daily maintenance:
  • Import Data

  • Import Metadata

  • Export Data

  • Export Metadata

  • Refresh Database

  • Restructure Cube

If the system prevents a job from starting, the reason will be stated in the Job Details. If you've enabled email notifications for the Job Console, you'll receive an email notification when a job does not start. If you have a job that is scheduled to start during the daily maintenance process, it is recommended that you reschedule your job to start outside of the daily maintenance window. See Scheduling Jobs.