I'm new to Oracle Apps and right now i'm working on an issue where the total outstanding amount in AR Reconciliation Report and AR Aging 7-Bucket Report differ. Right now i'm clueless as to how to approach this problem in order to resolve it. Reconciliation is something i'm not much familiar with. So, any help towards resolving this issue would be greatly appreciated.
The following are the details of the instance i'm working upon,
RDBMS : 220.127.116.11.0
Oracle Applications : 12.1.1
System Date : 29-OCT-2012 17:21:00
Please guide me through the process to resolve this difference in total amounts outstanding.
I didn't get what you just advised me to do. There is a difference between the total outstanding amounts calculated in AR Aging 7-bucket report and the AR to AR Reconciliation Report. So, i was asking for steps towards identifying the root cause for this issue.
The report has the parameters GL Date From and GL Date To. Don't know which is your case but let's suppose you are getting a difference in the period 01-sep-12 to 30-sep-12. Run the report for a shorter period, let's say 01-sep to 15-sep and see if the difference remains. If yes, run it for a shorter period within this one until you get the exact period where the difference occurs. Then you can identify which transactions are causing the difference.