AP:Payment Request Table Is Not Updated When Request Is Cancelled
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.
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.
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
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