This program is used in the accrual reconciliation process to populate the accrual reconciliation table with all the necessary transaction data. Running this program is normally the first step in that reconciliation process. See: Accrual Write-Offs.
After you have entered your receipt transactions, matched and approved your accounts payable invoices, you will need to run the accounting process that creates the accounting for these transactions in the final mode and subsequently transfer these transactions to the general ledger. You can then begin the accrual reconciliation process by running the Accrual Reconciliation Load program. This program is used to populate the accrual reconciliation table with all the necessary transaction data for you to perform the reconciliation process. The program can be run for an operating unit incrementally.
The program parameters, from date and to date, can be used to run the load incrementally. These two dates represent the transaction dates that are used to fetch the transaction information from the transaction tables. All the affected PO distributions (in the case of AP/PO transactions and individual transactions in the case of miscellaneous transactions) will be deleted first and the transaction information for these distributions will be fetched and loaded into the accrual reconciliation tables. The data in the accrual reconciliation table will be regenerated only for the specified date range; the rest of the data will remain as is.
When the accrual load program is run for the first time for a given operating unit, old write off transactions for that operating unit (write offs from prior releases) are upgraded and loaded into the new accrual reconciliation tables. The "from date" for this very first run is ignored and the load runs from the start of transaction history to the current system date (or the "to date" provided by the user). Additionally, you cannot reverse write off transactions that were written off in prior releases.
Since this process loads transactions from purchase order receipts and accounts payable invoices, you must install Oracle Purchasing and Payables to run this report.
In the Submit Requests window, select Accrual Reconciliation Load Run in the Name field.
Select the operating unit for which you want to load accrual data.
This is the first date from which the data will be rebuilt. You can schedule this program to run on a repeated basis, which will automatically update the from and to date parameters. If the program is scheduled to run every month, then the from and to date parameters will be automatically updated to reflect the first and last date of that month.
This is the last date from which the data will be rebuilt.