Skip Headers

Oracle Financial Services Implementation Guide
Release 12.1
Part Number E13527-03
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Oracle Profitability Manager Implementation

This chapter describes the implementation steps specific to the Oracle Profitability Manager application.

This chapter covers the following topics:

Oracle Profitability Manager Implementation Overview

Oracle Profitability Manager implementation is similar to that of other Oracle Financial Services applications. You need to follow all the common implementation steps. See: Implementing Oracle Financial Services Applications.

In addition, you need to follow these Oracle Profitability Manager implementation-specific steps:

Pre-Implementation Considerations

Prior to implementing Profitability Manager, give careful consideration to the following:

Specify Input and Output Columns for Mapping

Mapping rules perform calculations for allocation of income statement and balance sheet items and enable cost object mapping to activity rates, direct expenses, and activity costs. As part of table registration, you must specify Input/Output columns for tables selected for mapping.

Input columns are used by mapping rules to identify which columns act as sources for dimension values. Output columns are used to identify which columns can act as targets for dimension values. Output columns must also appear in the processing key (The processing key is also the primary key for the table. Requiring output columns to be in the processing key guarantees that all rows written by the Common Calculation Engine capture all dimension values written for any output column).

When a column is defined as a Mapping Output column on a table, a line for that column will appear on any mapping rule Debit or Credit which uses that table (the column description is used, which normally corresponds to the name of the dimension attached to the column). That line minimally allows a user to set a specific dimension value for that column on output. If a column which corresponds to the same dimension is defined as a Input column on a table used in either a Source or Percentage mapping formula type, then the mapping rule Debit or Credit will also contain a Same As entry for the dimension.

For more information about mapping rules, see “About Mapping Rules”, Oracle Profitability Manager User's Guide.

General Rules for Defining Mapping Input and Output Columns

Mapping input columns are columns which:

Mapping Input columns do not have to be included in the processing key for the table.

Special handling columns and non-value set enabled columns include the following:

These rules are valid for Balance, Transaction and Account tables.

Mapping Output columns are columns which:

All columns in the processing key for FEM_BALANCES must be defined as mapping output columns.

Mapping output columns are not applicable for Customer Account Profitability tables.

The additional columns in the processing key for Customer Transaction Profitability tables (i.e. the "Transaction" dimension) are also required to be a mapping output column.

Examples: Mapping Input and Output Columns

Following are examples for mapping Input and Output columns.

Example 1: Financial Element, Simple Source On Allocation Mapping Rule

Assume the following mappings for Input and Output columns:

You would expect to see the following in the Debit of the Mapping rule:

Example 2: Product, Simple Source On Allocation Mapping Rule

Assume the following mappings for Input and Output columns:

You would expect to see this in the Debit of the Mapping rule:

Example 3: Financial Element, Percentage Distribution Mapping Rule

Assume the following mappings for Input and Output columns:

You would expect to see this in the Debit of the Mapping Rule:

Working with Composite Dimensions (Activity and Cost Object)

Activity and Cost Object are composite dimensions, comprised of other dimensions. If your organization will be using Activity-Based Management functions, you must set up these dimensions.

You must have the Profitability Manager with Activity-Based Management - Administrator responsibility to set up composite dimensions.

Give careful thought to composite dimension definitions. Once set up, they are frozen and cannot be edited.

Setting Up the Activity Dimension

The Activity dimension holds repeatable tasks in relation to other dimensions such as Organization, Channel, Customer, and so forth. For example, the activity of "depositing a check" is the act of "depositing" applied to an acted upon item — in this case, a check.

You set up the Activity dimension by specifying its component dimensions. Task is a required component. You can optionally include any of the other dimensions in the FEM_BALANCES table. For example, if a company performs the same task across many departments, you would specify the Task and Company Cost Center Organization dimensions as the definition for the Activity dimension.

