Revaluation: GL Module 12 Release New Features

Revaluation:  GL Module 12 Release New Features, askHareesh blog for Oracle Apps


This section discusses upgrade details regarding revaluation and revaluation sets in Oracle General Ledger Release 12.

Revaluation Adjustments Involving Period Rates

In Release 11i, revaluation adjustments could be calculated using period rates, daily rates of a specified rate type, or user-entered rates specified at run time for the revaluation request. Revaluation sets were specific to a set of books.

For the Release 12 upgrade, set of books-specific period rates are merged into the daily rates model, identifiable by unique period-end and period-average rate types. Under
this new model, revaluation adjustments are calculated with the option of either using daily rates of a specified rate type or one-time, user-entered rates specified for the revaluation; the period rates option has now been removed from the user interface. It is also now possible to share revaluation sets across ledgers that share a common chart of accounts.

The upgrade process merges the period rates with the daily rates model by assigning system-generated period-end and period-average rate types to sets of books when converting them to ledgers. Existing revaluation sets that were assigned the period rates option are modified to use the daily rates type option. The rate type assigned to each revaluation set corresponds to the system-generated, period-end, rate type assigned to the upgraded ledger.

Revaluation Sets Involving Secondary Segment Tracking

In Release 11i, revaluation sets were specific to the set of books. It was possible to have gain/loss templates correspond to the setting for the secondary segment tracking revaluation option on the set of books. Alternatively, the templates could also correspond to the profile option that controlled cost center tracking. For example, if secondary segment tracking was enabled for the set of books, the secondary tracking segment in the gain/loss account templates would be filled in dynamically by the revaluation program and could not be updated by the user. The balancing segment was always non-updateable for the templates because this was dynamically determined in
all situations.

In Release 12, it is now possible to share revaluation sets across ledgers that share a common chart of accounts. These ledgers may have different settings for secondary segment tracking or for the cost center tracking profile option. The gain/loss account templates for revaluation sets have been updated to only have a non-updateable field for the balancing segment; all other segments require a segment value. This makes the revaluation set equally usable for all ledgers regardless of how they track revaluation.

During the upgrade, revaluation sets will keep the same gain/loss account templates as originally defined. Where there are non-balancing segments that are missing an account value in the templates, it is not possible for the system to assign appropriate account values.
In Release 12, however, the system requires all segments, except the balancing segment, in the templates to contain values, so users will need to enter values for these segments prior to running revaluations with the upgraded templates.

The non-balancing segments that require attention applies to users who satisfy the following conditions:

• Users have multiple sets of books in Release 11i.
• The sets of books share the same chart of accounts.
• The sets of books are configured with different settings for the revaluation option for secondary segment tracking.
• Users want to run revaluation for upgraded sets of books that did not have the secondary segment tracking enabled for revaluation in Release 11i.