Automatic Journal Scheduling

Automatic Journal Scheduling lets you generate Recurring Journals, AutoAllocation sets, MassAllocations, MassBudgets and Budget Formulas according to a schedule you define. For example, you can schedule the same journal and allocation sets to be generated every month as part of your month-end closing procedures.

If you have business cycles that do not coincide with monthly calendars, you can define your own schedule in General Ledger. General Ledger schedules are based on your General Ledger calendar.

You can also choose any defined schedule in the Application Object Library (AOL). AOL schedules are based on a standard monthly calendar. You can define a new AOL schedule or re-use a schedule you previously defined and saved. You can define your AOL schedule to run a request as soon as possible, at a specific time, or repeatedly at specific intervals, on a specific day and time of the week or month.

Create or define recurring journals, autoallocation sets, massallocations, budget formulas, or massbudgets, enter submission parameters, and select a schedule to automate the generation of your journals.

You then review and post your generated journals.

Prerequisites

To use Automatic Journal Scheduling:

  1. Navigate to any one of the following definition windows:

    AutoAllocation Workbench

    Define Recurring Journal Formula

    Define MassAllocation

    Define Budget Formula

    Define MassBudgets

  2. Create a new entry or query a definition you previously defined.

    Note: If using Definition Access Sets to secure your General Ledger definitions, you must have Use and View privileges to the definition to use Automatic Journal Scheduling.

  3. Choose the submit or generate button. For AutoAllocation Sets, choose the Schedule button. For Budget Formulas, choose the Calculate button.

    A Decision window displays.

  4. Choose the Schedule button.

    The Oracle Applications standard submission Parameter window appears.

  5. Complete the window according to your specific requirements.

    Name: enter the name of your definition.

    Ledger: enter the name of your ledger. This field is not required for Budget Formulas or MassBudgets.

    Balancing Segment Value: enter the balancing segment value. This field is not required for Budget Formulas or MassBudgets.

    Period: enter the period you wish to first submit your definition.

    Budget: Applies only to Budget Formulas and MassBudgets.

    Note: If you are using a ledger with average balance processing enabled, the following fields are displayed:

    Journal Effective Date: This must be a business day if the profile option, Journals: Allow Non-Business Day Transactions is set to No.

    Calculation Effective Date: The calculation effective date used by Recurring Journals and Allocation formulas. This must be a business day if you plan to increment your submissions.

    Usage: Select Standard or Average.

    Note: If you are scheduling an autoallocation set from a Projects responsibility, the following fields are displayed:

    GL Period:

    PA Period:

    Expenditure Item Date:

    See: Submitting an AutoAllocation Set for more information.

    You can choose the Submit button to submit your request immediately.

  6. Choose the Schedule button on the Parameter window.

    The Submit Request window appears.

  7. Choose the Schedule button to open the Schedule window.

  8. Choose the Apply a Saved Schedule button and select one of the following:

    See: Defining Financial Schedules

    See: Defining a Submission Schedule

  9. (Optional) You can choose to automatically increment the General Ledger period and date parameters for resubmissions. To enable, check the Increment Date Parameters Each Run check box. See: Incrementing Submissions.

  10. Choose OK to confirm your selections in the Schedule window then choose Submit to submit your scheduled request.

Related Topics