Specifying Ledger Mapping Defaults

As a next step you need to specify your ledger and ChartField mapping.

On the Ledger Mapper Defaults pages, you specify the defaults and behavior for the Ledger Mapper page in EPM. The defaults you specify here determine how a new row in the Ledger Mapper page is presented and edited. You can override the defaults later on the Ledger Mapper page if you want to set up your mappings differently.

You use the Ledger Mapper to map data, such as assets and liabilities, that does not come into the system through one of the optional analytical applications. The Ledger Mapper is described later in this documentation.

This topic discusses how to:

Specify tree views.
Specify trees, default values, and validation.
Set ledger mapping tree usage.

Pages Used to Set Up Ledger Mapper Defaults

Page Name	Definition Name	Navigation	Usage
Ledger Mapper Defaults	PF_LED_TMPL_TBL1	select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledgers, then select Ledger Mapper Defaults, then select Ledger Mapper Defaults	Specify tree views to filter the tree information you've set up for your ledger and ChartField mappings.
Ledger Mapper Defaults II	PF_LED_TMPL_TBL2	select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledgers, then select Ledger Mapper Defaults, then select Ledger Mapper Defaults II	Specify the trees, default values, and validations that define how your ledgers and ChartFields roll up, which default values to draw from, as well as whether or not to allow blank values.
Map Ledger to Tree	PF_LM_TOPT_TBL1	select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledgers, then select Map Ledger to Tree	Set ledger mapping tree usage.

Common Elements Used to Specify Ledger Mapping Defaults

ChartField

The ChartFields that appear on the list come from the LEDMAP_CHART subrecord.

Ledger Mapper Defaults Page

Use the Ledger Mapper Defaults page (PF_LED_TMPL_TBL1) to specify tree views to filter the tree information you've set up for your ledger and ChartField mappings.

Navigation

select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledgers, then select Ledger Mapper Defaults, then select Ledger Mapper Defaults

Image: Ledger Mapper Defaults page

This example illustrates the fields and controls on the Ledger Mapper Defaults page. You can find definitions for the fields and controls later on this page.

ChartField

The page displays the ChartFields: map from ledger, general ledger account, operating unit, department ID, and product.

Tree View Name

For each ChartField, specify the appropriate tree view name. The prompt displays all views that have Set Control Field as BUSINESS_UNIT and TREE in the name of the view.

Treenode View

For each ChartField, specify the appropriate treenode view name.

Note: If you configure ChartFields of your own to add to the system, you will need to duplicate the tree view, treenode view, and prompts. The system uses the specified views to select members from the trees you specify on the Ledger Mapper Defaults II page.

Ledger Mapper Defaults II Page

Use the Ledger Mapper Defaults II page (PF_LED_TMPL_TBL2) to specify the trees, default values, and validations that define how your ledgers and ChartFields roll up, which default values to draw from, as well as whether or not to allow blank values.

Navigation

select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledgers, then select Ledger Mapper Defaults, then select Ledger Mapper Defaults II

Image: Ledger Mapper Defaults II page

This example illustrates the fields and controls on the Ledger Mapper Defaults II page. You can find definitions for the fields and controls later on this page.

Tree Name

For each ChartField including your ledger, select the appropriate tree name from which you'll map values. The tree you select should also represent how your ChartFields roll up for reporting purposes. The tree name is required if you select the Tree check box.

Defaults

Select whether to map all values in the system for the ChartField row or only to those values that are filtered out through the tree and tree views you selected. If you select Tree, the system requires you to enter the tree name.

Validation

To disallow the selection of blank values from prompts and drop-down list boxes for a specific ChartField or for your ledger, select the appropriate validation check box. This validation occurs on saving the Ledger Mapper Defaults component.

Map Ledger to Tree Page

Use the Map Ledger to Tree page (PF_LM_TOPT_TBL1) to set ledger mapping tree usage.

Navigation

select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledgers, then select Map Ledger to Tree

Image: Map Ledger to Tree page

This example illustrates the fields and controls on the Map Ledger to Tree page.

To specify whether a tree will be used while mapping the ChartField select the appropriate check box in the Select ChartFields to use trees group box.

Note: This page is used for general ledger mapping in addition to ABM ledger mapping. This page and the Ledger Mapping Defaults pages should be defined before you create ledger mapping rules.