Browser version script Skip Headers

Oracle® Fusion Accounting Hub Implementation Guide
11g Release 5 (11.1.5)
Part Number E20374-05
Go to contents  page
Go to Feedback page

Go to previous page
Go to previous page

8 Manage Subledger Accounting

This chapter contains the following:

Manage Subledger Accounting: Overview

Create Accounting

Create Subledger Journal Adjustment

Review Subledger Journal Entry

Manage Subledger Accounting: Overview

In the Manage Subledger Accounting activity, you can generate journal entries for source system transactions, create adjustment entries, and review accounting results.

You can:

Create Accounting

Submitting the Create Accounting Process: Explained

The Create Accounting process is an Enterprise Scheduler Service (ESS) process. It can be submitted as a request from the Scheduled Processes Monitor window to create journal entries for a batch of events. It has input parameters that determine the execution mode and the selection criteria for events.

The figure below shows the submission of the Create Accounting process.

This figure shows the Create Accounting
submission process submitted in the Schedule Process Monitor and the
Create Accounting Document Mode API.

The following table describes the parameters for the Create Accounting process as submitted in the Scheduled Processes Monitor window.



Subledger Application

Source system for which the Create Accounting process is being executed.


Ledger name for which the Create Accounting process is being executed.

Process Category

Selecting a process category indicates that all associated accounting event classes and their assigned accounting event types are selected for processing.

End Date

End date puts a filter on the selection of events. Only events having event date before the end date are selected for accounting.

Defaults to SYSDATE.

Accounting Mode

Accounting mode; Draft or Final

Default value is Final.

Process Events

Adds other filter criteria for the Create Accounting process to select events.

All: Process all events.

Errors: Process only those events that have previously been processed in error.

Invalid Accounts: Process only those events that have previously been processed in error. Replace any invalid accounts with the suspense account.

Default value is All.

Report Style

Users can choose to decide on the details of the report. The report can be printed in Summary,, Detail, or No report.

Default value is Summary.

Transfer to General Ledger

Indicates whether the Create Accounting process should submit the Transfer to GL process; Yes, No.

Default value is Yes.

Post in General Ledger

Indicates if users, who have been granted the posting privilege, want to submit General Ledger posting; Yes or No.

Default value is No.

Journal Batch

Batch name used by Transfer to GL to decide on the batch name for the batch created in Oracle Fusion General Ledger.

When a value for the batch name is not provided, journal import defaults will be used.

This is a free text field.

Include User Transaction Identifiers

Default value is No.

Accessing the Create Accounting Execution Report: Explained

When you submit the Create Accounting process, the Create Accounting Execution Report is submitted automatically upon the completion of the Create Accounting process in success or in warning status. The Create Accounting process output will contain a message with the Create Accounting Execution Report request identifier. Use this request identifier to access the execution report output.

Create Accounting Execution Report

This report can be recreated as needed by running the process, Create Accounting Report, using the request identifier of the desired Create Accounting process run previously.

If you choose to transfer the entries to Oracle Fusion General Ledger when submitting the Create Accounting process, the report indicates if accounting entries have been transferred or not transferred.

Transfer Journal Entries to the General Ledger: Explained

Importing information from Oracle Fusion subledgers is done using Oracle Fusion Subledger Accounting. Posting from the subledger systems transfers data to the general ledger interface and journal entry tables.

As part of your configuration, you can specify whether the Create Accounting process is to split the creation process into multiple workers (processors). The benefit of splitting the creation process is that accounting can be generated more efficiently with more resources allocated to complete the process. You can have multiple processors running in parallel to create the entries in a shorter period of time.

One restriction is the capacity of the hardware that is being used by the application. The more available processors, the more you are able to allocate to the Create Accounting process.

The decision for how many processors to use is made based upon expected volumes and the processing window, in other words, how much time is allocated to creating accounting. Accounting is often done as a nightly batch process, which has to finish by a certain time so that the systems can be available during work hours on the following day.

There are dependencies between the overall completion status of the Create Accounting process and the workers. In general, the parent does not update to the Completed status until all the workers successfully complete.

The process that allows transfer of subledger journal entries to general ledger uses separate processing workers that are specialized in general ledger transfer. A lightweight general ledger transfer parent process is used to distribute the workload to the workers. In order to transfer entries even faster, you can choose to have a number of parallel processing workers used for high volume general ledger transfer flow. If not specified, the corresponding accounting processors are used.

On the Manage Subledger Accounting Options page accessed from the Manage Subledger Accounting Options task from your implementation project or the Setup and Maintenance work area, select your ledger, click the pencil under System Options for Subledger Accounting to set the Processor Defaults for the Transfer to GL process.

Column Name


Processing Unit Size

Approximate batch size for high volume general ledger transfer flow. This will also be the general ledger import batch size. If not specified, the corresponding accounting processing unit size will be used.

Number of Processors

Number of parallel processing workers used for high volume general ledger transfer flow. If not specified, the corresponding accounting processes will be used.


In the Manage Subledger Accounting Options page, you can select your subledgers for each ledger or ledger set and specify the Processing Unit Size for each event class.

Diagnose Subledger Accounting Event Data: Explained

The diagnostic framework stores data that is used in the creation of a journal entry so that the data can be reported to analyze accounting issues. The purpose of the process is to provide the transaction data that is referenced during accounting through accounting rules and ledger setup.

The diagnostic framework provides a tool that can be used to determine why the accounting was created in a particular way or why there are errors. Errors may occur because either the source system information or the accounting rules are not as expected.

The following examples describe typical uses of the diagnostic framework features.

Diagnostic Framework Features

The diagnostic framework features are as follows:

