AR LOCKBOX: What is the best way to clean old transmissions with status NB(New), OP(Open), OOB(Out O
Hi,
We are in R12.
Under AR Responsibility: Interfaces > Lockbox: to launch the 'Lockbox Submission Options', we have old Transmission Names showing in the LOV.
From back-end, I can see some of them are in different status AR_TRANSMISSIONS_ALL.STATUS --> NB (New), OP(Open) and OOB(Out Of Balance).
What is the best way to clean up our database so that those transmission names does not appear any more in this LOV and are used by mistake by the users?
Is it ok to run a data fix script from back end to update the status field in table AR_TRANSMISSIONS_ALL to CL(Closed)?
We are in R12.
Under AR Responsibility: Interfaces > Lockbox: to launch the 'Lockbox Submission Options', we have old Transmission Names showing in the LOV.
From back-end, I can see some of them are in different status AR_TRANSMISSIONS_ALL.STATUS --> NB (New), OP(Open) and OOB(Out Of Balance).
What is the best way to clean up our database so that those transmission names does not appear any more in this LOV and are used by mistake by the users?
Is it ok to run a data fix script from back end to update the status field in table AR_TRANSMISSIONS_ALL to CL(Closed)?
0