EFPA Time Dimension Population Does Not Consider FSI_FISCAL_YEAR_INFO (Doc ID 2099663.1)

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)

Symptoms

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.

ACTUAL BEHAVIOR
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.

EXPECTED BEHAVIOR

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

Declare
num number;
Begin
-- 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;
  COMMIT;
  
  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');
  end if;
  
EXCEPTION
WHEN OTHERS THEN
  raise;
End;

Cause

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