EGL: Questions About PS_CLOSE_LEDG_LOG Record Growing Large
(Doc ID 2250473.1)
Last updated on FEBRUARY 04, 2019
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9 to 9.2 [Release 9]Information in this document applies to any platform.
Goal
The PS_CLOSE_LEDG_LOG record is growing by the year, causing significant performance issues with the GLPCLOSE process.
This table seems to hold data for each FISCAL_YEAR
- What is the significance of this table? How is it used?
- What is the need to hold data in this table for previous years?
- Can data be deleted that is over 2 years old?
- What is the significance of the index on this table? What is it specifically used for? Can it be dropped?
Solution
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
Goal |
Solution |
References |