OBIA 7.9.6.x ACCOUNT_SEG_NAME And COST_CENTER_DESC Is Not Getting Updated On W_GL_ACCOUNT_D (Doc ID 1562778.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Business Intelligence Applications Consumer - Version 7.9.6 [1340] and later
Information in this document applies to any platform.

Symptoms

User has 13 segment GL Account, On the W_GL_ACCOUNT_D dimension the Descriptions for the 13 segments on the existing records are getting updated when there is an update on the OLTP system, But the new accounts that are getting inserted are getting updated descriptions.

The names and descriptions for Cost Center and Profit Center are obtained from the code dimension table and these dimensions are actually loaded from the GL account dimension table. So if the description was changed and the corresponding CCID’s (GL accounts) for that CC or PC doesn’t come in the incremental, then the right descriptions / names won’t be displayed.

Cause

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