AP:Payment Request Table Is Not Updated When Request Is Cancelled
(Doc ID 2180050.1)
Last updated on MARCH 09, 2017
PeopleSoft Enterprise FIN Payables - Version 9.2 and later Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!