Oracle Error ORA-02047: cannot join the distributed transaction in progress

Oracle Error Message

ORA-02047: cannot join the distributed transaction in progress

Reason for the Error

Either a transaction is in progress against a remote database that does not fully support two phase commit, and an update is attempted on another database, or updates are pending and and an attempt is made to update a different database that does not fully support two phase commit.

Solution

complete the current transaction and then resubmit the update request.