This chapter describes the implementation steps common to Oracle Financial Services applications.
This chapter covers the following topics:
Oracle Financial Services (OFS) applications in Release 12 are based on Oracle Enterprise Performance Foundation (EPF). EPF belongs to the Oracle Corporate Performance Management (CPM) product family, which is a part of the Oracle E-Business Suite Unified Data Model. EPF uses the product prefix FEM and is the central data depository that OFS applications are built upon. See: What is Oracle Enterprise Performance Foundation?, Oracle Enterprise Performance Foundation User's Guide.
This implementation guide provides information about setting up these Oracle Financial Services applications:
Oracle Transfer Pricing (FTP): Allows you to generate transfer rates and option costs for your product portfolio and determine account-level match-funded spreads. You can also use these account-level match-funded spreads to produce account, customer, product, and business unit performance measures and to quantify and manage interest rate risk. See: Oracle Transfer Pricing User Guide.
Oracle Profitability Manager (PFT): Lets you calculate, analyze, and report profitability. You can allocate profitability measures across multiple dimensions, such as customer, product, channel, transaction, entity, division, and analyze profitability using activity-based methodologies. See: Oracle Profitability Manager User's Guide.
Before users can use these applications, you need to:
Assign appropriate responsibilities to each user of the application.
Set up and populate data structures to load data to the application.
Configure iSetup and map instances for extracting and loading rules.
In addition to these general setup steps, you also need to perform the product-specific steps. See:
Related Topics
Oracle Transfer Pricing Implementation Overview
Oracle Profitability Manager Implementation Overview
These responsibilities are available for assignment to users of Oracle Financial Services (OFS) applications:
Common Oracle Financial Services (OFS) Applications Responsibilities:
Enterprise Performance Foundation Administrator
Oracle Transfer Pricing (FTP) Responsibilities:
FTP User
FTP Supervisor
Oracle Profitability Manager (PFT) Responsibilities:
Enterprise Performance Foundation Administrator
Profitability Manager
Profitability Manager Administrator
Profitability Manager Administrator with Activity-Based Management
Profitability Manager with Activity-Based Management – Administrator
The following table lists the user privileges for different responsibilities that can be assigned in the OFS applications:
| Responsibility | Menu | Access | Menu Exclusion |
|---|---|---|---|
| Enterprise Performance Foundation Administrator | Enterprise Performance Foundation Menu | Home, Data Rule, Configuration Rules, Process Management, and Administration tabs | None |
| FTP User | FTP Menu - Supervisor | Home, Business Rule (Calculation, Dimension, Condition, Data Inspector, Patterns, Interest Rate Codes, Currency Rates), Process Management, and Documents tabs | Administration tab |
| FTP Supervisor | FTP Top Level Menu | Home, Business Rule (Calculation, Dimension, Condition, Data Inspector, Patterns, Interest Rate Codes, Currency Rates), Process Management, Documents, and Administration tabs | None |
| Profitability Manager | Profitability Manager Menu | Home, Business Rules (Mapping, Customer, Dimension, Condition, Data Inspector), Process Management, and Documents tabs | Administration |
| Profitability Manager Administrator | Profitability Manager Menu | Home, Business Rules (Mapping, Customer, Dimension, Condition, Data Inspector), Process Management, Documents, and Administration tabs | None |
| Profitability Manager Administrator with Activity-Based Management | Profitability Manager Menu | Home, Business Rules (Mapping, Activity, Customer, Dimension, Condition, Data Inspector), Process Management, and Documents tabs | Administration |
| Profitability Manager with Activity-Based Management – Administrator | Profitability Manager Menu | Home, Business Rules (Mapping, Activity, Customer, Dimension, Condition, Data Inspector), Process Management, Documents, and Administration tabs | None |
See: Users Window, Oracle Applications System Administrator's Guide - Security.
Related Topics
Set a value for each profile option to specify how the Oracle Financial Services application controls access to and processes data.
The prefixes in the profile option name indicate the application that the profile belongs to:
FEM: Oracle Enterprise Performance Foundation
FTP: Oracle Transfer Pricing
See: Oracle Financial Services Applications Profile Options.
See: Overview of Setting User Profiles, Oracle Applications System Administrator's Guide - Maintenance.
Related Topics
Oracle Financial Services Applications Profile Options
The following table displays the profile options for Oracle Financial Services applications such as Profitability Manager and Transfer Pricing. The profile options in Oracle Enterprise Performance Foundation are applicable to Oracle Financial Services applications.
| Profile Name | Profile Description |
|---|---|
| FEM: Application Code | Displays the application defined for the user. |
| FEM: Attribute Interface Table Date Format Mask | Currently, when users enter start and end dates for calendar periods with the user interface, they are not allowed to enter the "time" portion of the date, and this always is defaulted in the database to 00:00:00. However, in some situations, users may need to create what is called an "intra day" period. This is the case where a start time or end time represents less than a whole day. To do this, you must specify the "date" and the "time" for that period, and this is provided as a feature in the dimension member loader. To create an "intraday" period, the user must specify the date format mask in the "FEM: Attribute Interface Table Date Format Mask" profile option, and load the calendar period members into the appropriate loader table, and then run the dimension member loader program. By default, this profile option is set to exclude the time portion. |
| FEM: CCE Debug Trace | Reserved for support, the profile option enables debug reporting for the common calculation engine (CCE) in the concurrent manager log. |
| FEM: Currency Conversion Type | Used to specify the currency conversion type when translating currencies. The domain for this profile option is defined in the E-Business Suite, and includes options such as Corporate, Daily, and Spot. |
| FEM: Currency Type | The domain for this profile option is either Entered or Translated. Profitability Manager processes only those rows indicated as Entered. Rows indicated as Translated are primarily for reporting purposes. |
| FEM: Data Set Group | Specifies the default dataset group. This option is set on the Application Preferences menu and should not be set on the Profile Options setup screen. |
| FEM: Dataset | Specifies the default Dataset. This option is set on the Application Preferences menu and should not be set on the Profile Options setup screen. |
| FEM: Default Actuals Dataset | Specifies the default actuals data set used when setting up General Ledger Balances Rules to leverage actual balances in Enterprise Performance Foundation. |
| FEM: Default Effective Start Date | Specifies the start date default for rule versions. If not specified, the system will default to 1/1/1900. |
| FEM: Default Effective End Date | Specifies the end date default for rule versions. If not specified, the system will default to 1/1/2500. |
| FEM: Effective Date | Specifies the default effective date. This option is set on the Application Preferences menu and should not be set on the Profile Options setup screen. |
| FEM: FEM Top | Specifies the location of the FEM_TOP file system directory in the Oracle Applications file system. Used by the Enterprise Performance Foundation Refresh Engine. |
| FEM: GL Advanced Mapping Flag | Determines if line items and financial elements are associated with natural accounts when leveraging balances from Oracle General Ledger in Enterprise Performance Foundation. When the profile option is set to Yes, users should set up the Financial Element and Line Item attributes for the Natural Account dimension. |
| FEM: Ledger | Specifies the default ledger. This option is set on the Application Preferences menu and should not be set on the Profile Options setup screen. |
| FEM: Loader Dimension Grouping Size | Number of dimensions to process at a time when validating the dimensions in the interface data. See the "Logging" topic under Running the Detail Client Data Loader, Oracle Enterprise Performance Foundation User's Guide for further information. |
| FEM: Period | Specifies the default period. This option is set on the Application Preferences menu and should not be set on the Profile Options setup screen. |
| FEM: Result Rounding Flag | Controls the output from a Oracle Profitability Manager (PFT) Mapping Rule calculation when results do not meet a specific threshold. If the flag is set to ‘Y’, then results less than .000001 do not get written on output. If set to ‘N’, then all results, no matter how small are written on output. |
| FEM: Rule Migration Access | Set by the system administrator to enable or disable migration functionality. If the profile option value is set to "N", the Migrate icon is disabled on the rule home page; otherwise, the icon is enabled. Can be set at the Site, Application, and Responsibility levels, but not at the User level. |
| FEM: Rule Set Depth Limit | Controls the depth of the nested rule sets within a rule set. |
| FEM: Security Folder | Specifies the default security folder. This option is set on the Application Preferences menu and should not be set on the Profile Options setup screen. |
| FEM: Signage Methodology | Identifies the signage methodology used for calculations that write to the FEM_BALANCES table and data written to Enterprise Performance Foundation as part of Oracle General Ledger integration. The available methodolgies are:
|
| FEM: Track Event Chains | Supports the ability to remove a chain of processing runs. If this flag is set, and you remove a rule, any other rules that are dependent upon the removed rule are also removed. |
| FND: View Object Max fetch size | Sets the maximum number of rows displayed in lists of values and on pages in the user interface by restricting the number of rows that the view object fetches from the database. The default value is 200. |
| FTP: Engine Debug Trace | Reserved for support, this profile option enables debug reporting for the Transfer Pricing engine in the concurrent manager log. |
| FTP: Option Cost Precision Factor | While calculating the static spread for option cost calculation, you can control the convergence speed of the algorithm by adjusting the value of the FTP: Option Cost Precision Factor profile option. The default value is equal to one. A lower precision factor results in more accurate results but increases the processing time. A precision factor equal to one usually results in an error of less than half a basis point (on the static spread and OAS). |
| FTP: Process Errors - Per Item | Specifies the number of times you want to see each unique error message. For example, if you type in 10, the concurrent manager log will hold 10 rows for each unique error message that results from running your Transfer Pricing Process rule. |
| FTP: Process Errors - Total | Specifies the total number of error messages you want to output. For example, if you type in 100, the first 100 error messages that result from running your Transfer Pricing Processing rule will be written to the concurrent manager log. |
A value set consists of a list of members for a dimension. A global value set combination consists of a group of value sets, in which there is one value set for each dimension in the system.
A global value set combination becomes active when you select a Ledger on the application preferences menu. You must associate a global value set combination to each Ledger dimension member.
See: Working with Value Sets and Working with Global Value Set Combinations.
Note: Oracle Financial Services (OFS) applications are seeded with a default value set for each dimension and a default global value set combination. Use the seeded default value sets unless you have a specific requirement that dictates creating additional value sets. If you plan to use the seeded default value sets skip the steps described in these sections.
Related Topics
Working with Global Value Set Combinations
There can be multiple lists of values for a dimension. By defining value sets, where each value set represents a particular list of values, you can distinguish these lists of value from one another. Value sets are useful when there are two systems that use the same dimensional identifier for different purposes.
For further information, see the following topics:
Use the following procedure to create a new value set:
On the Value Sets page, click the Create button.
On the Create Value Set page, specify the following:
A short identifier for the value set in the Code box
The full name for the value set in the Value Set Name box
An optional text description for the value set in the Description box
The dimension to which the value set is to be assigned in the Dimension box. Click the search icon to search for and select a dimension.
Click the Apply button to create the value set.
Use the following procedure to update an existing value set:
On the Value Sets page, search for the value set that you want to update. You can refine the search by value set name, dimension, or both. When you have specified the desired search values, click the Go button to display a list of value sets that meet the search criteria.
Click the Update icon for the value set that you want to update.
On the Update page, update the value set name and description, as desired.
Click the Apply button to apply the updates.
Use the following procedure to delete a value set:
On the Value Sets page, search for the value set that you want to delete. You can search by value set name, dimension, or both. When you have specified the desired search values, click the Go button to display a list of value sets that meet the search criteria.
Click the Delete icon for the value set that you want to delete. Note that some value sets cannot be deleted; the Delete icon is disabled for these value sets.
On the Delete page, confirm that you want to delete the value set.
After you have created value sets, you can create global value set combinations. A global value set combination is a defined combination of value sets in which there is one value set for each dimension in the system. Through a ledger attribute, global value set combinations are associated with ledgers for processing.
Through the Global Value Set Combinations page, you can manage global value set combinations.
For further information, see the following topics:
Use the following procedure to create a global value set combination:
On the Global Value Set Combinations page, click the Create button.
On the Create Global Value Set Combination page, specify the name for the new global value set combination and a value set for each dimension. For each dimension, you can use the default value set, or you can choose a different value set from the list in the Value Set box.
Click the Apply button to create the global value set combination.
Use the following procedure to update a global value set combination:
On the Global Value Set Combinations page, search for the global value set combination that you want to update. When you have specified the desired search value, click the Go button to display a list of global value set combinations that meet the search criteria.
For each global value set combination displayed in the Results section, you can view the component value sets by expanding the global value set combination. To expand a global value set combination, click the Expand icon immediately preceding the global value set combination.
Click the Update icon for the global value set combination that you want to update.
Make any desired changes to the global value set combination name. Note that you cannot make any changes to the value sets assigned to dimensions for existing global value set combinations.
Click the Apply button to update the global value set combination.
You can delete a global value set combination, providing that the global value set combination has not been assigned to a ledger. Use the following procedure to delete a global value set combination:
On the Global Value Set Combinations page, search for the global value set combination that you want to delete. You can search by global value set combination name, dimension, or both. When you have specified the desired search values, click the Go button to display a list of global value set combinations that meet the search criteria.
Click the Delete icon for the global value set combination that you want to delete.
On the Delete page, confirm that you want to delete the global value set combination.
You can set up the following dimensions or use the default values provided by the application before processing the application. In addition, you must set up a Line Item hierarchy before processing. You can elect to set up hierarchies for other dimensions as necessary for reporting purposes. See: About Dimension and Hierarchy Management, Oracle Enterprise Performance Foundation User's Guide.
Ledger
Note: Use of the default Ledger is recommended.
Calendar
Calendar Period
Calendar Period hierarchy
Note: Use of the default Calendar Period Hierarchy is recommended.
Product
Geography
Natural Account
Line Item
Line Item Hierarchy
Company Cost Center Organization
Company Cost Center Organization hierarchy
Customer
Data Set Code
Source System
Note: You need to associate the Calendar Period hierarchy with the Ledger dimension. There are several interfaces in the UI that request you to input both the ledger and calendar period data. You will only be able to select calendar periods, which are part of the Calendar Period hierarchy associated with a given Ledger.
You can load the dimensions using the loader programs manually through the user interface, or within an Excel spreadsheet by selecting the Create From Spreadsheet option. See: Setting Up and Populating Data Structures.
Related Topics
Populate the data from legacy source systems to interface tables in the Enterprise Performance Foundation (EPF) data model using the EPF interface architecture. See: Populating the Interface Tables.
Move the verified data to the permanent tables in the EPF database to be used by the Oracle Financial Services application. See:
Related Topics
Populating the Interface Tables
Populating the Data Model Using the Data Loaders
Populating the Data Model Manually
EPF Interface Architecture provides a set of interface tables for each type of information. An interface table acts as a staging area for your business data.
You can load account data extracts using SQL scripts. Use the data dictionary as the definitive representation of each table structure, to load the source data to the defined interface tables. See: Oracle Financial Services Data Dictionary (Note 333726.1 on My Oracle Support).
For a new implementation, all the source data is extracted, modified, and loaded into the tables. For an existing implementation, incremental data is extracted, modified, and added into the account tables.
Related Topics
Setting Up and Populating Data Structures
Enterprise Performance Foundation (EPF) interface architecture also provides an easy and automated way to move the data from interface tables to the EPF database using a set of loader engines.
EPF interface architecture enables you to load the following types of information:
Dimension members and attributes
Dimension levels
Dimension hierarchies
Fact data, such as monetary balances and statistics
General Ledger data
Account Level data
EPF provides a separate engine or loader to load each type of business information.
Important: EPF system does not require any particular order for the loading except that you need to always load dimension members first.
See: Interface Tables and External Data Loaders, Oracle Enterprise Performance Foundation User's Guide.
The following is an example of an automated loading process using data loaders:
Load new dimension members using the Dimension Member loader. You would need to define new dimensions for Product, Company Cost Center Organization, Geography, and Industry.
Load general ledger data using the External General Ledger Data loader.
Load the detail client data using the Detail Client Data loader.
Identify the dimensions for loading.
Populate the Dimension Member loader interface tables. See: Populating the Interface Tables.
Select the loader operation for the Dimension Member loader. The Dimension Member loader supports the following loader operations:
Create new levels.
Update level names and descriptions.
Create new members.
Update member names and descriptions.
Update existing attribute assignments.
Create new attribute assignment versions.
Run the Dimension Member loader.
See: Dimension Member Loader, Oracle Enterprise Performance Foundation User's Guide.
Identify the Hierarchy dimensions.
Populate the Dimension Hierarchy loader interface tables. See: Populating the Interface Tables.
Select the loader operation for the Dimension Hierarchy loader.
Run the Dimension Hierarchy loader.
See: Dimension Hierarchy Loader, Oracle Enterprise Performance Foundation User's Guide.
Define the processing key metadata for the FEM_BALANCES table.
Create a unique index on FEM_BALANCES that includes all the columns included in the processing key definition.
Create a unique index on the FEM_BAL_INTERFACE_T table that includes all the columns listed for it in the External General Ledger Interface Table section, including all the display code columns that correspond to a FEM_BALANCES processing key column, and set these columns to NOT NULL in the interface table.
Load balances data into FEM_BAL_INTERFACE_T.
Run the External General Ledger loader.
See: External General Ledger Data Loader, Oracle Enterprise Performance Foundation User's Guide.
Populate the Detail Client Data loader interface tables. See: Populating the Interface Tables.
Run the Detail Client Data loader.
See: Detail Client Data Loader, Oracle Enterprise Performance Foundation User's Guide.
Note: The DataX Loader program, which was earlier used to load generic fact data, has been phased out. The Detail Client Data Loader program provides all of the functionality of the DataX Loader program as well as additional capabilities. Use the Detail Client Data Loader program instead of the DataX Loader for loading data into data tables.
Related Topics
Setting Up and Populating Data Structures
In addition to populating the data model using the loaders, you can also manually set up data structures in a Oracle Financial Services application through the Dimension and Hierarchy Management feature. See: About Dimension and Hierarchy Management, Oracle Enterprise Performance Foundation User's Guide.
To create a dimension member, such as a Company Cost Center Organization, proceed with the following steps:
Navigate to the Dimension Members page.
Select the appropriate dimension from Switch Dimension and click Go.
Click Create Member.
Enter the dimension member details.
See: Creating members, Oracle Enterprise Performance Foundation User's Guide.
Related Topics
Setting Up and Populating Data Structures
Enterprise Performance Foundation allows dimension loading rules and account, ledger and client data loading rules to be created as stored rules with scope, and run any time with or without modifications. You can use these rules to load the data model using rule based data loaders such as the Dimension Member Loader and the Detail Client Data Loader. See:
Dimension Loader, Oracle Enterprise Performance Foundation User's Guide.
Data Loader, Oracle Enterprise Performance Foundation User's Guide.
Related Topics
Setting Up and Populating Data Structures
Application preferences are a set of global options specific to each user, which you can set as parameters to be used while processing and reporting. These parameters are also used as default values for running a Oracle Financial Services application's process rule, but those defaults can be overridden at runtime.
You can set any of the following five options as the default set of parameters.
Security Folder: Set a second level security.
Data Set Group: Set the default data set group.
Default Ledger: Set a default ledger. The global value set attribute on your ledger impacts creation and viewing of rules in the application. See: Defining Value Sets and Global Value Set Combinations.
Period: Set the default calendar period. The list of periods is dependent on the ledger selection.
Effective Date: Set the default effective date.
Navigate to any page in the application.
Click Preferences on the global menu.
Click Application Preferences on the application preferences menu, and set the preferences.
Related Topics
A data set is a data management dimension that is used primarily to group data for processing and reporting. All data that resides within the Enterprise Performance Foundation data model must be assigned to a data set code. Although the Oracle Financial Services (OFS) applications use only one dimension for each data set, the applications segment data sets into one of two categories, input data sets and output data sets. The OFS applications can process various input data sets at once but only produce results to one output data set.
The data set group acts as a wrapper associating all data sets to a group for reporting or processing. A data set group tells the engine what combination of input and risk data sets to process, which output data set identifier to write to results tables, or what combination of input or output data sets to view for reports.
Input Data Set: Account and ledger data that is loaded from source systems.
Output Data Set: Results that are calculated through the application are assigned to this data set.
See: About Data Set Groups, Oracle Enterprise Performance Foundation User's Guide and Creating Data Set Groups.
Related Topics
Use the following procedure to create a new data set group and version:
On the Dataset Groups page, click the Create Dataset Group icon.
On the Create Dataset Group: Step 1: Dataset Group Details page, do the following:
In the Folder box, select the folder in which you want to save the data set group.
In the Dataset Group Name box, specify the name for the data set group. The name you specify is also used for the associated version.
If you want to provide a text description for the data set group, type the description in the Description box.
Specify the access rights for the data set group. If you want all users other than yourself to have read-only access rights, so that they can view the group but cannot duplicate, update, or delete it, select Read. If you want all other users to have read and write access rights, so that they are able to view, duplicate, update, and delete the group, select Read/Write.
Click the Continue button to display the Create Dataset Group: Step 2: Dataset Group Definition page.
On the Create Dataset Group: Step 2: Dataset Group Definition page, do the following:
In the Output Dataset box, select the desired output data set.
The data set that you specify as the output data set is automatically defined as an input data set, which ensures that all data currently in the specified output data set is preserved.
Specify any additional input data sets. To specify an additional data set, click the Add Another Row button.
For each input data set, you must either select a specific calendar period in the Calendar Period box or select the Offset box, select the desired period type for the offset in the Period Type box, and specify the desired offset in the Period Offset box.
If you are using an offset, specify a number in the Period Offset box that defines the desired number of offset periods for the type selected in the Period Type box. Use a positive number to specify an offset subsequent to the input date for a calculation, and use a negative value to specify an offset prior to the calculation date. You can also specify an offset of zero (0), which indicates that the calendar period specified in the run parameters is to be used.
For example, to specify an offset that is two months after the calendar period for a calculation, select Month in the Period Type box and specify 2 in the Period Offset box; to specify an offset that is two months prior to the input date for a calculation, select Month in the Period Type box and specify -2 in the Period Offset box.
If you want to use the same period type as the type specified for Output Calendar Period when a calculation is run, select Same as Output Calendar Period.
After you have defined all of the desired input data sets, click the Finish button to complete the data set group and version definition.
Use an Oracle General Ledger (GL) responsibility, such as General Ledger Super User, to enable or disable currencies for Oracle Financial Services (OFS) applications.
Navigate to Setup: Currencies, and select Define.
Search and select a currency.
Select Enable.
See: Defining Currencies, Oracle General Ledger User Guide.
Related Topics
Use an Oracle iSetup responsibility, such as Oracle iSetup, to configure iSetup and map instances for extracting and loading rules.
Log in to Oracle E-Business Suite.
For the remaining steps, see:
Instance Overview, Oracle iSetup User Guide.
Using Oracle iSetup, Oracle iSetup User Guide.
Navigate to Administration: Instance Mapping.
For the remaining steps, see: Instance Mapping, Oracle iSetup User Guide.
Related Topics
You can administer the data in the Enterprise Performance Foundation tables for usage in a Oracle Financial Services application by:
Related Topics
Setting Up Data Inspector Rules
Performing Table and Column Registration Tasks
Performing Dimension Administration Tasks
See: About the Data Inspector and Data Inspector Rules, Oracle Enterprise Performance Foundation User's Guide and Creating Data Inspector Rules.
Related Topics
Use the following procedure to create a new Data Inspector rule and version:
On the Data Inspector Rules page, click the Create button.
On the Step 1: Select Table page, do the following:
In the Folder box, select the folder in which you want to save the rule.
In the Data Inspector Name box, specify the name for the rule. The name you specify is also used for the rule version.
If you want to provide a text description for the rule, type the description in the Description box.
Specify the access rights for the rule. If you want all users other than yourself to have read-only access rights, so that they can view and run the rule but cannot update or delete it, select Read. If you want all other users to have read and write access rights, so that they are able to view, run, update, and delete the rule, select Read/Write.
In the Table box, select the table that you want to access through the rule.
Only tables that have been registered with Enterprise Peformance Foundation are available for selection. For information about registering tables, see Performing Table and Column Registration Tasks.
If you want to include a condition in the rule definition, select the condition that you want to use in the Condition Rule box.
you can also switch to the Condition Creation page, create a new condition for the Data Inspector rule.
Refer to Creating Conditions During Data Inspector Rule Registration, Oracle Enterprise Performance Foundation User's Guide for more information.
Click the Continue button to display the Step 2: Select Columns page.
On the Step 2: Select Columns page, do the following:
Select the columns that you want to display by moving them from the Available Columns box to the Columns Displayed (In Order) box.
Columns denoted by an asterisk (*) are required columns; if you attempt to create a new row when you run the rule, you will only be able to do so if you have selected all of the required columns in this step.
Specify the order in which you want to display the selected columns when you run the rule. The column at the top of the list in the Columns Displayed (In Order) box will appear as the farthest column to the left when you run the rule version; the column at the bottom will appear as the farthest column to the right.
To move a column in the Columns Displayed (In Order) box, thereby changing its placement in the display order, select the column and use the up and down arrow buttons in the Columns Displayed (In Order) box to move the column to the desired position.
Tip: Select the ledger to be the first column displayed, because the ledger selection controls the value sets of all remaining columns on the selected table. When the ledger is selected, all other dimension columns are reset, so the ledger should be selected first.
If you want to make one or more columns editable, so that you can change the values in them when you run the rule version, click the Enable Editable button and select the columns that you want to be editable on the Enable Editable Columns page. Note that not all columns can be designated as editable.
Use the Sort Settings section to order the data that the Data Inspector displays when you run a Data Inspector rule. You can specify as many as three columns on which to sort.
For example, if you have specified the Calendar Period column in the Balances table as the First Sort column name in ascending order, the Balances table will be sorted by calendar period in ascending order when you run the rule.
Click the Finish button to complete the rule and version definition.
The core metadata for Enterprise Performance Foundation consists of table and column definitions and properties. Before tables and columns can be recognized and used by related applications, these tables and columns must be defined and registered within the system. Through the table and column registration facility, you can register tables and columns for use by user interfaces and concurrent programs.
Prior to using the table and column registration facility in Enterprise Performance Foundation, the database administrator for the E-Business Suite must do the following:
Determine which tables and columns are to be used for processing.
For each table in the system, there must be a unique index and a related interface table. It is necessary to alter the unique index for each table to include the columns to be used for processing. In addition, it is necessary to set each column included in the unique index to NOT NULL on the physical table; this must be done for both the base data table and the interface table.
After the unique index has been set for each base data table and interface table, the database administrator must use the Enterprise Performance Foundation table and column registration facility to do the following:
Register the new tables (this step applies only for tables that have not previously been registered).
Synchronize each of the base data tables.
Note: Synchronization is necessary whenever new tables are to be registered or there have been changes to a previously-registered table, and must be performed before defining or updating registration information. Newly added columns in a table will appear first in the Updating table display names and descriptions page after a synchronization.
Define the registration information for each of the base data tables (interface tables do not need to be registered).
Enterprise Performance Foundation supports the definition of user-defined tables. To be available for use, a user-defined table must have a synonym included in the APPS schema, and it must include the appropriate columns to be eligible for specific table classifications. Use the following SQL statement to define a synonym, where USER_DEF_TABLE represents the name of the table:
CREATE SYNONYM APPS.USER_DEF_TABLE FOR FEM.USER_DEF_TABLE;
It is also possible to register fully updateable views.
With the exception of customer account tables, seeded tables cannot be modified. This means that you cannot add or remove columns from the FEM_BALANCES or the FEM_DATA1-20 tables.
For more information, see the following topics:
You can register tables through the Table Registration Wizard. Click the Register New Table button on the Table Registration page to open the Table Registration Wizard.
Important: You must complete all of the steps in the Table Registration Wizard to register a table. If you do not complete all of the steps, the table registration is incomplete, and the table may not be recognized by other applications.
The Table Registration Wizard consists of the following steps:
In the Register New Table step, do the following:
In the Schema box, use the search icon to select the schema that contains the table that you want to register.
In the Table Name box, use the search icon to select the name of the table that you want to register.
In the Table Display Name box, specify the display name for the table (the name for the table that is displayed application user interfaces).
In the Description box, specify a text description for the table.
Click the Next button to display the Table Column Display Names step
In the Table Column Display Names step, you can specify display names, data types, and descriptions for columns. Use the appropriate fields to specify these values, noting the following:
The system might have locked the information in one or more fields for certain columns to protect the integrity of tables; such fields cannot be updated.
If you want to enable a column for use in application user interfaces, select the Enable field for that column. If you do not select the Enabled box, the column will not be displayed in application user interfaces, and it will not be available for use in any business rules.
If you want to change the data type, select the desired data type from the drop-down list under CPM Data Type. Depending on the column definition in the underlying database, different choices are available for CPM Data Type.
If you select Dimension as the CPM data type for a column, then you must supply a value for Dimension Name by selecting the dimension associated with the column.
If you select Term, Frequency, or Statistic as the CPM data type for a column, then you must supply a value for UOM column display name by making a selection from the list of values that associates another column with the item that describes the unit of measure for the term, frequency, or statistic.
If you are aggregating Account table balance columns to the Balances table, then you must set the column CPM Data Type to Monetary Balance. This enables currency conversion during aggregation.
When you have finished, click the Save and Next button to display the Table Processing key step.
In the Table Processing Keys step, use the drop-down box to select the unique index that represents the processing key for the table.
When you have finished, click the Save and Next button to display the Interface Table Column Mappings step.
For user-defined tables, you must specify the mappings between the columns in the base tables and the columns in the interface tables (the mappings are already defined for seeded tables). In the Interface Table Column Mappings step, specify the mappings for user-defined tables as follows:
In the Schema box, specify the schema that contains the interface table for which you want to provide column mappings.
In the Table Name box, specify the name of the interface table for which you want to provide column mappings.
Click the Go button to display a list of column names.
For each base table column listed in the Column Name field, specify the interface table column that you want to map to that base table column by selecting the appropriate value in the Interface Column Name field.
Click the Save and Next button to display the Table Classifications step.
Table classifications determine how tables are used in Enterprise Performance Foundation. Use the Table Classifications step to specify classifications for tables.
Move the classifications between the Available Classifications and Selected Classifications boxes as needed, so that only the classifications that you want to specify for the table are listed in the Selected Classifications box. You can move classifications between boxes by selecting one or more classifications and clicking the Move and Remove buttons, or you can move all classifications at once by using the Move All and Remove All buttons.
Note: The list in the Available Classifications box contains all of the valid table classifications. At a minimum, select the classifications that are pertinent to your purposes, based on the types of calculations to be performed on those tables. You must select at least one classification to successfully register the table, and additional classifications might be needed, depending on the features that will be used in the application.
If you want to specify a certain classification for a table but that classification does not appear in the Available Classifications box, do the following:
Note: For a table to qualify for the table classifications of ACCOUNT_PROFITABILITY, FTP_CASH_FLOW, FTP_NON_CASH_FLOW and FTP_OPTION_COST, the processing key must only have the columns of CAL_PERIOD_ID, DATASET_CODE, SOURCE_SYSTEM_CODE, ID_NUMBER defined. If extra columns are included, the table will not qualify for these classifications.
Click the Other Classifications button to display the Other Classifications page, which provides a list of all classifications.
On the Other Classifications page, find the desired classification and expand the entry so that you can see which classification requirements are missing, thus preventing the table from appearing as an available classification.
Return to the Table Classifications step and complete the Table Registration Wizard.
Correct the problem by supplying any missing classification requirements.
Synchronize the table registrations.
For further information, see Synchronizing table registrations.
Run the Table Registration Wizard again and specify the desired classifications in the Table Classifications step.
When you have finished your work in the Table Classifications step, click the Save and Next button to display the Table Column Property Assignments page.
In the Property box in the Table Column Property Assignments step, do one of the following:
Select Mapping Input Property if you want the columns in the table to be listed in the Initial Data Source section on the Update Formula page for mapping rules.
Select Mapping Output Property if you want the columns in the table to be listed in the Debit and Credit sections on the Update Formula page for mapping rules.
Use the Add Columns button to add additional columns.
To delete a column, click the Delete icon for that column.
When you have finished, click the Finish button to complete the Table Registration Wizard.
You can search for and display existing table registrations through the Table Registration page. To display an existing table registration, specify the name of the table in the Table Name box and click the Go button.
Whenever you make any changes to a registered table, you must synchronize the registration for the table (that is, reread the table so that Enterprise Performance Foundation can recognize and incorporate the changes) before making any updates related to the table.
Use the following procedure to synchronize a table registration:
On the Table Registration page, display the table for which you want to synchronize the registration.
Click the Synchronize icon for the table.
Use the following procedure to update the display name and description for a table:
On the Table Registration page, display the table that you want to update.
Click on the name of the table to display the Update Table Display Name page.
Make any desired changes to the table name and description.
Click the Apply button to apply the updates.
Use the following procedure to update a table registration:
On the Table Registration page, display the table that you want to update.
Click the Update icon for the table to open the Update Table Registration Wizard.
The steps in the Update Table Registration Wizard are the same as Steps 2 through 6 in the Table Registration Wizard. For further information, see Registering new tables.
You can remove the registration for a table so that the table is no longer available in Enterprise Performance Foundation.
Important: If a rule refers to a table for which you remove the registration, the rule will no longer be valid.
Use the following procedure to remove a table registration:
On the Table Registration page, display the table for which you want to remove the registration.
Click the Remove Registration icon for the table, then choose Yes in response to the confirmation prompt.
Through the Dimension Administration page, you can display a list of dimension maintenance tasks for a specified dimension. For each task, the Dimension Administration page shows when and by whom the last update was made, and indicates the status. The status icons are as follows:
A solid square indicates that the task has not been completed or is in the system installation default state.
A check mark indicates that the task has been completed.
For further information, see the following topic:
You can make changes to the display names for dimensions and columns to make the names more user-friendly.
Use the following procedure to specify dimension and column display names:
In the Dimension box on the Dimension Administration page, select the dimension for which you want to specify display names and click the Go button.
Click the Go To Task icon for the Dimension Display Names task.
On the Dimension Column Display Names page, make any desired changes to the dimension display name and the column display names.
Click the Apply button to apply the changes that you have specified.
You can change the dimension properties for a dimension, as follows:
In the Dimension box on the Dimension Administration page, select the dimension for which you want to specify properties and click the Go button.
Click the Go To Task icon for the Dimension Properties task.
On the Dimension Properties page, make any desired changes to the dimension properties, as follows:
Select Line for the dimension type if you want to associate the dimension with particular predefined attributes in an application.
For example, if the dimension is to be used in Enterprise Planning and Budgeting and you want to be able to specify which members are to be loaded or defined in calculations in business processes, select Line as the dimension type (no more than one dimension can have Line as the dimension type within a single business area in Enterprise Planning and Budgeting).
Select Other for the dimension type if you do not need to associate the dimension with particular predefined attributes in an application.
Click the Apply button.
You can define the conditions and different sets of tuning options for rules in an Oracle Financial Services application. These conditions and tuning options are used by the processing engines.
Related Topics
Creating and Updating Tuning Options
A condition is an object that is used to select data for use as input to a business rule. See:
About Conditions, Oracle Enterprise Performance Foundation User's Guide.
Related Topics
Use the following procedure to create a condition:
On the Conditions page, click the Create button.
On the Step 1: Condition Rule Details page, do the following:
In the Folder box, select the folder in which you want to save the condition.
In the Condition Name box, specify the name for the condition.
If you want to provide a text description for the condition, type the description in the Description box.
Specify the access rights for the condition. If you want all users other than yourself to have read-only access rights, so that they can view the condition but cannot update or delete it, select Read. If you want all other users to have read and write access rights, so that they are able to view, update, and delete the condition, select Read/Write.
Click the Continue button to display the Step 2: Condition Definition page.
On the Step 2: Condition Definition page, do the following:
In the Version Details section specify the name, start date, end date, and (optionally) a text description for this version of the condition.
If you want to specify a dimension component, click the Dimension Components button.
For further information, see Working with Dimension Components, Oracle Enterprise Performance Foundation User's Guide.
If you want to specify a data component, click the Data Components button.
For further information see Working with Data Components, Oracle Enterprise Performance Foundation User's Guide.
Click Finish to create the condition or version.
The Process Tuning Options page displays sets of multiprocessing options, or rules, that affect the manner in which the processing engines function. You can use these rules to tune the performance of the engines, according to the tuning options that you define for the rules or rule types.
Navigate to the Process Tuning Options page.
Click Create Tuning Options.
In the Tuning Option> Assignment Level page, select the options and click Continue to open the Update Tuning Options page.
Click Update to open the Multi-processing: Parameters page, if you want to update the tuning parameters, else click Return to Selector to return to the Process Tuning Options page.
Select the options and click Next to open the Multi-processing: Data Slicing Columns page.
Select the columns. Click Add Another Row, if you want to set up a new column for processing, else click Apply to return to the Update Tuning Options page.
See: Working with Process Tuning Options, Oracle Enterprise Performance Foundation User's Guide.
Related Topics
Oracle Financial Services (OFS) applications use the Oracle Discoverer application to run reports. Oracle Discoverer's powerful and intuitive user interface enables you to find data that you know is in the database, access data quickly without waiting for the computer to search through the entire database, and view data in a familiar spreadsheet-style format that is easy to read and understand. Configuring reporting involves the following steps:
Setting up Discoverer End User Layer user interface for customized views.
Configuring dimensions in the End User Layer.
Configuring the Discoverer user interface to prevent general page caching. Set the configuration option include_expiration_tags to true to ensure that Discoverer retrieves the reports properly by fetching current results and does not simply display cached data.
See:
Oracle Business Intelligence Discoverer Administration Guide.
Oracle Financial Services Reporting Administration Guide.
Oracle Application Server Discoverer Configuration Guide
Related Topics
Oracle Financial Services Reporting Administration Guide
You can access the home page in a Oracle Financial Services application by clicking the home page tab. The home page provides you the facility of customizing names and other such information as well as giving links to other files.
Navigate to the Customize Home page.
Enter the system name. The system name is displayed in the Ownership area of the Home Page.
Note: The system name you enter updates the FEM: Application Code profile option at the site level, so the given system name applies to all OFS applications. If you have multiple OFS applications that use Oracle Enterprise Performance Foundation (FEM), then you must set the profile option at the application level for each OFS application. See: Setting Profile Options.
Enter heading text.
Enter informational content. You can use standard HTML commands or plain text.
Click Add New Heading or Link in the Shortcuts Area to create links to files.
Select the heading or link type.
Enter the heading or link name.
Enter the URL location.
Related Topics
Oracle Transfer Pricing and Profitability Manager use Oracle Workflow for notifications. Workflow can be used to notify users about changes to system parameters such as modifications made to processing keys. For a list of notifications to which users can subscribe, see: About Workflow Notifications, Oracle Profitability Manager User's Guide.
For more information, see the Oracle Approvals Management Implementation Guide and the Oracle Workflow Administrator's Guide.
Related Topics
Oracle Financial Services (OFS) applications, such as Transfer Pricing and Profitability Manager, administration includes a function to create security folders and grant users access to them. Folders provide security by hiding rules from users who lack access, or blocking edit from users with read-only rights. The Oracle Financial Services (OFS) applications are seeded with two folders: Default and Data Integration. You can define additional folders.
You must give access to both of the seeded folders to Database Administrators who will be using dimension loader and hierarchy loader concurrent programs. The administrators must be added to the folders before they submit the concurrent programs.
You must also give all Oracle Financial Services (OFS) applications users access to the Default folder, as well as to other folders that they will share.
For information about working with security folders, see: Working with Security Folders, Oracle Enterprise Performance Foundation User's Guide.
Related Topics