Source Mappings

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:

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:

  1. In the Tasks pane, select Period Mapping.

  2. Select Source Mapping.

  3. In the * Source Mapping drop-down, select the source system.

  4. 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

  5. Click Add.

  6. Enter the source system Period Name, and then click OK.

  7. Enter the source system Period Key, and then click OK.

  8. Enter the source system Calendar, and then click OK.

  9. Enter the source system GL Period, and then click OK.

    The GL Period Number is prefilled automatically based on the Period Name.

  10. Enter the source system GL Name, and then click OK.

  11. Optional: Enter a description for the mapping.

  12. Click Save.

  To create source period mappings:

  1. In the Tasks pane, select Period Mapping.

  2. Select Source Mapping.

  3. In the * Source Mapping drop-down, select the source system.

  4. Click Add.

  5. Click Search button. to select the source system Period Key, and then click OK.

  6. Click Search button. to select the source system Calendar, and then click OK.

  7. Click Search button. to select the source system Adjustment Period, and then click OK.

  8. 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.

  9. Optional: Enter a description for the mapping.

  10. Click Save.

Tip:

To delete a mapping, select the mapping, then click Delete.