Financial Management - PSFT (MOSC)

MOSC Banner

Issue with Match Override in PS 9.2

edited Aug 16, 2019 3:26PM in Financial Management - PSFT (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center