My Oracle Support Banner

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

Last updated on MAY 23, 2023

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.





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.