1. Implementing Applications
  2. Create Job Definitions to Run Reports as Scheduled Processes

Create Job Definitions to Run Reports as Scheduled Processes

Every job definition has a job type that reflects the executable for the job, such as Java or Oracle Analytics Publisher reports. You can only create job definitions that are based on Analytics Publisher reports.

When there's a job definition for an Analytics Publisher report, users can run the report as a scheduled process in the Scheduled Processes work area. Otherwise, they can open reports (which are set up to be run online) elsewhere, for example in the Reports and Analytics work area.
Caution: Make sure your user name doesn’t contain any spaces. If you create a custom job definition using a user name that contains spaces, other users might get errors when they submit this custom job definition.

Create Job Definitions

Here's how you create a job definition for an Analytics Publisher report:

  1. In the Setup and Maintenance work area, go to the Manage Enterprise Scheduler Job Definitions and Job Sets task in the Application Extensions functional area. Or, depending on your offering, you might use a different functional area.

    Note: If you don't see the task, make sure that the Enterprise Scheduler Job Definitions and Job Sets feature is enabled at the offering level.

  2. On the Manage Enterprise Scheduler Job Definitions and Job Sets page, click the Manage Job Definitions tab.

  3. Click the Create icon.

  4. Fill in the Job Definition section.

    Field or Check Box

    What You Do

    Display Name

    Enter the name that users see and select to submit the scheduled process.

    Name

    Enter a name with only alphanumeric characters, for example, AtkEssPrograms1. It can't have spaces or any special characters.

    Job Application Name

    Select the application to associate the job definition with. What you select depends on the task you're using.

    • Manage Enterprise Scheduler Job Definitions and Job Sets for Customer Relationship Management and Related Applications: Select CrmEss.
    • Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications: Select FscmEss.
    • Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications task: Select EarHcmEss.

    Enable submission from Enterprise Manager

    Make sure you don't select this check box.

    Job Type

    Select BIPJobType. Don't select any other type.

    Default Output Format

    Select the output format users get by default when they submit the scheduled process.

    Report ID

    Enter the path to the report in the BI catalog, starting with the folder within Shared Folders, for example: Custom/<Family Name>/<Product Name>/<Report File Name>.xdo.

    Make sure to include the .xdo file extension for the report definition.

    Enable submission from Scheduled Processes

    Leave the check box selected.

  5. In the Parameters subtab, you can define parameters that are available to users when they submit the scheduled process based on your job definition.

  6. In the User Properties subtab, don't create or edit a user property unless you have the accurate information that's required to create or edit one. The EXT_PortletContainerWebModule user property is automatically created.

  7. Click Save and Close.

When you create a job definition, a privilege with the same name as the job definition is automatically created with a Run prefix. For example, for a job definition named MyProcess1, with display name My Process, the privilege code is RUN_MYPROCESS1, with Run My Process as the name. Make sure to use the Security Console to assign this privilege to roles so that users who need to run the process can do so.

Related Topics