Improvements to Transfer of Subledger Accounting Entries to General Ledger

Transfer subledger accounting entries directly to General Ledger without running the Post Subledger Journal Entries and Journal Import processes.

After the Create Accounting sub-process generates the subledger accounting entries, these entries are summarized and transferred to general ledger through the “Post Subledger Journal Entries” parent process and its child “Journal Import” process.

When you submit the Create Accounting process with the Transfer to General Ledger parameter set to Yes, the Create Accounting sub-process summarizes and transfers the subledger accounting entries to General Ledger without launching the Post Subledger Journal Entries and Journal Import processes. If you submit the standalone Post Subledger Journal Entries process, the subledger accounting entries are transferred to General Ledger without launching the Journal Import process.

Other changes included in this feature:

  • If the subledger accounting entry references an invalid account that has an alternate account defined, the alternate account is automatically used while creating the General Ledger journals.
  • If there are validation errors during General Ledger journal batch creation from subledger accounting entries, the valid accounting entries are transferred to General Ledger and the invalid accounting entries are not transferred.
  • You can review validation errors generated during the transfer of subledger accounting entries to General Ledger in the Manage Accounting Errors page.

Business benefits include faster overall processing during accounting and posting of journals with efficient use of system resources. 

Steps to Enable

Use the following steps to enable the Improvements to Transfer of Subledger Accounting Entries to General Ledger feature for all Subledger and Accounting Hub applications -

  1. Navigate to Setup and Maintenance.
  2. Select the Setup Offering: Fusion Accounting Hub.
  3. Click on the Functional Area: Accounting Transformation.
  4. Click on the Setup Task: Manage Subledger Accounting Lookups.
  5. Search the Lookup Type: ORA_XLA_PROMOTIONAL_OPTIONS.
  6. Define the following Lookup Code under above Lookup Type -
    • Lookup Code: XLA_PROMO_31776850_ON
    • Reference Data Set: Common Set
    • Enabled: <Checked>
    • Meaning: Skip Post Subledger Journal Entries and Journal Import
  7. Save the changes.

Manage Subledger Accounting Lookups

Tips And Considerations

  • This feature does not apply under any of the following conditions:
    • Online Accounting is submitted from the Transaction pages.
    • The Multiperiod Accounting process is submitted does not skip the Post Subledger Journal Entries process but does skip the Journal Import process.
    • Subledger accounting transfers outside of Fusion General Ledger, such as EBS General Ledger and PeopleSoft General Ledger.

  • If the "Improvements to Transfer of Subledger Accounting Entries to General Ledger" feature is enabled and Transfer to General Ledger is set to "Yes" during submission of the Create Accounting process, the Processing Unit Size specified in the "Create Accounting Processing Options" section of the Subledger Accounting System Options page is used to transfer journals to General Ledger.

NOTE: This may affect the number of journal batches that are generated when the feature is enabled. For example: if the Create Accounting Processing Unit Size is set to 1000 and the General Ledger Transfer Processing Unit Size is set to 2000, when the feature is enabled it may result in 2X number of journal batches when there are more than 2000 events in a batch.

  • If the "Improvements to Transfer of Subledger Accounting Entries to General Ledger" feature is enabled and the Post Subledger Journal Entries process is used to transfer journals to General Ledger, the Processing Unit Size specified in the "Transfer to General Ledger Processing Options" section of the Subledger Accounting System Options page is used.