My Oracle Support Banner

R12 SLA/FAH: How to Improve Performance in Subledger Accounting & Financials Accounting Hub (Doc ID 791049.1)

Last updated on MARCH 21, 2024

Applies to:

Oracle Assets - Version 12.0.1 to 12.2.3 [Release 12 to 12.2]
Oracle Payables - Version 12.0.1 to 12.2.3 [Release 12.0 to 12.2]
Oracle Cost Management - Version 12.0.1 to 12.2.3 [Release 12 to 12.2]
Oracle Process Manufacturing Financials - Version 12.0.1 to 12.2.3 [Release 12 to 12.2]
Oracle Financials Accounting Hub - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Subledger Accounting - Version: 12.0.1 to 12.1.x



This document describes how you can improve the performance in Subledger Accounting (SLA) and Financials Accounting Hub (FAH), which includes create accounting, report generation, and the execution of the Trial Balance and Subledger Balances report. 


Intended audience is a DBA or Project Manager

Disclaimer: The content of this document is directed at a technical user, such as a DBA, Technical Project Manager, or System Admin. The instructions provided should not be attempted by an end user.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. What are the latest performance patches for SLA and FAH? 
 2. What is the optimal setting for the following two parameters: No of Processors and Processing Unit Size?
 3. What Custom indexes does Development recommend?
 4. What is the correct mechanism for capturing trace and/or tkprof?
 5. What are the basic points to check before logging a performance bug?
 6. What information do I need to provide before logging a performance bug?
 7. How do I find the processing orders for my application?
 8. How do I find the processing size and number of parallel workers?
 9. How do I find the processing size at the event class level?
 10. How do I find which event class is associated with a process category?
 11. How do I determine the number of events that are picked up for an event class?
 12. How do I determine what SQL is running in the respective sessions.
Change Log

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.