16 Application Preferences

Application Preferences allow both Administrators and End Users to establish default values and to manage other core application parameters that affect the way business rules are created and the way Transfer Pricing Processes are run.

The procedure for working with and managing Application Preferences includes updating the FTP application preferences.

Updating FTP Application Preferences

Updating FTP Application Preferences is a one-step process. You navigate to the Application Preferences screen and you define your Preferences.

To update the FTP application preferences, do the following:

1.       From LHS menu, select Funds Transfer Pricing, and then select Application Preferences to display the Application Preferences page.

Figure 1:   Application Preference page

This illustration shows the Application Preference window. You must enter the preference details of your application. Based on the preference details, you can manage other core application parameters that affect the way business rules are created and the way Asset Liability Management Processes are run.  Enter the parameter details and click Apply. See the following table for parameter details.

 

2.      This table describes key terms used for this procedure.

Table 1:   Form fields to define the Application Preference settings for ALM application

Term

Description

Show Preferences For

There are two modes in which you can access Application Preferences:

·        Administrator: If the user has Administrator privileges, he can define preferences for the “All User” group and for his own personal account, which may be the same or different from the “All User” settings. The Administrator can also designate the “All User” preferences as Editable or Non-editable on a row by row basis. If the individual preference is checked as “ Is Editable”, then End Users can update or override the Administrator’s default value for their own individual account. If the “is editable” box is not checked, then End Users are not able to change the default for their own account.

·        End User: If the user does not have administrator privileges, then certain preference items may have been pre-set by the administrator and the user may not be allowed to change the value. All Application Preference settings are displayed, regardless of access privilege.

Active for Master Maintenance

If a user has more than one application available on their Left Hand menu, then they will need to designate Application Preferences from one of their applications as “Active for Master Maintenance”. Certain preferences such as the default folder and read / write access setting will be referenced by items within Master Maintenance based on this selection.

Security Map

This option allows you to select an existing security map. Security Maps can be used to control the dimensions and dimension members each user can access when building and executing rules. For more information on Security Mapping, refer to Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) User Guide Release 8.0.

As of Date

All processes reference this date at run time to determine the data to include in the process. The As-of-Date value you set in Application Preferences applies to interactive job execution (i.e., when you choose to execute a process directly from a Summary screen). For batch processing, the As-of-Date is an input parameter.

Show Execution Parameters

If this option is selected, a pop-up window appears whenever you execute a process interactively from a Summary screen. Within this pop-up window, you may confirm or modify your run execution parameters (As-of-Date and Legal Entity).

Legal Entity

Similar to As-of-Date, all processes reference Legal Entity at run time to determine the data to include in the process. The value of Legal Entity you set in Application Preferences applies to interactive job execution (i.e., when you choose to execute a process directly from a Summary screen). For batch processing, Legal Entity is an input parameter.

Note: Legal Entity is designed to support implementations that require multi-entity or multi-tenant functionality. If your implementation does not require this functionality, you may utilize the Default Legal Entity in all your processes.

No additional parameter is required for Legal Entity for command line execution. EPM Engines read the default Legal Entity from the Application preference value saved for the User who is executing from command line.

The default legal entity is a per user preference setting. To set this, the following steps are required:

1.       Create a security-map in AAI containing the legal-entity hierarchy as an app-admin.

2.       Set the default security-map in a user preferences.

3.       Navigate to "execution parameters" block in user-preferences and choose the default legal-entity member.

If you do not want to use the Multi-Entity feature with Security, you need to save the Application preference for the user executing the batch. The usual choice for Legal Entity would be Default Member in Application preferences.

Default implies -1 code.

Default value for Legal Entity dimension column in all instrument and ledger table is -1.

Disable Legal Entity

If the "Disable Legal Entity" check box in application preferences screen is checked, then Legal Entity will no longer be a run time parameter. On disabling Legal Entity, user should edit the already defined Variable Allocation rules and modify the value of Legal Entity dimension in all applicable tabs (Source, Driver and Outputs) in the allocation specification screen. This is an optional parameter.

Default Total Error Message Limit

Transfer Pricing Processes log error details into the FSI_PROCESS_ERRORS table. This parameter defines the limit on the total number of errors that will be logged for any TP Process.

Default Error Message Limit Per Item

This parameter defines the total number of errors that will be logged for a given type of error.

Debugging Output Level

The debugging output level determines the amount of sql that will be written to the processing log. There are three levels available:

·        Do not output SQL: A log file will not be created.

·        Output Significant Calculation SQL: Log file is created and will contain those SQLs that are tagged as significant.

·        Output All SQL: Log file is created and will contain all the SQL that the engines execute.

The log files can be accessed by the system administrator in the following location on the server:

$FIC_HOME/ficdb/log/FusionApps/ folder

The file names will be prefixed with the application initials and will also contain the unique batch run id of the execution request.

for example: ofstp.<batch-run-id>.log

Maximum Number of Instrument Records to Include in Detail Cash Flow Output

