Skip to main content

Error 'ORA-00001: Unique Constraint Violation' in Person Delete Job

In this article, we explain the STATUS = FAIL error in MO_PERSON_DELETE_REQUESTS due to a unique constraint violation.

Y
Written by Yusef Abulaynain
Updated over 4 months ago

If you can't see the record in the Mosaic front end, it's because the record was previously deleted.
​
Check the MO_DELETED_PERSONS for an entry matching the person id and make a note of the DELETED_ON date (replacing <person_id> with the actual person id)
​

select * from MO_DELETED_PERSONS where person_id = '<person_id>'


Then compare this with the DATETIME_OF_REQUEST column in the MO_PERSON_DELETE_REQUESTS (replacing <person_id> with the actual person id)
​

select * from MO_PERSON_DELETE_REQUESTS where person_id = '<person_id>'
Did this answer your question?