There was a database migration to a new instance of Oracle recently. Since then starngely the process instance ids are being reset to very old values already exisiting in the database. Hence when trying to insert this process instance id on one of the tables by a smart object getting unique constraint error.
Does anyone have any idea on why this might be happenning?
Help would be really appreciated.
Thanks.
