PO_POCHNG Runs for All Data (Including Previous Runs) Instead of Current Search Criteria
(Doc ID 2759880.1)
Last updated on MARCH 06, 2023
Applies to:
PeopleSoft Enterprise SCM Purchasing - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
PO_POCHNG runs for all data (including previous runs) instead of current search criteria.
Navigation: Purchasing > Purchase Orders > Manage Change Orders > Buyer Mass Change
Steps:
Search on 1 PO
SQL being run is:
-- 2020-12-04 14:42:08.216 ....(PO_CMCH_EDIT.CME0000.Step04) (SQL)
UPDATE PS_CHNG_RQST_DTL SET PROCESS_INSTANCE = 247537 WHERE
PROCESS_INSTANCE
<> 247537 AND CHG_PROCESS_STATUS NOT IN ('C', 'X') AND EXISTS ( SELECT 'X'
FROM PS_CHNG_RQST C WHERE C.PROCESS_INSTANCE = 247537 AND C.BUSINESS_UNIT =
PS_CHNG_RQST_DTL.BUSINESS_UNIT AND C.PO_ID = PS_CHNG_RQST_DTL.PO_ID AND
C.CHNG_SOURCE = PS_CHNG_RQST_DTL.CHNG_SOURCE AND C.CHNG_DTTM =
PS_CHNG_RQST_DTL.CHNG_DTTM)
This searches for all records. Would like it to produce results for the current search criteria
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 |