Open AP 11i - As on date for Conversion
We are going for migration from 11i to R12, for that we need Open AP Conversion data.
But the problem is that we are unable to fetch the Open AP data for all the Liability Accounts and OUs at one time, the data volume being so huge ( approx. 6.6 million total invoices)
So its becoming somewhat impossible to get the Open AP data (with As on Date logic).
We have to take only the Acounted Open AP for conversion which should match with the Trial Balance.
Pls. share any tuned query for Open AP.
It would be a great help.