Cost_center_desc Change Capture Is Not Happening In W_gl_account_d Table
Last updated on MARCH 08, 2017
Applies to:Siebel Financial Analytics - Version: 220.127.116.11
Information in this document applies to any platform.
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?
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