Diagnostic Framework Business Process Flow

The following steps describe the diagnostic framework business process flow:

  1. The administrator sets the SLA: Diagnostics Enabled option to Yes for the user or responsibility.

  2. Users submit the Create Accounting process that automatically executes the diagnostic framework to populate the diagnostic tables. The diagnostic framework gathers source values and other information from the transaction objects.

  3. Users submit the Accounting Event Diagnostic process to view the diagnostic report. Based on the information in the diagnostic report, users may determine if additional or resubmission of information from source systems is required. They may also determine if any updates to the accounting rules is required.

  4. Users run the Create Accounting process again to generate subledger journal entries for events that had an error.

  5. The administrator submits the Purge Accounting Event Diagnostic Data process to purge the results of the diagnostic framework.

Create Subledger Journal Adjustment

Subledger Journal Adjustments: Points to Consider

Subledger journal entries decrease audit and reconciliation costs, because you can store transaction information directly with journal entries. Using the subledger journal entry validations for online transactions ensures that your user provides the required information in the subledger journal entry header and subledger journal entry lines. The subledger journal entries, combined with accounting rules, offer full disclosure of how the accounting was created for each subledger transaction, and provide assurance that the accounting was done correctly.

You can perform the following actions on your subledger journal entries, depending on their status:

Editing a Subledger Journal Entry

When editing a subledger journal entry, you can perform the following tasks:

You can also edit incomplete manual subledger journal entries.

Duplicating Subledger Journal Entries

As a time saving feature, you may copy an existing entry.

The duplication feature is enabled for all existing subledger journal entries, regardless of status, and includes the ability to copy complete information required for a manual subledger journal entry header and line.


All fields can be edited when a manual journal is duplicated.

Reversing Subledger Journal Entries

You may reverse manual subledger journal entries in Final status. Reversal options are defaulted from accounting options.

Deleting Subledger Journal Entries

Oracle Fusion Subledger Accounting provides the ability to delete a manual subledger journal entry that is not in Final status. The ability to delete manual journal entries ensures that users have the flexibility to correct errors without technical support.

Completing Subledger Journal Entries

You can complete manual subledger journal entries in Final and Post to General Ledger status.

Creating a Manual Subledger Journal: Points to Consider

The application enables the user to create manual subledger journal entries online.

Creating a Manual Subledger Journal Entry

This includes the ability to:

Supporting Reference Assignments: Points to Consider

You may want to analyze account balances and financial results by different transaction attributes. However, transaction information such as sales representative, customer, or vendor are typically not stored in the Oracle Fusion General Ledger because of the volume of general ledger balances it would create, so you are not able to analyze general ledger data categorized by transaction attributes.

You can perform this type of reporting and analysis using supporting reference information from subledger transactions. This feature enables you to create balances based upon transaction attributes not typically stored as segments in the general ledger chart of accounts. For example, you can report on receivables balances by sales representative, customer, credit risk category, item, or any other combination of transaction attributes.

Supporting references can be used to:

You can assign supporting references at either the subledger journal entry header or the subledger journal entry line.

Assigning Supporting References at the Subledger Journal Entry Header

Assigning supporting references at the subledger journal entry header level does not keep any balances.

Assigning Supporting References at the Subledger Journal Entry Line

Assigning supporting references to subledger journal entry lines enables you to maintain detailed balances, by supporting reference value, for general ledger accounts.

Validating a Third Party Control Account: Examples

If third party control accounts are enabled for the application, and the account entered is a third party control account, you must enter third party information in the journal entry.


For example, if an account is defined as a third party control account with a type of Supplier, then the subledger journal entry lines which use that account must include supplier information. When a valid third party control account is assigned to a journal line, you are required to provide third party information, such as name and site.

Submit the Third Party Balances Report to display subledger balance and account activity information for suppliers and customers. The Customer or Supplier subledger third party balances will be updated when the journal is completed to a Final status.

Review Subledger Journal Entry

Subledger Journal Entry: Overview

You can create subledger journal entries by using one of two methods:

Subledger journal entries are always created in a given subledger application context. When the subledger journal entry is complete, the appropriate sequence names and numbers are assigned, and the corresponding secondary ledger and reporting currency journal entries are created if applicable.

Manual journal entries can be entered for primary ledgers or for secondary ledgers. Manual journals for primary ledgers are automatically created only for associated reporting currencies, not secondary ledgers.

Reviewing a Subledger Journal Entry: Points to Consider

You have the ability to review subledger journal entries, whether they were created from processing accounting events, or manually entered. You may query subledger journal entries directly, or locate them via searches for journal entries with a specific status, unprocessed accounting events, or subledger journal entry lines. Advanced search functionality, including the ability to use multiple search criteria is available.

Review Subledger Journal Entries

Perform an inquiry on unprocessed accounting events, subledger journal entries and subledger journal entry lines based on multiple selection criteria.

Viewing Projected Balances: Points to Consider

Use the projected balances feature to view the impact on account balances for selected subledger journal entry lines.

The projected balances flow has the following business benefits:

Projected Balances

Oracle Fusion Subledger Accounting manual journal entry and Oracle Fusion General Ledger manual journal entry, approval, and inquiry pages display projected or current balances including the current journal entry line amounts. Depending on whether the journal is posted or not, the current balance (for the period of the journal) is displayed or calculated.

The projected balance region in the contextual area is display the projected balances for the account that includes the amounts of the selected journal entry line. Additionally, if more than one journal line for same account of the selected journal line exists, then the projected balance amount will include the impact from each journal line. The Period To Date, Quarter To Date, and Year To Date balances are also available.

Projected balances increases accuracy when booking entries to reconcile accounts.