Database Integration

Hi,
Currently, my database logical view as follow
1. ERP database server on 192.168.1.2
2. WMS database server on 192.168.1.3
3. TMS database server on 192.168.1.4
How ERP, WMS and TMS communicate each other?
1. ERP will insert the data into IntegratedDB on ERP database server
2. Then, WMS database server and TMS database server will do the pickup from IntegratedDB and inserting/updating IntegratedDB respectively
3. Finally, ERP will query back from IntegratedDB and updating ERP database respectively
*IntegratedDB on 192.168.1.2
*Looks like IntegratedDB is a middle database
*There's no acknowledgement will pass back to the sender if the data has been processed successfully

FYI, there's no integration tools such as MSMQ, SSIS, SQL Service Broker, AS2 and so on was used.
Recently, this was happen
1. The data appear in ERP Database
2. The data appear in IntegratedDB
3. The data appear in WMS Database
4. But, the data not appear in TMS Database
*At this level, looks like the data was imbalance
*At this level also, there's no guaranteed delivery

Once the problem was rectified, looks like TMS Integration Component was corrupted. I saw, this database integration architecture have no rollback capability if unexpected problem happen
My humble opinion, if any of the database partner in this database integration architecture have a problem, all the database should fallback as a usual.
My question as follow
1. Did this database integration architecture is acceptable?
I hope someone can give the comment.