E1: 04: Create Payment Control Group (R04570) UBE Incorrectly Selects Vouchers with Pay Status of Z that Are Selected in a Manual Payment (P0413M), Causing Data Integrity Issues (Doc ID 2825017.1)

Last updated on MAY 17, 2022

Applies to:

Symptoms

 When Data Selection for R04570 Create Payment Work Groups UBE is changed to not include the selection on 'PayStatus equal to A' (Approved), the vouchers having pay status Z Selected/Payment Pending can be selected for processing. Later on, that allows the integrity scenario of a voucher being linked to a manual payment and having Pay Status A Approved, in the same time.

      Steps:

1. Create a manual payment (with voucher match) through P0413M but don't click on Save button. This will update the voucher pay status to pay status Z Selected/Payment Pending.
2. Run R04570 to pick up the same voucher, after removing from the default Data Selection the reference to F0411.PST = A Approved.
3. Return to P0413M and Save the manual payment from step 1, which changes the Pay Status to P Paid on the voucher.
4. Undo the payment group in P04571, this will turn the Pay Status on the voucher to A Approved.

The code of Create Payment Work Groups (R04570) should be changed so that by default to check and exclude those vouchers having Pay Status Z Selected/Payment Pending, not only those having Pay Status codes P Paid and # Payment in Process, as it is happening now.

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.