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