My Oracle Support Banner

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 FEBRUARY 22, 2019

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6 [1340] and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] 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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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