Note: Ensure that the processing key of the FEM_BALANCES table includes all of the component dimensions that you specify for the Activity dimension definition. If they are not included, then Activity rules will fail.

Follow these steps to set up the Activity dimension.

  1. Access Profitability Manager with the Profitability Manager with Activity-Based Management - Administrator responsibility.

  2. Navigate to Administration > Registration.

  3. On the Registration tab, choose Activity and Cost Object Definition.

    The Composite Dimension Definition page opens.

  4. Click the Activity link.

    The Activity Dimension Definition page opens. Available component dimensions are listed in the Available box.

  5. Click Update to enable dimension selection.

  6. Select dimensions from the Available box and move them to the Selected box. At minimum, you must choose the Task dimension.

  7. Click Freeze to finalize the dimension definition.

Setting Up the Cost Object Dimension

Cost Objects are multi-dimensional entities that describe a cost. The intersection of component dimensions such as Organization, Product, and Customer results in the creation of a composite dimension that uniquely identifies a Cost Object.

You define the Cost Object dimension by specifying its component dimensions. Financial Element and Ledger are required components. A third dimension of your choice is also required. For example, if you want to define cost objects based on your product master, you would include Financial Element, Ledger, and Product as the definition for the Cost Object dimension.

Once you are satisfied with the dimension definition, you freeze it. Thereafter, you can only view the definition.

Note: Ensure that the processing key of the FEM_BALANCES table includes all of the component dimensions that you specify for the Cost Object dimension definition. If they are not included, then the Cost Object Unit Cost rule will fail.

Follow these steps to set up the Cost Object dimension.

  1. Access Profitability Manager with the Profitability Manager with Activity-Based Management - Administrator responsibility.

  2. Navigate to Administration > Registration.

  3. On the Registration tab, choose Activity and Cost Object Definition.

    The Composite Dimension Definition page opens.

  4. Click the Cost Object link.

    The Cost Object Dimension Definition page opens. Available component dimensions are listed in the Available box.

  5. Click Update to enable dimension selection.

  6. Select dimensions from the Available box and move them to the Selected box. You must choose Financial Element, Ledger, and at least one other dimension.

  7. To finalize the dimension definition, click Freeze.

Set Up Statistics

The Profitability Manager mapping function includes a Retrieve Statistic formula type. This formula multiplies source data by reference values sourced from a statistic table. You must set up the statistics that will be used in this formula.

You define a statistic by designating a table as a lookup or statistics table, then designating the columns to be used as lookup fields. One or more dimensions from a FEM data table can be used in the lookup process, providing single or multiple dimension lookups.

For more information, see “Working with Statistic Definitions”.

Working with Statistic Definitions

When users define a Retrieve Statistic formula type for a mapping rule, they choose a Statistic. The Statistic definition is composed of a lookup table selection and a specification that joins the table's columns to columns in a Profitability table. The lookup columns can be joined directly. Alternatively, they can be set to a constant value to provide a way to define the lookup rows relevant to the statistic.

When the mapping rule runs, rows from the initial data source that match the lookup key columns will be processed, and the value in the row that is designated as the Lookup Return Column will be used as the Retrieve Statistic value.

About Creating a Statistic

To create a Statistic, you choose the source table, specify a Statistic lookup table, and join the source table to it.

