Oracle® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Financial Analytics >

About PeopleSoft Trees in Oracle Financial Analytics


For PeopleSoft, the Siebel Financial Analytics application sources data from a data structure, called PeopleSoft Trees, to get information about the organization's General Ledger hierarchies, Profit hierarchies, Cost Centers' hierarchies, and so on.

PeopleSoft Trees are a flexible, generic way of constructing hierarchical summarization of a particular database fields in PeopleSoft for reporting purposes. Typically, entities such as Chart of Account fields (Account, Dept, and Project, and so on), items, locations, and so on, are organized into user-defined trees.

Table 63 lists the PeopleSoft Trees the Siebel Financial Analytics application sources.

Table 63. PeopleSoft Trees for Oracle's Siebel Financial Analytics
PeopleSoft Data Structure
Repository Source Name
Description

PeopleSoft Tree

ACCTROLLUP

Account Rollup

PeopleSoft Tree

AR_BUSINESS_UNITS

AR Business Unit Roll-Up

PeopleSoft Tree

DEPARTMENTS

Manufacturing Departments

PeopleSoft Tree

OPERUNIT

Operating Unit

Table 64 lists the mappings and sessions using PeopleSoft Trees.

Table 64. List of Mappings And Sessions Using PeopleSoft Trees
Repository Source Name
Mapping
Session

ACCTROLLUP

M_P_GL_ACCTS_HIERARCHY_EXTRACT

S_M_P_GL_ACCTS_HIERARCHY_EXTRACT

AR_BUSINESS_UNITS

M_P_BUSN_ORGS_COMPANY_HIERARCHY_EXTRACT

S_M_P_BUSN_ORGS_COMPANY_HIERARCHY_EXTRACT

DEPARTMENTS

M_P_PROFIT_CNTRS_HIERARCHY_EXTRACT

S_M_P_PROFIT_CNTRS_HIERARCHY_EXTRACT

OPERUNIT

M_P_COST_CENTERS_HIERARCHY_EXTRACT

S_M_P_COST_CENTERS_HIERARCHY_EXTRACT

Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.