Job Types

Job types fall into these categories:

Application Maintenance Jobs

Table 19-1 Application Maintenance Jobs

Job Type	Description
Administration Mode	Changes the login level for a business process. 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. An Administration Mode job is automatically created and is available for you to schedule from the App Maintenance tab on the Jobs console. See What Application and System Settings Can I Specify?
Clear Cube	Clears the data in a cube. You can create a Clear Cube job from the App Maintenance tab on the Jobs console by selecting Create Job, and then selecting Clear Cube as the job type. See Creating Clear Cube Jobs. Note: The system prevents this job from starting if it's scheduled to start while the daily maintenance process is running. Oracle recommends that you reschedule this job to start outside of the daily maintenance window. See Managing Daily Maintenance.
Compact Outline	Compacts the outline of an aggregate storage cube. Compaction helps keep the outline file at an optimal size. Compacting the outline doesn't clear the data. Running this job won't push any changes from the business process to Oracle Essbase. A Compact Outline job is automatically created and is available for you to schedule from the App Maintenance tab on the Jobs console. See Compacting the Outline . Note: The system prevents this job from starting if it's scheduled to start while the daily maintenance process is running. Oracle recommends that you reschedule this job to start outside of the daily maintenance window. See Managing Daily Maintenance.
Merge Data Slices	Merges incremental data slices of an aggregate storage cube. Fewer slices improve a cube’s performance. You can merge all incremental data slices into the main database slice or merge all incremental data slices into a single data slice without changing the main database slice. You can optionally remove cells that have a value of zero. A Merge Data Slices job is automatically created and is available for you to schedule from the App Maintenance tab on the Jobs console. See Merging Data Slices. Note: The system prevents this job from starting if it's scheduled to start while the daily maintenance process is running. Oracle recommends that you reschedule this job to start outside of the daily maintenance window. See Managing Daily Maintenance.
Optimize Aggregation	Generates optimized views based on collected query tracking information in an Enterprise Profitability and Cost Management reporting cube (PCM_REP). An Optimize Aggegration job is automatically created and is available for you to schedule from the App Maintenance tab on the Jobs console. See Optimizing Aggregation. Note: The system prevents this job from starting if it's scheduled to start while the daily maintenance process is running. Oracle recommends that you reschedule this job to start outside of the daily maintenance window. See Managing Daily Maintenance.
Refresh Database	Refreshes the application database. You can create a Refresh Database job from the App Maintenance tab on the Jobs console by selecting Create Job, and then selecting Refresh Database as the job type. See Refreshing the Application Database. Note: The system prevents this job from starting if it's scheduled to start while the daily maintenance process is running. Oracle recommends that you reschedule this job to start outside of the daily maintenance window. See Managing Daily Maintenance
Restructure Cube	Performs a full restructure of a block storage cube to eliminate or reduce fragmentation. This will also remove empty blocks. Running this job won't push any changes from the business process to Essbase. A Restructure Cube job is automatically created and is available for you to schedule from the App Maintenance tab on the Jobs console. See Restructuring the Cube. Note: The system prevents this job from starting if it's scheduled to start while the daily maintenance process is running. Oracle recommends that you reschedule this job to start outside of the daily maintenance window. See Managing Daily Maintenance.

Import/Export Jobs

Table 19-2 Import/Export Jobs

Job Type	Description
Import Audit	An EPM Automate command that imports data audit records from a ZIP file that you created by exporting audit data from an environment. See importAppAudit.
Import Cell-Level Security Definitions	Imports a cell-level security definition that was saved as a job. See Importing and Exporting Cell-Level Security Definitions.
Import Data	Imports data from a file in the repository into the application using the import data settings specified in the `Import Data` job type. See Creating an Import Data Job. Note: The system prevents this job from starting if it's scheduled to start while the daily maintenance process is running. Oracle recommends that you reschedule this job to start outside of the daily maintenance window. See Managing Daily Maintenance.
Import Document to Library	A REST API that imports the content from a local source to the library in the specified upload location. See Import Library Documents.
Import Exchange Rates	Imports exchange rates for a simplified multicurrency application. See Importing Exchange Rates for a Simplified Multicurrency Application.
Import Job Console	An EPM Automate command that clones job console records using a ZIP file containing job console records exported from an environment. See importJobConsole.
Import Metadata	Imports metadata from a file in the repository into the application using the import metadata settings specified in an `import metadata` job. See Importing Metadata. Note: The system prevents this job from starting if it's scheduled to start while the daily maintenance process is running. Oracle recommends that you reschedule this job to start outside of the daily maintenance window. See Managing Daily Maintenance.
Import Security	A REST API that imports the security records or access control list (ACL) records from a Comma Separated Values (CSV) file. See Import Security.
Import User Variable Values	A REST API that imports user variable values from a file in the Planning repository into the application. See Import User Variable Values.
Import Valid Intersections	Runs a report that shows where data exists at invalid intersections. See Working with Valid Intersections.
Export Audit	A REST API that exports audit records to a Comma Separated Values (CSV) file. See Export Audit.
Export Cell-Level Security Definitions	Exports a cell-level security definition that was saved as a job. See Importing and Exporting Cell-Level Security Definitions.
Export Data	Performs a data export that was saved as a job. See Creating an Export Data Job. Note: The driver/column dimension in the Export Data job definition needs to be dense. Note: The system prevents this job from starting if it's scheduled to start while the daily maintenance process is running. Oracle recommends that you reschedule this job to start outside of the daily maintenance window. See Managing Daily Maintenance.
Export Job Console	Exports records about the jobs in the Jobs console to a zip file titled `allJobDetails<date>`.zip. See Exporting Job Console Files.
Export Library Document	A REST API that exports documents from the library. See Export Library Documents.
Export Metadata	Exports metadata into a file using the settings specified in an `export metadata` job. See Exporting Metadata. Note: The system prevents this job from starting if it's scheduled to start while the daily maintenance process is running. Oracle recommends that you reschedule this job to start outside of the daily maintenance window. See Managing Daily Maintenance.
Export Security	A REST API that exports the security records or access control list (ACL) records for specified users or groups to a Comma Separated Values (CSV) file. See Export Security.
Export User Variable Values	A REST API that exports user variable values from a Planning business process, including context-sensitive user variables. See Export User Variable Values.
Export Valid Intersections	Exports valid intersections that were save as a job. See Importing and Exporting Intersections.

