Segment Rules and Account Rules for Chart of Accounts Mapping

The chart of accounts mapping feature supports the ability to correlate a source chart of accounts to a target chart of accounts to allow for the processing of balances or amounts.

Use either segment rules, account rules, or a combination of both. A chart of accounts mapping is used by the posting process in propagating transactions from the primary ledger to its secondary ledger. The mapping feature is used by both balance transfer processes for balance level secondary ledgers as well as cross ledger transfers. The balances are copied from one ledger to another ledger in both processes.

You can define chart of accounts mappings using the Manage Chart of Accounts Mapping task. If you’re defining mappings that include only segment rules, you can also use the Chart of Accounts Mapping Rules Import file-based data import (FBDI).

Segment Rules

Use segment rules to map each segment of the target chart of accounts to an account value, or to one or two segments in the source chart of accounts. You can select from among three different mapping methods:

• Assign a constant value for a segment in the target chart of accounts.

• Copy the value from the source segment to the corresponding target segment.

  Note: To use this method, the value sets for the paired target and source segments must share identical values.

• Use rollup rules to aggregate one or two source segments to a corresponding target segment.

  • Create a single value mapping when a specific detail source segment value is given a detail target segment value.

  • Use hierarchical rollup rules when a specific parent source value and all of its child segment values are mapped to a given detail target segment value. This provides the ability to process groups of source segment values in one single rollup rule.

  • Define parent source values in rollup rules when date effective versions of the hierarchy are used with the accounting date of the transactions by the processes that reference the chart of accounts mapping. The additional benefit of self-maintaining mappings is that if the hierarchies referenced change with time, the applicable child values are updated automatically.

Account Rules

Account rules map a complete target account combination against one or more source account combinations. The source account combinations can be defined segment by segment using:

• Single detail account values

• Detail account value ranges

• Parent values for primary balancing and natural account segments

  Note: When using parent values, its child values for the date effective version of the hierarchy are processed when the mapping is called.