Skip Headers

Oracle Subledger Accounting Implementation Guide
Release 12.1
Part Number E13628-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Reporting Sequence

Reporting Sequence Overview

Journal entries have the following sequences attached to Subledger Accounting:

These two sequences are not mutually exclusive and can coexist in the same journal entry.

In some cases, the completed journal entries can be functionally correct but the sequence numbers assigned to them are wrong. For example, the user realizes that the sequencing setup is not correct and wants to resequence all the journal entries that are sequenced based on the wrong setup. Subledger Accounting provides an undo and redo accounting feature to correct the original accounting. A key component of this feature is the Re-sequencing of Journal Entries.

Reporting sequence is optional.

Sequence Programs

The reporting sequence feature is based on the following programs:

The reporting sequence program selects the journal entries to be sequenced and performs the following:

Resequence of Accounting Sequence Number Program

This program is for use by Oracle Development and Support to maintain the reporting order sequence when journal entries are deleted or added.

Reporting Sequence Process Flow Diagram

The diagram below shows the reporting sequence process and is described in Reporting Sequence Process Steps.

Reporting Sequence Process Flow Diagram

the picture is described in the document text

Reporting Sequence Process Steps

  1. Define the sequence setup as part of the implementation process.

  2. Create, complete, and post journal entries as part of the daily operations.

  3. Close a General Ledger period as part of the period end operations and the reporting sequence program is automatically run.

    After selecting the journal entries that belong to this period and to all the subsequent consecutive closed periods, the reporting sequence program calls the accounting sequence numbering program to perform the actual sequencing. The reporting sequence program selects the journal entries in chronological order based on the sequencing order.

  4. Run the report that displays the journal entries.

    Run this report whenever you want. The journal entries that belong to a closed period appear in this report with their corresponding sequence number, while the journal entries that belong to an open period are displayed without the sequence number since they have not been sequenced yet.

  5. You can decide to open a closed period as part of the reconciliation process and the reporting sequence program is automatically run.

    The program erases the sequences that are assigned to the journal entries that belong to the reopened period. If there are other succeeding closed periods, the sequences assigned to the journal entries that belong to these periods are also erased. As the sequence assigned to the journal entries is a gapless sequence, the reporting sequence program calls the accounting sequence numbering program in erase mode with the lowest sequence assigned to the selected journal entries to avoid gaps when the journal entries are resequenced.

  6. Enter new journal entries into the period that has been reopened.

  7. Close the period and the reporting sequence program is automatically run.

    The reporting sequence program calls the accounting sequence numbering program to sequence all the journal entries that belong to this period in chronological order based on the sequencing order. The reporting sequence program selects the journal entries that belong to the succeeding closed periods.

    The following journal entries can be assigned a reporting sequence:

  8. Run the report that displays all the journal entries that belong to the closed periods with their new sequence.