Performance Issue for the Accounting Program - Problem with Global Temporary Tables
(Doc ID 1508846.1)
Last updated on MAY 01, 2023
Applies to:Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
On : R12 version, Subledger Accounting Uptake for Receivables
When running Create Accounting for Receivables, the performance for Accounting Program is very bad
Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Control > Requests > Run
- Run Create Accounting
A trace/tkprof of the process shows the following query as the top one:
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