Source mappings include explicit and adjustment period mappings. You can create explicit period mappings to ensure that the ERP Integrator 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 ERP Integrator 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 or Explicit period mapping. If you choose period mapping, then source periods are mapped based on the period key and prior period. |
To create explicit period mappings:
In the * Source Mapping drop-down, select the source system.
In the Mapping Type drop-down, select Explicit.
For all other systems (for example, EBS or Fusion), you can select explicit and adjustment.
SAP/ source systems user must define Explicit period mappings
Enter the source system GL Period, and then click OK.
The GL Period Number is prefilled automatically based on the Period Name.
To create source period mappings:
In the * Source Mapping drop-down, select the source system.
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, since PeopleSoft Adjustment Periods definitions do not include a Year value. To properly map adjustment period data from PeopleSoft, you must define the source accounting period and fiscal year intersections for all PeopleSoft adjustment periods.
Tip: | To delete a mapping, select the mapping, then click Delete. |