Issue with Match Override in PS 9.2
Hi Team,
We have an abend in AP_Match process. Unique constraint error at step AP_MTCH_FUME.POLnMtch.Step03 SQL Error: ORA-00001: unique constraint (PRFS.PS_PO_LINE_MATCHED) violated
As per analysis, we found that voucher was manually overriden for matched status by user. The AP_Match was run by the user. Somehow the voucher matching status was not changed to matched but data was inserted in PO_LINE_MATCHED as matched.
Now when-ever we run AP_MATCH, this voucher is getting picked as its MATCH_STATUS_VCHR in PS_VOUCHER is still 'O' and AP_MATCH is failing with unique constraint error at PO_LINE_MATCHED.