Accounting Hub Orchestration Improvements for Multiple Ledgers

Import Accounting Hub transaction files with multiple ledgers as a single unit of processing. The import process detects and executes the accounting workload in an elastic manner, reducing the need to orchestrate the files through an external process controller.

The feature contains three major enhancements:

• Process Multiple Ledgers in a Single Process Run

The Create Accounting for Data Set process is used to process all Accounting Hub transactions imported through a single data file. This process can now handle transactions pertaining to multiple ledgers in a single process run, reducing the need to orchestrate processes separately through an external process controller.

• Improvements to Transfer of Subledger Accounting Entries to General Ledger

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.

• Intelligent Queue Management

With this enhancement the system intelligently manages the queue of scheduled jobs and releases the create accounting workloads based on the available job queue processing capacity. The submission of the Create Accounting for Data Set process is put on hold until the system determines that the current job queue processing capacity is enough to process the downstream accounting and posting processes.

NOTE: These enhancements are enabled by default on all new implementations where Accounting Hub applications are configured. Existing live implementations can enable some of these features individually or as a combination using the setup steps.

Business benefits include:

• Improved end-to-end processing of Accounting Hub transactions, including accounting and posting into General Ledger.
• Reduced maintenance of feeds into the Accounting Hub.

Steps to Enable

Enabling the Process Multiple Ledgers in a Single Process Run and Improvements to Transfer of Subledger Accounting Entries to General Ledger Enhancements for Accounting Hub Applications

Use the following steps to enable the Process Multiple Ledgers in a Single Process Run and Improvements to Transfer of Subledger Accounting Entries to General Ledger enhancements for Accounting Hub applications -

1. Navigate to Setup and Maintenance.
2. Search and navigate to the Setup Task: Manage Standard Lookups.
3. Search the Lookup Type: ORA_ERP_CONTROLLED_CONFIG.
4. Define the following Lookup Code under above Lookup Type -
   • Lookup Code: XLA_34838399
   • Enabled: <Checked>
   • Meaning: Multiledger Accounting
5. Save the changes.

Enabling the Improvements to Transfer of Subledger Accounting Entries to General Ledger Enhancement for Accounting Hub Applications

Use the following steps to enable only the Improvements to Transfer of Subledger Accounting Entries to General Ledger enhancement for Accounting Hub applications -

1. Navigate to Setup and Maintenance.
2. Search and navigate to the Setup Task: Manage Standard Lookups.
3. Search the Lookup Type: ORA_ERP_CONTROLLED_CONFIG.
4. Define the following Lookup Code under above Lookup Type -
   • Lookup Code: XLA_35065565
   • Enabled: <Checked>
   • Meaning: Direct Transfer for Accounting Hub applications
5. Save the changes.

Enabling the Improvements to Transfer of Subledger Accounting Entries to General Ledger enhancement for all Subledger and Accounting Hub applications

Use the following steps to enable the Improvements to Transfer of Subledger Accounting Entries to General Ledger enhancement 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: Direct Transfer
7. Save the changes.

Enabling the Intelligent Queue Management enhancement for Accounting Hub applications

Use the following steps to enable the Intelligent Queue Management enhancement 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_32357094_ON
   • Reference Data Set: Common Set
   • Enabled: <Checked>
   • Meaning: Enable Intelligent Queue Management
7. Save the changes.

Tips And Considerations

• It is recommended to enable the Process Multiple Ledgers in a Single Process Run enhancement.
  • When the Process Multiple Ledgers in a Single Process Run enhancement is enabled, the Intelligent Queue Management enhancement is not engaged. Queue management issues are averted through the single Create Accounting for Data Set process for multiple ledgers which also transfers the accounting entries to General Ledger.
  • When the Process Multiple Ledgers in a Single Process Run enhancement is not enabled, Intelligent Queue Management is triggered to manage the create accounting workloads.

• The Improvements to Transfer of Subledger Accounting Entries to General Ledger enhancement is ignored in the following cases –
  • When Online Accounting is submitted from the Transaction pages.
  • When the Multiperiod Accounting process is submitted it doesn’t skip the Post Subledger Journal Entries process although the Journal Import process is skipped.
  • When accounting is transferred outside of Fusion General Ledger i.e. to EBS General Ledger or PeopleSoft General Ledger.

• If the "Improvements to Transfer of Subledger Accounting Entries to General Ledger" enhancement 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" enhancement 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.