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 and later
Information in this document applies to any platform.
BI Apps Build:
Release Version: Oracle Business Intelligence Applications
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


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:


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.


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.