EFPA Time Dimension Population Does Not Consider FSI_FISCAL_YEAR_INFO
Last updated on JANUARY 21, 2017
Applies to:Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.1.1 and later
Oracle Financial Services Profitability Management - Version 6.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
Oracle Financial Services Profitability Management (PFT)
On EFPA 6.1.1, the transform for the Time Dimension Population does not consider FSI_FISCAL_YEAR_INFO for fiscal year which are not equal to calendar year.
When executing FN_DIM_DATES function the yearly quarter dates are not based on the data from FSI_FISCAL_YEAR_INFO but seems to be based solely on a calendar type fiscal year.
Expect fn_dim_dates to take into account fsi_fiscal_year_info for non calendar year.
The issue can be reproduced at will with the following steps:
1. Populate FSI_FISCAL_YEAR_INFO with non standard start month
2. Run fn_dim_dates
-- Population of DIM_DATES Table (It should be executed for each year for which data is present in the source table)
delete from dim_dates;
num := FN_DIM_DATES('INFODOM_WB_DIM_DATES_POP_001','20140101','20140101','20161231'); -- start date, end date
if num=0 then
raise_application_error(-20010, 'fn_ledgerDataLoader - failed');
WHEN OTHERS THEN
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms