which is the correct value for parameter ORA_CUBEINDEX_INITRANS in table rsadmin?
I have a deadlock during insert in fact table
We have had problems with deadlocks as well, but it turned out to be related to bitmap indexes rather than the initrans settings which was the first thing we examined.
If it is related to concurrent attempts to update the bitmap indexes, the best thing to do is drop the indexes before loading. You would want to do this for load performance reasons any way.