You finish revising RPD for project and, upon checking global consistency, you get the following error(s):
 Physical tables "<TABLE_ONE>" and "<TABLE_TWO>" have multiple joins. Delete new foreign key object if it is a duplicate of existing foreign key.
Each of these errors points to different tables but they are all of the same type. Sensibly, error states that the tables in question have more than one join between them.
Reviewing Relationships, however, does not show anything unusual.
For every relationship reported as having multiple joins:
- Remove the join displayed in the relationships popup.
- Close/ Reopen Relationships.
See that the relationships deleted still exist.
For some reason,the admin tool copied these relationships twice into project. For me, this happened on recently added relationships between existing and new tables.
Oracle’s relationship tool, however, does not display more than one relationship between two objects. In this case, RPD somehow had the same relationship twice times. Deleting one left a proper relationship between tables.