Cost_center_desc Change Capture Is Not Happening In W_gl_account_d Table (Doc ID 1131825.1)

Last updated on MARCH 08, 2017

Applies to:

Siebel Financial Analytics - Version: 7.9.6.1 and later   [Release: V7 and later ]
Information in this document applies to any platform.

Goal

SDE Map: SDE_ORA_GLAccountDimension
SIL map: SIL_GLAccountDimension

Source : Oracle R12

Currently in W_GL_ACCOUNT_D table we are having multiple Cost_center_desc attached to a single Cost_center. When we derive the incremental rows for GL_ACCOUNT_D from APPS to staging OOTB is not using table FND_FLEX_VALUES_TL and hence not capturing the last_update_date of this table as Auxiliary fields.

So, any changes in Description field of FND_FLEX_VALUES_TL with respect to a FND_FLEX_VALUES.FLEX_VALUE is not captured .

However W_CODE_D has proper Insert/ update logic so, it is always having latest cost_center_desc for a cost_center_num. But, those changed cost_center_num are not updated with latest Cost_center_desc in W_GL_ACCOUNT_D.

Please could you :
- confirm us if the behavior is expected?
- if it can be easily change to fit ours requirements?


Solution

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