EAP: When Match Collaboration is Enabled, Matching Process Fails With Error "Cannot Insert Duplicate Key Row " at Step AP_MTCH_MECC.FF001010.Step03.
(Doc ID 3040598.1)
Last updated on AUGUST 13, 2024
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Match collaboration is enabled and the matching process is run.
It was observed if a voucher has multiple match exception collaboration remarks, the process fails with an error.
Error Message:
File: C:\PT860P07B_2306280500-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1851 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_AP_MEC_REMARKS' with unique index 'PS_AP_MEC_REMARKS'. The duplicate key value is (XXXX, XXXXXX, XX, XXXX, Oct 25 2023 7:36AM).
Failed SQL stmt: INSERT INTO PS_AP_MEC_REMARKS (BUSINESS_UNIT, VOUCHER_ID, VOUCHER_LINE_NUM, MATCH_RULE_ID, CONVER_LN_DTTM, OPRID, FIELDNAME, AP_VAL_OLD, AP_VAL_NEW, PROCESS_INSTANCE, DESCRLONG) SELECT A.BUSINESS_UNIT, A.VOUCHER_ID, A.VOUCHER_LINE_NUM, A.MATCH_RULE_ID, GETDATE(), 'XXXXXX', 'AP_MECC_RES_CD', A.AP_MECC_RES_CD, 'XXXXXX', 21052852, :1 FROM PS_AP_MECC_DTL A WHERE A.BUSINESS_UNIT = 'XXX' AND A.VOUCHER_ID = 'XXXXX' AND A.VOUCHER_LINE_NUM = 4 AND A.MATCH_RULE_ID = 'XXXX' AND A.AP_MECC_RES_CD = ' '
Replication steps:
1. Enable Match Collaboration.
Main Menu > Set Up Financials/Supply Chain > Install > Installation Options > Payables.
2. Run matching process.
Menu > Accounts Payables > Batch Process > Vouchers > Matching.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |