PO Rollover Process 2 is updating all Rows for Field RECV_HDR.LAST_DTTM_UPDATE (Doc ID 2125077.1)

Last updated on JUNE 27, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

PO Rollover Process 2 is updating all Rows for Field RECV_HDR.LAST_DTTM_UPDATE


Steps
The issue can be reproduced at will with the following steps:
1 - Create Requisition and valid KK
2 - Create PO copy from requisition, Validate KK
3 - Dispatch PO
4 - Create Receipt
5 - Create Voucher for quantity 80
6 - Posting voucher
7 - Budget check voucher
8 - Query from PS_RECV_HDR = SELECT * FROM PS_RECV_HDR WHERE BUSINESS_UNIT = 'US001'
9 - Run the PO Rollover View
10 - Pull the Search ID from the View in the PO Roll Workbench. Select the PO to be rolled and save the page.
11 - PO Rollover 1 process
12 - Run Budget Check
13 - Run rollover2
14 - Run Budget Check
15 - Query: SELECT * FROM PS_RECV_HDR. All line in PS_RECV_HDR have updated field LAST_DTTM_UPDATE.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms