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 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
2. This table describes key terms used for this procedure.
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.