My Oracle Support Banner

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:

Oracle Payables - Version 12.2.8 and later
Information in this document applies to any platform.

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

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
Symptoms
Cause
Solution
References


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