My Oracle Support Banner

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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.