API to mark Payments as CLEARED and Statement Lines as EXTERNAL

Hi All,

We have the following scenario.

We are on R12  (GL, AP, CE and PO) and we have been using Cash Mangement since Jan 2011. But the Cash management was not actively used as they did not see any business need. But we have been getting BAI files everyday and are automatically processed. When I looked at the interface tables, there were around 1500 statements in error, a lot of statement lines in Unreconciled status and Payments in NEGOTIABLE status.

Now our business wants to start using CE actively. But we are finding it difficult to clean up the history data. We are planning to do the following: