Job Types
Job types fall into five main categories:
Application Maintenance Jobs
Table -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. See the Enable Use of the Application for setting in System Settings. |
| Clear Cube |
Performs a cube clearing operation. See Clearing Cubes for information about clearing cubes and 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 file of a 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. 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. 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). See Optimizing Aggregation for the PCM_REP Reporting 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. |
|
Refresh Database |
Refreshes the application database. 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. See Improving Cube Performance. 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 -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 See Importing Data. 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. |
| Import Exchange Rates |
Imports exchange rates for a simplified multicurrency application. See Importing Exchange Rates for a 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
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. |
| Import Valid Intersections |
Runs a report that shows where data exists at invalid 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 Exporting Data. 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 Diagnostics |
Exports supplemental diagnostic information to a zip file titled
|
| Export Job Console | Exports records about the jobs in the Jobs console to a zip file
titled allJobDetails<date>.zip.
|
| Export Library Document |
A REST API that exports documents from the library. |
|
Export Metadata |
Exports metadata into a file using the settings specified in an
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 POV Data |
Exports POV data to a Comma Separated Values (CSV file. |
| 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. |
| Export Valid Intersections |
Exports valid intersections that were save as a job. |
Integration Jobs
Table -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. |
| 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: 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 . |
Model Operations Jobs
Table -4 Model Operation Jobs
| Job Tye | Description |
|---|---|
| Batch Calculation |
Job that is created as a result of running a calculation on the Calculation Control page. If you selected more than one POV to calculate, the Batch Calculation job summarizes information about all the POVs selected to calculate. Separate calculation jobs are also created for each individual POV. |
| Calculate Model |
Job that is created as a result of calculating a model. You can calculate models in the following ways:
Note: Calculate Model jobs that were defined and saved as a job using PMC Agent are displayed on the Model Operations tab. |
| Clear Point of View |
Job that is created as a result of clearing a point of view. You can clear POVs in the following ways:
Note: Clear Point of View jobs that were defined and saved as a job using PMC Agent are displayed on the Model Operations tab. |
| Create Point of View |
Job that is created as a result of creating a point of view with the Create Point of View REST API. See Create Point of View. |
| Copy Point of View |
Job that is created as a result of copying a point of view. You can copy POVs in the following ways:
Note: Copy Point of View jobs that were defined and saved as a job using PMC Agent are displayed on the Model Operations tab. |
| Delete Point of View |
Job that is created as a result of deleting a point of view. You can delete POVs in the following ways:
Note: Delete Point of View jobs that were defined and saved as a job using PMC Agent are displayed on the Model Operations tab. |
| Generate EPCM Report |
Generates a Model Documentation report. |
| Rules |
Runs business rules created in Calculation Manager. |
| Rules Add Member |
Adds a member to one or more rules. |
| Rules Copy to Model |
Copies one or more rules to a model. |
| Rules Copy to RuleSet |
Copies one or more rules to a rule set. |
| Rules Disable |
Disables a rule or rules. |
| Rules Enable |
Enables a rule or rules. |
| Rules Replace Member |
Finds a member in a rule and replaces it with another member. |
| Run Calculation |
Job that is created as a result of running a calculation for a POV on the Calculation Control page. See Calculating Models. |
| Validate Model |
Validates models to make sure there are no potential calculation failures. The Validate Model job is created when you use the Validate Model EPM Automate command or the Validate Model Rest API. If you run Model Validation from the Enterprise Profitability and Cost Management user interface, a job is not created. See validateModel in Working with EPM Automate and Validate Model in REST APIs for Oracle Fusion Cloud EPM. |
Other Jobs
Table -5 Other Jobs
| Job Type | Description |
|---|---|
| Auto Predict |
Not applicable to Enterprise Profitability and Cost Management. |
| Change Hybrid Configuration |
Not applicable to Enterprise Profitability and Cost Management. |
| Clear Cell Details |
Not applicable to Enterprise Profitability and Cost Management. |
|
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. |
| Convert 1.0 Dashboards to 2.0 |
Converts Dashboard 1.0 to Dashboard 2.0. See Creating and Managing Dashboards 1.0 and 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 can be scheduled from the Data Maps listing page. To schedule a Data Map job:
|
| 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. |
| Insights |
Runs an IPM Insights insight definition. Note: Insights jobs cannot be scheduled from the Jobs console; instead, they can be scheduled from appropriate Insights listing page. |
| Invalid Intersection Reports |
Runs a report that shows where data exists at invalid intersections. Note: Invalid Intersection Reports jobs cannot be scheduled from the Jobs console; instead, they can be scheduled from the Reports tab on the Invalid Intersection Reports page. |
| Smart Push |
Uses Smart Push to move data from one cube to another. |