Mirror of Oracle documentation

Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.

4 MFP Setup Task

MFP Setup is part of the MFP Maintenance Activity. In MFP Setup, the administrator will maintain basic application settings related to the planning calendar, local currency, and VAT.

The steps within the MFP Setup Task:

  • History Mapping Step

  • Local Currency Step

  • VAT Setup Step

  • Batch Setup Step

History Mapping Step

The History Mapping step is used by the administrator to map the weeks for last year and last last year (two years ago). Using History Mapping, the administrator can map up to two years back.

The History Mappings step contains one view, History Mapping.

History Mapping View

When a new calendar year is loaded, these values are automatically populated for the new year by the weekly batch. Use this view to make any updates needed in week mapping to most accurately account for moving holidays, promotions, and also to set up 52 to 53 week mappings.

The last year’s (Ly) mapping is used to identify which week to map to in order to Seed from Ly, and review Ly values in a workspace.

The last last year (Lly) is used to identify which week to map to for reviewing history from two years prior in a workspace.

Note

A week can be mapped to more than one Ly or Lly week to account for 53 week years. Separate weeks with a comma. If more than one week needs to be assigned, then those week positions should be separated with a space. Those week positions data will then be aggregated.

HistoryMapping
v
F
Measure(Default
)
+ 2
iaCalendar
CalendarMeasureLagLytTLag LlyTWeek Id@
T
2/8/2020w01_2021w01_2020
2/15/2020w02_7021w02_2022wO02_2020
2/22/2020w03_2021w03_2022w03_2020
2/29/2020w04_2021w04_2022w04_2020
3/7/2020w05_2021w05_2022w05_2020
3/14/2020w06_7021w06_2022w06_2020
3/21/2020w07_2021w07_2022wO7_2020
5/28/2020w08_2021w08_2022w08_2020
4/4/2020w09_2021w09_2022wO09_2020
4/11/2020w10_2021w10_2022w10_2020
4/18/2020w11_2021w11_2022w11_2020
4/25/2020w12_2021w12_2022w12_2020
5/2/2020w13_2021w13_2022w13_2020

Table 4-6 Export Setup View Measure

MeasureDescription
Export MaskAllows the user to control which positions are exported for
all plan versions. When selected, the Department/Channel/
Half is included when exporting plan data. By default, this
Boolean is checked for all positions. If the user wants to
exclude any Department/Channel/Half from exporting, the
user must un-check this Boolean.

The export flags are set based on Export Mask and Approved or Submitted Info for Approved or Submitted Plans and Seeded Info for Working Plans.


In this guide