can't closing AP period

EBS r12
hi all,

I can't closing AP period because there is any exception , exception is payment transaction cannot create acounting,
i have get some solution that is sweep exception to future period

I have tried Sweep Exception, but we think that's not a solution.
It just defer the problem. How about if we delete that payment transaction through database?
Could you give us the datafix to delete particular payment transaction, I we can close the period?

Thanks
Aries