we are facing a performance and locking problem on our IS-Retail system and more specific when we are running WA08 to create subsequent documents through Allocation Tables.
In many cases when two ore more users execute this transaction we are facing locking problem - ENQUEUE Excl(Cumulative) AUKO 200$$$$$$$$$$ -
We found that there is the index FR2 on table FRET which is not activated in Database and we also show that the locking is last so much time exactly at the point of select on this table.
Does anyone faced this situation in the past ?
Is it safe to activate this index?
Thank you in advance.