Source Mappings

Source mappings include explicit and adjustment period mappings. You can create explicit period mappings to ensure that the FDMEE periods map correctly to the source system calendar periods. An adjustment period mapping is used only when you select the Include Adjustment Periods option when creating the data load rule.

The Source Mapping tab consists of two areas:

Master—Selects the source system and mapping type
Grid—Defines the period mapping. The mapping can be defined only for periods defined on the Global Mapping. New FDMEE periods cannot be created on this tab.

For (EBS, Fusion, and PeoplesSoft) source systems, you can select explicit or adjustment systems. For all other systems, you can select only an explicit mapping.

Note:

In Data Rules, you can choose between Default period mapping and Explicit Period mapping. When you choose Period mapping, then source periods are mapped based on the period key and previous period.

To create source mappings:

Select the Setup tab, and then under Integration Setup, select Period Mapping.
In Period Mapping, select the Source Mapping tab.
In Source Mapping, select the source system.
In Mapping Type, select Explicit.
For SAP and JD Edwards source systems, you must select Explicit period mappings
For all other systems (for example, EBS and Fusion), you can select Explicit or Adjustment.
Click Add.
Enter the source system Period Name, and then, click OK.
Note:
Period names cannot include spaces when used in a batch script.
Enter the source system Period Key, and then, click OK.
Enter the source system Calendar, and then, click OK.
Enter the source system GL Period, and then, click OK.
The GL Period Number is prefilled based on the Period Name.
Enter the source system GL Name, and then, click OK.
Optional: Enter a description for the mapping.
Click Save.

To create source period mappings:

Select the Setup tab, and then under Integration Setup, select Period Mapping.
In Period Mapping, select the Source Mapping tab.
In Source Mapping, select the source system.
Click Add.
Click to select the source system Period Key, and then, click OK.
Click to select the source system Calendar, and then, click OK.
Click to select the source system Adjustment Period, and then, click OK.
For PeopleSoft source systems only: In GL Period Year, enter the general ledger period year.
The general ledger period year is required for PeopleSoft source systems because PeopleSoft Adjustment Periods definitions do not include a Year value. To properly map adjustment period data from PeopleSoft, define the source accounting period and fiscal year intersections for all PeopleSoft adjustment periods.
Optional: Enter a description for the mapping.
Click Save.

To create budget period mappings (for PeopleSoft Commitment Control only):

Select Source Mapping.
In Source Mapping, select the source system.
Click Add.
In Mapping Type, select Budget.
Note:
From PeopleSoft Commitment Control, only Budget Period Data can be extracted. The source calendar / period are determined based on control budget definition in PeopleSoft.
In Period Name, specify the period name.
You can also click to search for the period name.
Note:
Period names cannot include spaces when used in a batch script.
Enter the source system Calendar, and then, click OK.
You can also click to search for the calendar name.
Enter the source system GL Period, and then, click OK. You can also or click to search for and select the GL period name.
The GL Period Number is prefilled automatically based on the Period Name.
Optional: Enter a description for the mapping.
Click Save.

Tip:	To delete a mapping, select the mapping, and then, click Delete.