Payables Accounting Process Very Slow Performance (Doc ID 364415.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: 11.5.10
This problem can occur on any platform.
Accounting Process Performance APACCENG

Symptoms

Performance of Payables Accounting process is poor.
The process takes 3 hours to complete.


.
QUESTION
=========
1.Currently there are about thousands of accounting records in the GL interface
table.So will the Upgrade process (11.5.6 to 11.5.10.2) and the Maintenance pack affect the interface data in any way.If yes then suggest a possible solution for the same.


2.After upgrading to 11.5.10, will the Payables Accounting process run normally
or will the performance be slow still.If it would be slow then please suggest a
solution to the same.


Changes

In the process of upgrading from 11.5.6 to 11.5.10.2 and upgrading db from 8.1.7.2 to 9.2.0.6.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms