EAM 9.2 : Load Depr Reporting Table Process (AMDEPRPT) Performance Issue After Upgrading To Image 40
(Doc ID 2908608.1)
Last updated on DECEMBER 22, 2022
Applies to:
PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
The Load Depreciation Reporting tables process runs for more than 12 hours after upgrading from Image 27 to Image 40.
Replication Steps:
- Go To Asset Management > Financial Reports > Load Reporting Tables > Load Depr Reporting Table and run the process.
OSS recommended that fixes for Bugs <Bug 32777362>, and <Bug 33477520> from PUM 42 be applied to see how the system behaves. The following is the timings summary for long-running steps with iterations involved after applying the suggested fixes.
C o m p i l e E x e c u t e F e t c h Total
SQL Statement Count Time Count Time Count Time Time
------------------------------ ------- -------- ------- -------- ------- -------- --------
AE Program: AMDPREPT
DPRPT260.Step01.S 1 0.000 3256 739.250 0 0.000 739.250
DPRPT270.Step02.S 13024 0.630 13024 758.670 0 0.000 759.300
DPRPT610.Step01a.S 1 0.000 976 4671.130 0 0.000 4671.130
DPRPT610.Step01b.S 976 0.060 976 4669.630 0 0.000 4669.690
DPRPT620.Step01.D 3256 0.320 3256 9794.540 3256 0.000 9794.860
DPRPT620.Step02.D 3256 0.390 3256 10130.860 3256 0.000 10131.250
DPRPT620.Step02A.D 3256 0.430 3256 10135.980 3256 0.000 10136.410
------------------------------------------------------------------------------------------
Total run time : 44462.800
Total time in application SQL : 43550.000 Percent time in application SQL : 97.9%
Total time in PeopleCode : 18.910 Percent time in PeopleCode : 0.0%
Total time in cache : 2.720 Number of calls to cache : 257954
------------------------------------------------------------------------------------------
Changes
Upgraded from PUM 27 through PUM 40 and the performance issue was noticed.
OSS suggested fixes from PUM 42 for Bugs <Bug 32777362>, and <Bug 33477520> were applied and the performance issue still persisted for the steps outlined.
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |