We are Intermittently getting error 'ORA-02049: timeout: distributed transaction waiting for lock.
The application is just trying to do 2 transactions in the transaction scope for a parent and child tables.
Example - Table 1 is Parent Table AND Table 2 is Child Table
The application inserts the record in Table 1 and in the same transaction scope application tries to add the related record in the child table.
This is a really simple code. We tried this test when no one was accessing the database. Surprisingly, it is an intermittent issue.