Duplicate Payments-Build Request Triggered Twice And Bypass The Proposed Review when accessed from 2 Different Sessions (Doc ID 2691126.1)

Last updated on APRIL 05, 2022

Applies to:

Symptoms

Build Request triggered twice and bypass the "REVIEW PENDING PROPOSED PAYMENTS" stage, there by completing the payments. This happens whenever user access and clicks on the submit button in the ‘Selected Schedule Payments’ page from different sessions. This may lead to duplicate payments to the supplier

User A submits a Payment Process request(PPR) with the following options

and status of the PPR moved to “Invoice Pending Review”.

There is another user B who query the same PPR AB_34 and click on the “Start Action” and it opens the below page

After this the user B clicks on ‘Submit’ button and the request id 19599135 has been fired which subsequently invoke the build program

In the meantime user A has already clicked on ‘Start Action’ when the status of the PPR was “Invoice Pending Review” and open the “Selected Schedule Payments “ page and click on the “submit “ button
The second build program got triggered

Due to this ,the status of the PPR moved to ‘Formatting’ status skipping the :”Proposed pending Review Page” which user needs to review to validate the payments to be made

The issue gets reproduced only if the user A click on the ‘submit’ button from ‘Selected Schedule Payments’ page once the build program submitted by user A gets completed.
If the first build program does not completes and in the meantime ,2nd user build program submitted then the 2nd build program completes with “IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:PPR is already locked by another request. This is a duplicate Build Request.

But once the first build program gets completed, and second one fired after that then the PPR status is getting formatted skipping the “Proposed Payment review page”

Cause

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