Integration Jobs

Table 19-3 Integration Jobs

Job Type	Description
Integration	Runs a data rule in Data Management or integration in Data Integration based on the parameters defined in the data rule or integration definition. See Scheduling a Data Rule, Integration, or Batch Definition to Run in the Job Scheduler.
Integration Batch	Runs a batch definition based on parameters defined in Data Management. See Scheduling a Data Rule, Integration, or Batch Definition to Run in the Job Scheduler.
Integration Maintenance Script	Runs a Maintenance Script based on parameters and variables in Data Management. See Scheduling Maintenance Scripts in the Job Scheduler.
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 Run a Pipeline For information about creating a Pipeline definition, see Using the Pipeline. Note: This job is prevented from starting during daily maintenance, whether it's a scheduled job or a job that is started on an ad hoc (unscheduled) basis. Oracle recommends that you start this job outside of the daily maintenance window. See Managing Daily Maintenance .

Rule Jobs

Table 19-4 Rule Jobs

Job Tye	Description
Rules	Runs business rules created in Calculation Manager. See Creating and Managing Business Rules.
Rulesets	Runs rule sets created in Calculation Manager.
Template	Runs templates created in Calculation Manager.

Job Tye

Description

Rules

Runs business rules created in Calculation Manager.

See Creating and Managing Business Rules.

Rulesets

Runs rule sets created in Calculation Manager.

Template

Runs templates created in Calculation Manager.

Note:

Rules, Rulesets, and Template jobs cannot be scheduled from the Jobs console; instead, they must be scheduled from the Rules listing page.

From the Home page, click Rules. On the Rules page, click the checkbox next to a rule to select it. Click in the Actions column, and select Schedule.

Other Jobs

Table 19-5 Other Jobs

Job Type	Description
Advanced Predictions	Runs an Advanced Predictions job definition. See About Advanced Predictions and Running and Scheduling Advanced Predictions.
Approvals	Runs an Approvals job definition. See Managing Approvals.
Auto Predict	Runs an Auto Predict job definition. When you run the prediction job, historical data for each member in the Auto Predict definition is retrieved and then analyzed using time series forecasting techniques to predict the future performance for these members. Running the prediction as a job is useful when you have large amounts of data to predict or when you want to keep prediction results up-to-date as part of your planning and forecasting cycle. For additional information about Auto Predict job parameters, see Running Auto Predict Predictions. For information about creating Auto Predict prediction definitions, see About Auto Predict.
Change Hybrid Configuration	Enables the Hybrid option in Essbase BSO application.
Clear and Import
Clear Cell Details	Clears user selections for clearing supporting details, comments, and attachments See Auditing Overview.
Clear Data Cells
Content Update	The application is automatically refreshed during an application update. Information about the refresh is captured in the Content Update job, which propagates the changes introduced during the daily maintenance of the environment. See Scheduling Content Update Start Time.
Convert 1.0 Dashboards to 2.0	Converts Dashboard 1.0 to Dashboard 2.0. See Creating and Managing Dashboards 2.0.
Copy Data	Copies data from one dimensional intersection to another, including relational data and supporting detail. See Copying Data.
Data Map	Job that is created as a result of creating data mappings between a source application and a target reporting application. See Defining Data Maps. Note: Data Map jobs cannot be scheduled from the Jobs console; instead, they must be scheduled from the Data Maps listing page. To schedule a Data Map job: From the Home page, click Application, and then Data Exchange. Click the Data Maps tab at the bottom of the page. Select a data map, click in the Actions column, and select Schedule.
Delete Audit	Delete an auditing job. See Auditing Tasks and Data in Administering Planning
Delete Job Status	Deletes the job status.
Delete Library Documents	Deletes library documents that were imported from a local source to the library in the specified upload location.
Execute Application Diagnostics	Execute application diagnostics. See Using Application Diagnostics to Optimize Application Design.
Execute Bursting Definition	Runs a report bursting job. If you are using Reports, the bursting feature enables you to 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. Note: Bursting Definition jobs cannot be scheduled from the Jobs console; instead, they can be scheduled from appropriate listing page in Reports. See Working with Bursting.
Insights	Runs an IPM Insights insight definition. See Configuring IPM Insights. Note: Insights jobs cannot be scheduled from the Jobs console; instead, they must be scheduled from appropriate Insights listing page.
Invalid Intersection Reports	Runs a report that shows where data exists at invalid intersections. See Working With Invalid Intersection Reports. Note: Invalid Intersection Reports jobs cannot be scheduled from the Jobs console; instead, they must be scheduled from the Reports tab on the Invalid Intersection Reports page.
Migrate Reports
OGL Server Settings
Publish Sandbox	Runs a Publish Sandbox job definition. See Managing Sandboxes.
Rescan Recommendations
Resolve Recommendations
Rollback Recommendations
Smart Push	Uses Smart Push to move data from one cube to another. See Moving Data from One Cube to Another Using Smart Push.
Sort Members