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

Last updated on MAY 23, 2023

Applies to:

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

Changes

Cause

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