EFPA FCT_LEDGER_STAT Transformation Ignores the PSource_Type Parameter (Doc ID 1980332.1)

Last updated on OCTOBER 12, 2015

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
PFTBI
PFT BI

Symptoms

On EFPA 6.1, it appears that the the LEDGER_STAT_TRM transformation which moves data from LEDGER_STAT to FCT_LEDGER_STAT ignores the pSource_Type parameter.

ACTUAL BEHAVIOR
When fct_ledger_stat transformation rule is executed with pIdentity_Code and pSource_Type parameter values as “null and 0”, the transformation rule loads all rows from ledger_stat into fct_ledger_stat irrespective of the source type value.
 
EXPECTED BEHAVIOR
Expect if pSource_Type = 0, only ledger stat loaded rows with FSI_DATA_IDENTITY.SOURCE_TYPE = 0 to be loaded. Also expect if pSource_Type = 100, only allocation rows with FSI_DATA_IDENTITY.SOURCE_TYPE = 100 to be loaded.

The issue can be reproduced at will with the following steps:

1: transformation rule log indicating parameters used:
 
Log Message here 1: Tue Dec 9 09:31:28 2014||INFO||Parameters : fsi_ledger_stat_trm,'MPADOMAIN_Fact_Table_Transformation_1_20140831_2','20140831',1,12,2014,null,0,'Y','VND'
Log Message here 1: Tue Dec 9 09:31:28 2014||INFO||Statement to execute : BEGIN :D := fsi_ledger_stat_trm('MPADOMAIN_Fact_Table_Transformation_1_20140831_2','20140831',1,12,2014,null,0,'Y','VND'); END;
Log Message here 1: Tue Dec 9 09:31:45 2014||INFO||Fetching the return status.
Log Message here 1: Tue Dec 9 09:31:45 2014||INFO||Return value From the Stored Procedure : 1
Log Message here 1: Tue Dec 9 09:31:45 2014||INFO||execPackage : return val : 1
Log Message here 1: Tue Dec 9 09:31:45 2014||INFO||After Calling execProc
Log Message here 1: Tue Dec 9 09:31:45 2014||INFO||Return value - from execproc - 1
Log Message here 1: Tue Dec 9 09:31:45 2014||INFO||Successfully executed the procedure

 
2. identity_code wise source_types:
 
SQL> select distinct identity_code, source_type from fsi_data_identity;
 
IDENTITY_CODE SOURCE_TYPE
------------- -----------
  10585 100
  10584 0
 
3. rows with identity_code (10585) also loaded in fct_ledger_stat though their source_type<>0:
 
SQL> select n_identity_code, count(1) from fct_ledger_stat group by n_identity_code;
 
N_IDENTITY_CODE COUNT(1)
--------------- ----------
  10585 67236
  10584 134472

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