Monday, January 14, 2013

[DAC] GL ACCOUNT VALUES ARE NULL


Applies to:

Business Intelligence Applications Consumer - Version: 7.9.6 [1340] - Release: V7
Information in this document applies to any platform.

Goal


Comments
--------
=== ODM Question ===

In table W_GL_ACCOUNT_D values ACCOUNT_SEGx_CODE, ACCOUNT_SEGx_NAME and ACCOUNT_SEGx_ATTRIB are NULL (where x are from 1 to 10) are NULL. I have already configured GL Account Hierarchies (according to section 3.2.1.6 in configuration guide for Informatica) using 3.2.1.6.2 section - because I have FSG hierarchy.

What I've discovered is that GL segment parameters are taken in mapplet mplt_SA_ORA_GLAccountDimension in lookup LKP_HIER_CONFIG. This lookup uses table W_GLACCT_SEG_CONFIG_TMP. This table takes values from file_glacct_segment_config_ora.csv file. How to configure this file it is described in section 3.2.1.6.1.

So maybe should I also configure this file even though I'm using FSG hierarchy (and configure system according to 3.2.1.6.2, not the 3.2.1.6.1 section?? Or there is another problem that causes the NULL values??



Solution


Comments
--------
=== ODM Answer ===

Yes, if you want the segment dimension to be populated correctly, you should follow the segment config file instruction content in section 3.2.1.6.1.