Setting Up Ledger Source

This section provides an overview of ledger source setup and discusses how to set up ledger source IDs.

Pages Used to Set Up Ledger Source

Page Name	Definition Name	Navigation	Usage
Ledger Source	ABM_SOURCE_TBL	select Activity Based Management, then select Setup, then select Ledger Source, then select Ledger Source	Identify the datamap containing the source record of information to be mapped and specify the ChartFields to use.

Understanding Ledger Source Setup

Use the Ledger Source page to specify which source (record) datamap and which source-ledger ChartFields (dimensions) you want to map to Activity-Based Management. All ChartFields are available. For example, you may be particularly interested in mapping the sub-account and project-related ChartFields. You can map up to eight ChartFields at a time. (Each ChartField that you select impacts system performance; therefore, select only those ChartFields that you need.) Based on the needs of your implementation, you can even map a null ChartField value.

The combination of the ChartFields that you select must be a unique key in the datamap. Those fields should be keys in the primary table or record metadata. If not, the system displays a duplicate row type error when running the ABC engine (for example, if Ledger Source TEST has Ledger, Account, and Operating Unit ChartFields). This means that the datamap for that Ledger Source must have these fields as keys (or the primary table that creates that datamap/tablemap must be grouped by ledger, account, and operating unit) to assure that the key is unique.

Ledger Source Page

Use the Ledger Source page (ABM_SOURCE_TBL) to identify the datamap containing the source record of information to be mapped and specify the ChartFields to use.

Navigation

select Activity Based Management, then select Setup, then select Ledger Source, then select Ledger Source

Image: Ledger Source page

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

Source ID

Displays the identifier of the selected ledger source (record).

Note: Activity-Based Management can take data from all EPM applications and tables. At a minimum, the source table must include the following fields: Business Unit, Accounting Period, Fiscal Year, Currency Code, and at least one CHARTFIELD and one Measure field.

DataMap Code

Enter the code associated with the datamap (table) to be used for the source.

Note: By default, the source datamap is based on PS_LEDGER as the fact table.

Measure

Enter the measure field to be used.

If it is the ledger, you can enter the posted total amount.

BCE Measure (base currency equivalent measure)

Enter the measure in base currency.

Source Unit

Enter the source unit.

CHARTFIELD (1 to 8)

Enter up to eight distinct ChartField dimensions from the source table to use as ChartFields.

Note: The following default ChartField dimensions from the EPM copy of source ledger data are available: LEDGER, ACCOUNT, OPERATING_UNIT, DEPTID, PRODUCT, AFFILIATE, STATISTICS_CODE, and PROJECT_ID.

Note: Only one ChartField configuration is necessary per database; multiple rows on this page are not required.