This parameter allows administrators to define the maximum number of instrument records that any user can select within a process for outputting detailed cash flows. In Funds Transfer Pricing, the maximum value is 10,000. It is recommended however, that this value be set to 100 or less.

Maximum Number of Rate Paths for Monte Carlo Processing

This parameter allows administrators to limit the number of rate paths that can be selected by a user when running a Monte Carlo based process. The maximum value is 2,000.

Random Number Generation Seed Method

Determines the type of random number generation seed method for Monte Carlo processing. Selections include Fixed Seed (default) and Variable Seed.

Initial Seed Value

The Initial seed value input is available when the Seed Value Method is Fixed Seed. The default value is zero.

Option Cost Precision Factor

The Option Cost calculator - Static Spread value is calculated using the Newton-Raphson algorithm. Users can control the convergence speed of the algorithm by adjusting this value. Precision increases as this value decreases, but processing time also increases as the value decreases. The default value is one.

Enable Holiday Calendar Adjustments

Select this option to enable the Holiday Calendar Adjustment capability for the FTP Application. If this option is not selected, the TP Engine will ignore all Holiday Calendar information, including instrument level inputs and assumption rule level inputs.

Logic for applying Holiday Calendar assumptions is as follows:

·        If Application Preferences - ‘Enable Holiday Calendar Adjustments’ check box is on, then the CFE will handle these Holiday Calendar assumptions based on the Account Level values first.

·        If Application Preferences – ‘Enable Holiday Calendar Adjustments’ check box is on, and if Holiday Calendar inputs are not defined at the Account Level, then the CFE will refer to the Product/Currency assumptions (TP rule and Adjustment rule).

·        If Application Preferences – ‘Enable Holiday Calendar Adjustments’ check box is on, and if Holiday Calendar inputs defined at the Account Level AND Product/Currency Assumption level, then the CFE will refer to the Account level inputs.

·        If Application Preferences – ‘Enable Holiday Calendar Adjustments’ check box is off, then no Holiday Calendar assumptions will be applied.

Folder Name

This parameter allows you to define the default folder selection. The folder selection for all rule types will be defaulted to this selection within the summary page search screen and when creating a new rule. This selection acts as the starting value for convenience only and users can change to any other available value at their discretion.

Access Type

This parameter allows you to set the default access type setting. Selections include Read / Write and Read Only. This selection acts as the starting value for convenience only and users can change at their discretion.

Initial Currency Selection

(“Business Rule Currency”)

This parameter allows you to select the starting currency to be displayed within all business rules. This selection is made for convenience and can be changed within all business rules at the user's discretion.

 

Product Dimension

Transfer Pricing requires users to declare one of the “Product” dimensions as the TP Product dimension. The model is seeded with 3 possible selections:

·        Product

·        Common COA

·        GL Account

Users can also add user defined product dimensions, which would also appear in the above list. Transfer Pricing business rules are based on the Product dimension selected here. The suggested default is the “Product” dimension.

Default Product Hierarchy

The list of values for Default Product Hierarchy is based on the Default Product Dimension selection. The hierarchy selected here will be the default hierarchy selection in all business rules that support node level assumptions. This selection acts as the starting value for convenience only and users can change at their discretion within each business rule.

Organizational Unit Dimension

Reserved for future release.

Hierarchy Members Navigation Size

This parameter allows you to specify the maximum number of members that a parent node within a Hierarchy or Assumption Browser can show at a given time. When you expand a branch in a Hierarchy or Assumption Browser and the number of members in that branch exceed the specified Navigation Size, it will provide "More" and "Previous" options to enable you to navigate through the member list.

Recommended values for Navigation Size are 50 to 100. Higher value settings could impact screen refresh performance. The UI allows you to enter a value up to 10000.

Ledger Migration – Rate Weighting Element

Select the instrument table balance to use for weighting the rates during the migration process. Following options are available: Average Book Balance, Ending Book Balance, or Custom Balance. If “Custom Balance” is selected, the user is presented with a list of Balance type columns to use as the weighting element. The list of available “Custom Balance” columns is read from the “Portfolio” table classification list.

TP Charge / Credit Balance

Select the Balance to use for calculating the Charge/Credit amount. Select from Ending Book Balance or Average Book Balance when using the "Ledger" based migration option. For calculating instrument level charge/credit amounts, you may also choose the Custom Balance option.

The formula used is:

Rate x TP Charge / Credit Balance x Accrual Basis

Available selections include Ending Balance, Average Balance and Custom Balance. If Custom Balance is selected, the user is presented with a list of Balance type columns to choose from. The list of available “Custom Balance” columns is read from the “Portfolio” table classification list.

The user should be aware of the Transfer Pricing Migration methodology being used before making this selection. The custom balance option only applies to the Instrument Charge / Credit method and does not apply to Ledger Migration.

3.      Input the values for all the line items.

NOTE

If you are the application administrator define default values for the “All User” group by making the appropriate selection from the drop list at the top of the page. Pay particular attention to the “Is Editable” status and determine which items require administrative control and which items non-administrative users will be able to set for themselves.

4.     Select Apply to confirm changes.