Oracle allows us to create 2 Foreign Key constraints on 1 column.
But If I insert a record that satisfies one Foreign Key constraint, then the other Foreign Key constraint complains.

Is there a way we can use both the constraints & insert records that satisfies only one constraint at a time?

Looking for an expert opinion.

Thanks in advance.