Forms are Slow After upgrade database 9.2.0.6 to 10.2.0.3 in Oracle Apps
| Question ID: 3544 | |
| Created By: | 2009-JAN-30 22:19:16 [Sadhadba] |
| Updated By: | 2009-JAN-31 12:57:53 [Vitaliy] |
| Status: | Open |
| Severity: | Normal |
| Read Only: | No |
|
9932
2009-JAN-30 22:19:16
|
||||
|
After upgrade database 9.2.0.6 to 10.2.0.3 in oracle apps 11.5.10.2 instance
the below problems are occur.
Forms are running very slow and
1. Finance module:
oracle payables for invoices and payments while try to create the
accounting the system is hanging , its taking several hours for
creating the account.
Naviagation :
oracle payable --> Invoices -- > Actions --> Create accounting
Oracle paybles -- > Payments -- > Actions -- > Create accounting
2. In purchase module
At the time of forwading PO approval it will take 10-15 minutes .
Please give the solution this is the production server
Thanks & Regards
Sadhanand - DBA
91-09985865838
[edited by: Sadhadba at 22:28 (CST) on Jan. 30, 2009]
|
9937
2009-JAN-30 23:12:33
|
||||
|
Did you run APPS level gather statistics? (it's under SYSADMIN resp.)
|
9940
2009-JAN-30 23:16:52
|
||||
|
Hi sir Yes I run APPS level gather statistics, still problem is not solved Thanks for quick response.
[edited by: Sadhadba at 23:17 (CST) on Jan. 30, 2009]
|
9945
2009-JAN-31 12:57:53
|
||||
|
> Naviagation : > oracle payable --> Invoices -- > Actions --> Create accounting > Oracle paybles -- > Payments -- > Actions -- > Create accounting > > > 2. In purchase module > At the time of forwading PO approval it will take 10-15 minutes . > Turn the trace ON for each of these processes and review the trace file to see what is going on.