AP:Payment Request Table Is Not Updated When Request Is Cancelled (Doc ID 2180050.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms


ISSUE:
----------
Payment Request table PR_REQUEST, fields LASTUPDT_DTTM and OPRID_LAST_UPDT are not updated when a request is cancelled

Steps to recreate - enter payment request through Payment Request Center, submit for approval, deny request through Accounts Payable > Payments > Payment Request > Payment Request Approval, cancel request through Payment Request Center. I agree that the data is populating for LASTUPDT_DTTM and OPRID_LAST_UPDT for all steps related to the payment request process. I can see the values of these field change for any given request id after each action (submit, approve, deny, etc.) with the EXCEPTION OF when a request ID is cancelled. The PR_STATUS field updates to a value of 7, but the LASTUPDT_DTTM and OPRID_LAST_UPDT does NOT update with current values (i.e., who cancelled the request and when). The values in these last 2 fields remain the same as the last action before the cancellation.

 
STEPS:
-----------
1. Take exiting new payment request which are in status of new
2. Cancel the request
3. Check the PR_REQUEST table LASTUPDT_DTTM and OPRID_LAST_UPDT is not updated.

PR_STATUS LASTUPDT_DTTM OPRID_LAST_UPDT

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