Tips to Improve Accounting Performance

Here are some tips and recommendations to improve Create Accounting program performance:

• You must control the Create Accounting job submission. For example, only submit the Create Accounting jobs for the same application/same ledger simultaneously if the application is in row lock mode.

• You must understand that the maximum volume for an application is equal to the number of ledger combinations. So, for example, if an application with a ledger has 1000 mn and 1 mn volume, you should consider 1mn as your target volume and set workers accordingly.

  • For volume up to few thousand, you can restrict 1 worker.

  • For volume > 50K, increase CA workers to 3 with processing unit size 1000, GL_transfer workers 2 processing unit size 10K.

  • For volume > 100K, increase CA workers to 5 with processing unit size 5000, GL_transfer workers 3 processing unit size 40K.

  • For volume > 500K, increase CA workers to 7 with processing unit size 5000, GL_transfer workers 4 processing unit size 40K.

  You can achieve optimum performance by staggering the Create Accounting runs for various application-ledger combinations.

• Set up Manage Subledger Accounting Options UI in Functional Setup Manager (FSM) to control multiple accounting sub-processes per Create Accounting process request.

• You can change the Number of Create Accounting Workers from the System Options in the Manage Subledger Accounting Options page. The number of workers default is 1. Be careful while changing this parameter. For example, if the production environment is of M6 size and Create Accounting takes a long time as there is only one worker set up now, it could help if you increase it up to 4 or 6.

• The Create Accounting program performance also depends on the number of Accounting Hub applications available and transaction volume being processed at a time. For example, if transaction volume is high (100,000 +) in one of the Create Accounting request scope, increase the workers incrementally to improve the performance. Note that a large number ( > 10) of workers per Accounting hub application running Create Accounting in parallel can have contention and can adverse the performance.

Best Practices

Here are some best practices to deal with Create Accounting program performance issues:

• The performance of the Create Accounting program depends on the time taken by various child jobs spawned by the program. Therefore, follow the below steps to increase the number of workers for Create Accounting and transfer to the GL subprogram:

  1. From the Setup and Maintenance work area, navigate to the Define Accounting Transformation Configuration task and go to Manage Subledger Accounting Options. Search for your ledger, expand and open the Cost Management application. Edit the System options to change the Number of Create Accounting Workers from 1 to 10 and change the Number of General Ledger Transfer Workers to 2.

  2. Cancel the running Create Accounting job and resubmit a new one.

• Ensure the profile option Enable SLA debug mode is turned off.

• Ensure no Finest log levels are enabled.

• Select the Transfer to GL option as No.