How To Delete/Purge Change Request Data From PS_CHNG_RQST And PS_CHNG_RQST_DTL Table Related to PO Close Short Process
(Doc ID 2849393.1)
Last updated on SEPTEMBER 12, 2023
Applies to:
PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Goal
Qn1:There are around 100K Approved rows in the PS_CHNG_RQST_DTL table as it was run by an User accidentally. How to purge these 100k rows from the PS_CHNG_RQST and PS_CHNG_RQST_DTL tables? Is there a process we need to run or do we delete these from Backend?
Qn2:Does the Purge process deletes data from any other tables apart from PS_CHNG_RQST, PS_CHNG_RQST_DTL and CHNG_RQST_MSGLG tables?
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 |