Why does satellite-sync fail with error 'ORA-01776: cannot modify more than one base table through a join view, Package Upload Failed due to uniqueness constraint violation.'

Issue

• The satellite-sync fails with error:

rhnFault: (54, 'ORA-01776: cannot modify more than one base table through a join view\n', '\n     Package Upload Failed due to uniqueness constraint violation.\n     Make sure the package does not have any duplicate dependencies or\n     does not already exists on the server\n     ')