Fact Account Profitability entity stores fact data for reporting line items of revenue, costs, and expense related to each customer account. The data into this table is populated from other fact tables like:
· FCT_COMMON_ACCOUNT_SUMMARY
· FCT_PFT_ACCOUNT_SUMMARY
· FCT_FTP_ACCOUNT_SUMMARY
· FCT_REG_CAP_ACCOUNT_SUMMARY
· FCT_ECO_CAP_ACCOUNT_SUMMARY
The following table lists the seeded Post Load Transformation Definition with related Source Table and Destination tables:
|
DT Definition Name |
Source Table |
Destination Table |
|
FN_FCT_ACCOUNT_PFT |
FCT_COMMON_ACCOUNT_SUMMARY |
FCT_ACCOUNT_PROFITABILITY |
|
FCT_PFT_ACCOUNT_SUMMARY |
||
|
FCT_FTP_ACCOUNT_SUMMARY |
||
|
FCT_REG_CAP_ACCOUNT_SUMMARY |
||
|
FCT_ECO_CAP_ACCOUNT_SUMMARY |
||
|
FCT_PFT_CUSTOMER_SUMMARY |
Refer to Oracle Financial Services Analytical Applications Data Model Data Dictionary or the Erwin Data Model to view the detailed structure of the tables.
Information from account summary fact tables are populated to Fact Account Profitability through a mapping process. Reporting line dimension is mapped to measures present in account summary. A PL/SQL procedure then populates the fact by reading the mapping definition.
Reporting line dimension is created/maintained from Attribute Member Hierarchy Maintenance (AMHM) component of OFSAAI. A Reporting line item represents a revenue, costs, or expenses. Rollup signage is set as an attribute for a reporting line. To know more about AMHM, refer to Oracle Financial Services Analytical Applications Infrastructure User Guide.
The Account summary tables contain the revenue, costs, or expenses measures pertaining to an Account. Map Maintenance component of OFSAAI is used to map the measures of account summary tables (represented in a measure hierarchy) to reporting line hierarchy. A pre-defined mapping "Reporting Line Mapping" is seeded along with the application installer. Reporting Line Hierarchy and Reporting Line Measure Hierarchy are the two hierarchies which are used for the mapping. Reporting Line Hierarchy is a parent child hierarchy which is based on Reporting Line Dimension entity.
Reporting Line Measure hierarchy is a Non Business Intelligence Enabled Hierarchy which is based on measures from the Account Summary tables.
A seeded map is configured between the Reporting Line Hierarchy and Reporting Line Measure Hierarchy from Map Maintenance of OFSAAI.
For more information on defining/maintaining Mapper, refer to Oracle Financial Services Analytical Applications Infrastructure User Guide.