Accounting Hub Implementation Guide
11g Release 1 (11.1.2)
Part Number E20374-02
This chapter contains the following:
Manage Subledger Accounting: Overview
Create Subledger Journal Adjustment
Review Subledger Journal Entry
In the Manage Subledger Accounting activity, you can generate journal entries for source system transactions, create adjustment entries, and review accounting results.
Create accounting for a batch of transactions by submitting an offline process.
Create manual adjustment entries.
Review generated journal entries and projected balances on views and reports.
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.
The following table describes the parameters for the Create Accounting program as submitted in the Scheduled Processes Monitor window.
Source system for which the Create Accounting program is being executed.
Ledger name for which the Create Accounting program is being executed.
Selecting a process category indicates that all associated accounting event classes and their assigned accounting event types are selected for processing.
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; Draft or Final
Default value is Final.
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.
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.
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.
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.
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.
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:
When editing a subledger journal entry, you can perform the following tasks:
Edit the journal header information, if the status is not Final.
Enter new journal lines, including accounts.
Enter the debit, and credit amounts.
Enter the accounting class.
View the impact on general ledger account balances should the entry be completed.
Post the journal.
You can also edit incomplete manual subledger journal entries.
Examples of header information which can be updated:
Examples of journal entry line information which can be updated:
Journal entry lines
Edit default currency options to be assigned to a manual subledger journal entry.
Select supporting references and assign values to them.
Edit or redefine the subledger journal entry description.
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.
You may reverse manual subledger journal entries in Final status. Reversal options are defaulted from accounting options.
Switch debit and credit
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.
You can complete manual subledger journal entries in Final and Post to General Ledger status.
The application enables the user to create manual subledger journal entries online.
This includes the ability to:
Enter the complete information required for a manual subledger journal entry.
Enter subledger journal entry descriptions.
Select a supporting reference and supply the supporting reference value to a subledger journal entry or subledger journal entry line.
Assign a descriptive flexfield to a subledger journal entry or subledger journal entry line.
Populate default values for an entered currency for new subledger journal entry line.
Enter default conversion type, date, and rate information to establish a default currency for the journal that is different than its associated ledger currency.
View projected balances of entered and accounted journal line amounts.
Complete and post subledger journal entries.
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:
Provide additional information about a subledger journal entry at the header or line level.
Establish a subledger balance for a particular supporting reference segment value.
Assist with reconciliation of account balances.
Provide for financial managerial analysis.
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 level does not keep any balances.
Assigning supporting references to subledger journal entry lines enables you to maintain detailed balances, by supporting reference value, for general ledger accounts.
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.
You can create subledger journal entries by using one of two methods:
Use the Create Accounting program to process accounting events using accounting rules.
Create manual subledger journal entries.
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.
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.
Perform an inquiry on unprocessed accounting events, subledger journal entries and subledger journal entry lines based on multiple selection criteria.
Create, edit, duplicate, reverse or delete a manual subledger journal entry
View detailed information about the subledger journal entry
View a subledger journal entry in the T-Accounts format
View transactions underlying the accounting event or the subledger journal entry
View supporting references associated with the subledger journal entry and lines
View tagged subledger journal entries or create a tag on the subledger journal entry
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:
Creation and validation of unposted manual journal entries by providing knowledge users with immediate and relevant information about the account balances for the selected journal lines.
Validation and reconciliation of posted journal entries by providing immediate and relevant information about the account balances for the selected journal lines.
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.
For unposted journals, the period balance is projected by summing the current balance with the subledger journal entry line amounts
For posted journals, the opening balance and the period activity is calculated using the current balance and journal line amount
Projected balances increases accuracy when booking entries to reconcile accounts.