The Oracle database seed dump in the repository, contains some wrong constraints i.e.:
I think there are an errors in migration script: 201310141246_IDEMPIERE-386.sql
i.e. there is this
ALTER TABLE M_InOutLineMA DROP CONSTRAINT m_inoutlinema_key
DROP INDEX M_INOUTLINEMA_KEY;
Oracle XE 11G
I have encountered the same problem.
If I understand correct Oracle is creating also an index when you create a primary key constraint. When you drop the constraint, the index is not droped automatically.
I have attached a migration for Oracle which takes care and works even if you had already manually droped the index.
I think for the future people have just to remember this and take care that besides the constraint they also drop a related index.
Thanks , committed a version with direct DROP because in my tests with syncApplied it didn't work the pl/sql version.