Create an Aging Method

This example demonstrates how to create an aging method not predefined in Oracle Fusion Advanced Collections.

Your company requires an aging method that is not a collections predefined aging method. You are to create a new aging method. Use the default values except where indicated. Create an aging method named 1 to 120 Days Method, with the following segments:

Sequence

Bucket Type

Aging Days From

Aging Days To

Aging Bucket Heading

1

Current

-9999

0

Current

2

Past Due

1

45

45 Past Due

3

Past Due

46

60

60 Past Due

4

Past Due

61

90

90 Past Due

5

Past Due

91

120

120 Past Due

6

Past Due

121

9999

121+ Past Due

Creating an Aging Method

  1. Start from the Manage Aging Methods page.

  2. From the Aging Method region, click the green plus sign to create an aging method.

  3. Complete the fields, as shown in this table.

    Field

    Value

    Aging Method Name

    1 to 120 Aging Day Method

    Aging Type

    Statement Aging; 4 bucket and 7 bucket aging are options, depends on the number of buckets for your aging method.

    Enable

    Yes

    Aging Method Set

    Common Set

    Aging Method Description

    Current to 120 Day Aging method.

  4. Click Save.

  5. From the 1 to 120 Aging Day Method: Details, complete the fields, as shown in this table.

    Field

    Value

    Sequence

    1

    Bucket Type

    Past Due

    Aging Days From

    1

    Aging Days To

    45

    Aging Bucket Heading

    45 Past Due; Click the Create icon to create the row for the next sequence.

    Sequence

    2

    Bucket Type

    Past Due

    Aging Days From

    46

    Aging Days To

    60

    Aging Bucket Heading

    60 Past Due

  6. Repeat the steps for sequences 4 to 6 and increase the Aging Days From and Aging Days To accordingly.

  7. Click the Save and Close to complete the creation of a new aging method.

    The following validation rules are in place when creating or modifying an aging method:

    • A bucket must contain at least 2 bucket lines and at most 7 lines.

    • A Bucket Type passes from the user interface as a fixed constant value.

    • A bucket must have Aging Days From less than Aging Days To.

    • All buckets must cover the range from -9999 to 9999 and there is no way to update a field with the value of -9999 or 9999.

    • Aging buckets cannot have any gaps between -9999 to 9999.