R09801 Insert Unsuccessful Error on AP M Type Vouchers

I am facing some strange issue on a very occasional pattern. While trying to post batch to GL, for manual payments type M very sporadically the user gets an error 'Insert Unsuccessful'. The same user using the same ID and role can post for other batches but not some. It happens very random. I have checked the security records for the role and all seems correct as per the requirement. Below is a list of tables with the data item secured -

F011 (User)

F0901 (Co)

F0006 (Mcu)

F0902 (Co)

F0911 (Co)

F0413 (Pye)

F0414 (An8)

The error in the work centre is not very helpful with just 'Insert Unsuccessful'.