My Oracle Support Banner

Oracle BI Applications: Peoplesoft Account Descriptions Do Not Appear In GL Segment Dimension (Doc ID 1561982.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.6.2 and later
Information in this document applies to any platform.
BI Apps Build: 7.9.6.3.042811.1900
Release Version: Oracle Business Intelligence Applications 7.9.6.3
Package: 042811.1900

Source OLTP version and type: Peoplesoft Financial 9.0

Mapping or maplet name
- SDE_PSFT_Stage_GLHierarchy_DeriveRange
- SDE_PSFT_Stage_GLHierarchy_Flatten
- SDE_PSFT_GLHierarchy_Derive

Symptoms

The account name in the GL Segment dimension does not appear.
The name just appears at the last level of the account hierarchy.
 
For example, you can see this values in Hierarchy:

 


Note that the CODE is the same as NAME.

 

The correct values according to the Source System are:

 

HIER3_CODEHIER3_NAMEHIER4_CODEHIER4_NAME
11 Available 1120 Savings Account
12 Investments 1205 Shares
12 Investments 1299 Stock

 

Those NAMES appear correctly in the table W_PSFT_GLHIER_DTLRGE_DH_TMP, but after several mappings the names are lost.

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