Cost_center_desc Change Capture Is Not Happening In W_gl_account_d Table
(Doc ID 1131825.1)
Last updated on DECEMBER 18, 2019
Applies to:Siebel Financial Analytics - Version 184.108.40.206 and later
Information in this document applies to any platform.
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document