My Oracle Support Banner

Calendar For MFP FY is Required to Start On January (Doc ID 3072614.1)

Last updated on FEBRUARY 21, 2025

Applies to:

Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version NA and later
Information in this document applies to any platform.

Goal

The user's calendar has the following properties (calendar 5-4-4 and fiscal year starts on JANUARY)
This calendar was uploaded to AIF-DATA and then moved to PDS using the following jobs:
1. C_LOAD_DATES_CLEANUP_ADHOC
2. HIST_ZIP_FILE_LOAD_ADHOC
3.RI_DIM_INITIAL_ADHOC
4. LOAD_PDS_DIMENSION_PROCESS_ADHOC
 
From MFP the user imported the calendar using interface
imp_hier1 | interface | W_PDS_CALENDAR_D
 
Import has finished successfully, but on checking the calendar in measure analysis it can be see that the first weeks of 2025 are assigned to month Feb FY2024, instead of Jan FY2024.
 
Parameter START_OF_YEAR_MONTH in MFP in aa C_ODI_PARAM is set to JANUARY
 
How can the user configure January as the first month in the Fiscal Year?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.