Note: The source table must correspond to the Input Data Source for the mapping rule that will use the statistic (See “Mapping Rule Formula Type: Retrieve Statistic” , Oracle Profitability Manager User's Guide). The lookup table must be classified as a Statistic classification type using the Administration > Table Registration function.

You then specify how the columns in the lookup table will be used in the lookup. If a lookup table column is part of the lookup key, the Join With column is set to Source Table Column and the Value column contains the source table dimension that will be included in the lookup key. If a lookup table column is not part of the lookup key, you set the Join With column to Constant Value and enter the constant value that is common for all lookup rows in the lookup set within the lookup table.

Designate the Lookup Column name in the list of values. You can apply a condition to filter the rows in the lookup table that will be available to the Statistic lookup set. For example, if you want to match rows in the source table to rows in the lookup table by Ledger and by Company Cost Center Organization, you would set those two lookup table columns to join with the matching columns in the source table (Dataset and Company Cost Center Organization). Assuming that you gather statistics yearly, you would not want to look up Calendar Period, so you would set the Calendar Period lookup table column to the Constant Value that equals the date that the statistic rows were gathered in the lookup table.

Note: The lookup column on the statistic table must be classified as a CPM data type of Statistic, Monetary Balance or Rate.

Creating a Statistic

Follow these steps to create a Statistic.

  1. Access Profitability Manager with the Activity-Based Management responsibility or the Profitability Manager responsibility.

  2. Navigate to Business Rules > Statistics.

    The Statistics page opens.

  3. Click Create.

  4. In the Create Statistic area, identify the statistic.

  5. In the Join Tables area, specify how to join to each column in the lookup table to the source. Select a join option: Source Table Column or Constant Value.

  6. In the Lookup Return column, choose the column that contains the value that will be returned to the mapping rule when the lookup key is found.

  7. (Optional) Apply a condition to filter the data.

  8. Click Apply.

Updating a Statistic

Once a rule version that uses a Statistic has been run, the Statistic is locked for that rule. However, the Statistic can be used in new rules and versions. Note that you can also add data to the underlying lookup table. However, if the non-lookup columns were to change, you would have to duplicate the Statistic before you could include it in the new rule version.

Follow these steps to update a Statistic for a rule that has not been run.

  1. Navigate to Administration > Registration > Statistics.

    The Statistics page opens.

  2. Search for a Statistic. You can search by Name, Source Table, Lookup Table, and Source column. Use % as a wildcard.

    The list displays Statistics that match your criteria.

  3. Identify the Statistic to update and click its Update icon.

  4. You can modify the name and description. You can also modify information for join columns, lookup return columns, and condition.

  5. Click Apply.

Duplicating a Statistic

Duplicating a Statistic allows you to quickly create a Statistic definition based on an existing definition.

Follow these steps to duplicate a Statistic.

  1. Navigate to Administration > Registration > Statistics.

    The Statistics page opens.

  2. Search for a Statistic. You can search by Name, Source Table, Lookup Table, and Source column. Use % as a wildcard.

    The list displays Statistics that match your criteria.

  3. Identify the Statistic to duplicate and click its Duplicate icon.

  4. Enter a name and description for the new Statistic.

  5. Click Apply.

Deleting a Statistic

You can delete a Statistic before a Retrieve Statistic mapping rule that contains the Statistic has run. Once a rule has run, the Statistic is locked and cannot be deleted.

Follow these steps to delete a Statistic.

  1. Navigate to Administration > Registration > Statistics.

    The Statistics page opens.

  2. Search for a Statistic. You can search by Name, Source Table, Lookup Table, and Source column. Use % as a wildcard.

    The list displays Statistics that match your criteria.

  3. Identify the Statistic to delete and click its Delete icon.

    You are prompted to confirm the deletion.

Working with Column Population Templates

When users run an Account Consolidation rule or a Profit Aggregation rule, they select a Column Population template. For account consolidation, the Column Population template specifies how the columns in the source Account table will map to the target FEM_CUSTOMER_PROFIT table. For a Profit Aggregation rule, the Column Population template specifies how balance columns will aggregate; it is run from the FEM_CUSTOMER_PROFIT table to the FEM_CUSTOMER_PROFIT table itself.

You must define a Column Population template for each Account table. Provide a name and description that will make it clear to users which template they are choosing when building Account Consolidation and Profit Aggregation rules.

Some columns are assigned automatically and are designated as System Reserved Column Mappings. Other columns may be added as User Defined Column Mappings. You must populate all required columns in the template.

When specifying a Column Population template for account consolidation, you must include the Business Relationship column, which should be mapped as an Attribute Lookup. (Business Relationship is a required attribute for the Customer dimension.)

Note: Each table and column that you specify in the Column Population Template must be registered.

Creating a Column Population Template

Follow these steps to create a Column Population template.

  1. Access Profitability Manager with the Profitability Manager Administrator or the Profitability Manager with Activity-Based Management - Administrator responsibility.

  2. Navigate to Administration > Registration.

  3. On the Registration tab, choose Column Population Template.

    The Column Population Template Rules selector opens.

  4. On the Column Population Template Rules page, click Create.

    A new Column Population Template Rule page opens.

  5. Name and describe the Column Population template and specify the source table.

  6. Click Continue.

    The Column Template Version page opens.

  7. On the Column Population Template Version page, identify the template version.

  8. Click Continue.

    The Column Population Template Details page opens.

  9. In the User Defined Column Mappings section, map source to target columns.

    In the Population Method field, choose the population method for a column. Source columns and Lookup columns must match. You can choose one of the following:

  10. If you chose Source Column (Step 9) and the template will be used for a Profit Aggregation rule, specify an aggregation method. Choose one of the following:

  11. Click Preview Population to view results.

  12. Click Finish.

Updating a Column Population Template

You can update a Column Population template. Follow these steps.

  1. Navigate to Administration > Registration > Column Population Template.

  2. Search for the Column Population Template to update. Choose a folder, then enter % to see all templates or enter text and use % as a wildcard. You can also search using Effective Date.

    The list displays templates that match your criteria.

  3. To modify the template name or description, click its Update icon.

  4. To update a rule version, proceed as follows:

  5. To update a template version, proceed as follows:

  6. Click Apply.

Duplicating a Column Population Template

Duplicating a Column Population Template allows you to quickly create a new template or template version.

When you duplicate a version, it is added to the list of versions for the template. When you duplicate the template and version, the template and version are displayed as new entities in the list of templates.

Note: When duplicating a version, you must specify an effective date range that does not conflict with the existing version.

Follow these steps to duplicate a template or template and template version.

  1. Navigate to Administration > Registration > Column Population Template.

  2. Search for the Column Population Template to duplicate. Choose a folder, then enter % to see all templates or enter text and use % as a wildcard. You can also search using Effective Date.

    The list displays templates that match your criteria.

  3. Search for the template to duplicate. Choose a folder, then enter % to see all rules or enter text and use % as a wildcard.

    The list displays templates that match your criteria.

  4. Display template versions by clicking the + icon in the Rule Name column.

  5. Click the Duplicate icon for a version.

    The Duplicate Options page opens.

  6. Choose a duplication option.

  7. Click Continue.

  8. If you chose Rule and Version as the duplication option (Step 6), identify the template and the version. For rule enter a unique name and description. For version, enter a unique name, specify the Effective Start Date, and Effective End Date. You can also enter a description.

    If you chose Version as the duplication option (Step 6), identify the new version. Enter a unique name, specify the Effective Start Date, and Effective End Date. You can also enter a description.

  9. Click Finish.

Deleting a Column Population Template

You can delete a Column Population template. Follow these steps.

  1. Navigate to Administration > Registration > Column Population Template.

  2. Search for the Column Population Template to delete. Choose a folder, then enter % to see all templates or enter text and use % as a wildcard. You can also search using Effective Date.

    The list displays templates that match your criteria.

  3. Display versions by clicking the + icon in the Name column.

  4. Identify the version to delete and click its Delete icon.

    You are prompted to confirm the deletion.

Viewing a Column Population Template

You can view a Column Population template. Follow these steps.

  1. Navigate to Administration > Registration > Column Population Templates.

    The Column Population Template page opens.

  2. Search for Column Population templates. Choose a folder, then enter % to see all templates or enter text and use % as a wildcard. You can also search using Effective Date.

    The list displays templates that match your criteria.

  3. Proceed as follows: