Browser version scriptSkip Headers

Oracle® Fusion Accounting Hub Implementation Guide
11g Release 1 (11.1.2)
Part Number E20374-02
Go to contents  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 Program: Explained

Create Accounting 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 program.

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 program as submitted in the Scheduled Processes Monitor window.



Subledger Application

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


Ledger name for which the Create Accounting program 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 Create Accounting 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 Create Accounting should submit the Transfer to GL process; Yes, No.

Default value is Yes.

Post in General Ledger

Indicates if users 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 program, the Create Accounting Execution Report is submitted automatically upon the completion of the Create Accounting program in success or in warning status. The Create Accounting program 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 program run previously.

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

You may also run the Post Journal Entries to General Ledger program to transfer and post the journal entries to General Ledger at a later time, as a separate process. When you use this method, you can view the output of the Post Journal Entries to General Ledger program to view the summary of the transfer process.

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.