ECA: Accounting Rules Process (PSA_ACCTGGL) has a performance issue at the step PSA_ACCTGGL.Sel_PC.SharingB due to lack of UpdateStats after truncate/insert data into PSA_ACCTG_TA1 is executed
(Doc ID 2132825.1)
Last updated on NOVEMBER 03, 2020
Applies to:
PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Accounting Rules Process (PSA_ACCTGGL) has a performance issue at the step PSA_ACCTGGL.Sel_PC.SharingB due to lack of UpdateStats after truncate/insert data into PSA_ACCTG_TA1 is executed.
Sel_PC section inserts or deletes rows from %Table(PSA_ACCTG_TA1) and some steps also are doing a NOT EXISTS (select ‘x’ from %Table(PSA_ACCTG_TA1)….)
Revenue Step inserts zero rows and StatsTA1 step updates stats so that %Table(PSA_ACCTG_TA1) contains zero rows.
Cost Step is inserting 221331 rows into %Table(PSA_ACCTG_TA1), for which there is No Update Stats resulting in poor performance on step SharingB.
The issue can be reproduced by navigating to Customer Contracts> Schedule and Process Revenue> Process As Incurred Revenue and running the process.
Changes
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 |