Voucher's In_process_flg Not Getting Updated To "N" In AP_MATCH If The Run Control Is Modified (Doc ID 1563401.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

Issue:
Users run AP_MATCH on single Vouchers one after another. If the user modifies and saves the run control for the next AP_MATCH with the same run control before the current process completes, the VOUCHER.IN_PROCESS_FLG remains "Y" and is not updated to "N".

The problem is in AP_MATCH.UpdFlags.Step01.
UPDATE PS_VOUCHER SET IN_PROCESS_FLG = 'N' WHERE PROCESS_INSTANCE = 4519441
AND IN_PROCESS_FLG = 'Y' AND CLOSE_STATUS <> 'C' AND MATCH_DUE_DT TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD') AND
PS_VOUCHER.VOUCHER_ID IN (SELECT VOUCHER_ID FROM PS_MTCH_RUN_VCHR MTCH WHERE
OPRID = 'MCCASTR' AND RUN_CNTL_ID = 'MATCHINGR' AND REQUEST_ID = '1' AND
PS_VOUCHER.BUSINESS_UNIT = MTCH.BUSINESS_UNIT AND PS_VOUCHER.VOUCHER_ID =
MTCH.VOUCHER_ID) AND PROCESS_MAN_CLOSE = 'N'
/
-- Row(s) affected: 0

Here is the SQL from the app engine:
UPDATE %Table(VOUCHER)
  SET IN_PROCESS_FLG = 'N'
 WHERE PROCESS_INSTANCE = %ProcessInstance
  AND IN_PROCESS_FLG = 'Y' %Bind(WHERE_CLAUSE, NOQUOTES) %Bind(WHERE_CLAUSE2, NOQUOTES)

Steps:
1. Add PO with Matching
2. Dispatch PO
3. Create Voucher from PO
4. Add Matching Run Control
5. Run Matching for Voucher
6. Before process completes, modify the Matching Run Control to process a different Voucher ID
7. Save Matching Run Control

Cause

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