Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Financial Analytics > Process of Configuring Oracle Financial Analytics for Oracle 11i >

Configuring the AP/AR Aging Tables

This section explains how to control the lengths of the aging buckets in the AP and AR aging snapshot tables. These tables are:

• W_AP_AGING_INVOICE_A
• W_AR_AGING_INVOICE_A
• W_AP_AGING_SUPPLIER_A
• W_AR_AGING_CUSTOMER_A

In these four tables, outstanding AP/AR balance information is broken out into rows. Each row represents the outstanding balance information for a particular aging bucket. Four aging buckets are provided out-of-the-box, with the following lengths:

• Bucket 1: 0 - 30 days
• Bucket 2: 31 - 60 days
• Bucket 3: 61 - 90 days
• Bucket 4: 90+ days

Use the DAC to configure the lengths of these aging buckets, as described below.

To configure the length of aging buckets

1. Click on the 'Tasks' tab.
2. Query for the following tasks
   • PLP_APSnapshotInvoiceAging
   • PLP_ARSnapshotInvoiceAging
3. For each of these tasks, click on the 'Parameters' tab and update the parameters with names starting with '$$BUCKET'.
4. Save your work.

These aging tables are snapshot tables. You can also control how many historic month end snapshots you want to keep in these tables (the default value is 24 months). You can increase or decrease the number by adjusting the $$HISTORY_MONTHS parameter.