This module discusses the procedure for validating and cleansing your Instrument table data before you process it to generate cash flow based results.
Topics
· Overview of Cash Flow Edit Processes
· Creating Cash Flow Edit Processes
· Executing Cash Flow Edit Processes
Cash Flow Edit processes allow you to verify the accuracy and check the completeness of your Instrument table data.
NOTE:
Cash Flow Edits do not support the Derivatives tables.
The procedure for working with and managing a Cash Flow Edit process is similar to that of other Oracle Funds Transfer Pricing and Oracle Asset Liability Management processes. It includes the following steps:
· Searching for Cash Flow Edit processes. For more information, see the Searching for Rules section.
· Viewing and Updating Cash Flow Edit processes. For more information, see the Viewing and Editing Rules section .
· Copying Cash Flow Edit processes. For more information, see the Copying Rules section.
· Deleting Cash Flow Edit processes. For more information, see the Deleting Rules section.
· Check Dependencies in the Cash Flow Edit processes
· Refresh the Cash Flow Edit Summary page
Figure 1: Cash Flow Edit Summary page
Description of Cash Flow Edit Summary page as follows
You must create and run Cash Flow Edit processes on your Instrument table data before you submit cash flow engine based rules for processing.
For more information, see the following sections:
· Creating Cash Flow Edit Processes
· Executing Cash Flow Edit Processes
Creating a Cash Flow Edit process is a one-step process. You define both the attributes that uniquely describe a particular Cash Flow Edit process and the data to be validated or cleansed by that process on the Create Cash Flow Edit process page.
1. Navigate to the Cash Flow Edits Summary page.
2. Click Add +. The Create Cash Flow Edits Process page is displayed.
Figure 2: Cash Flow Edit Process of ALM Processing
Description of the Cash Flow Edit Process as follows
3. Enter the parameter details shown in the following table.
Parameter |
Description |
---|---|
Filters |
One of the two components that determine the data that will be cleansed by Cash Flow Edit processes. This field allows you to select a subset of data for processing by selecting a Filter that was previously created. The default value is No Filter. |
Source Selection |
One of the two components that determine the data that will be cleansed by Cash Flow Edit processes. This field allows you to select the Instrument tables that must be included in a Cash Flow Edit process. Alternatively, you can select a hierarchy and then select the desired product members that will be included in the process. Note that the Source selection and Hierarchy selection options are mutually exclusive. You can define your dataset by selecting one or the other, but not a combination of both. |
Preview Mode |
Selecting this parameter allows you to view the results of running a Cash Flow Edit process before the system updates the underlying records in the Instrument tables. The default value of this parameter is checked. |
Source Selection: Available Tables |
When Source Selection is selected, you are presented with two Shuttle Control windows that contain the names of the Instrument Tables available for inclusion during a Cash Flow Edit process. |
Source Selection: Selected Tables |
One of the two Shuttle Control windows, it contains the names of the tables that are already selected for processing by the Cash Flow Edit process. |
Cash Flow Edit Rules |
The Cash Flow Edit Rule section provides a summary of all seeded cash flow edit rules. See this list to understand the validations that are applied to the cash flow fields on the instrument records and also view the default values that are applied when errors are found. |
4. Complete standard steps for this procedure. For more information, see the Creating Rules section.
NOTE:
At this point, you can input the components to ensure that the data processed by Cash Flow Edits will be clean. If you save the Rule without selecting Instrument tables or selecting product members from the hierarchy, the Process will be saved but no data is selected for cleansing.
5. (Optional) Select a Filter.
6. Select the Instrument tables or use a hierarchy to make Product member selections.
NOTE:
Use the Source Selection Shuttle Control to select the Instrument tables that you want to include in the Cash Flow Edit process. You can move Instrument tables from Available Tables into Selected Tables and vice versa by using Move, Move All, Remove, and Remove All. These tables can also be reordered to change the order of processing.
Initially, the selected tables list is empty. However, during subsequent runs, the selected tables list retains the names of the tables that you selected previously. For example, if you select two tables and save the Cash Flow Edits Process, the system shows them the next time you open the rule.
A table name shown in the Selected Tables list does not appear in the Available Tables.
7. Click Save.
The Cash Flow Edits process is saved and the Summary page is displayed.
Execute a Cash Flow Edit process to check the accuracy and the completeness of your Instrument table data. When run in Preview mode, you can view the results of running a Cash Flow Edits process by querying the FSI_PROCESS_ERRORS table for generated errors before the system updates the underlying records in the Instrument tables.
Prerequisites
Predefined Rules
To execute the cash flow loader, follow these steps:
1. Navigate to the Cash Flow Edits Summary page.
2. Search for a rule.
3. Select a process and click Run to execute the selected process. The Cash Flow Edits Run Confirmation page is displayed. The status of the process is displayed in the Status column. After completion of the process, you can navigate to the Log Viewer page by selecting View Log hyperlink. From the Log Viewer, you can access a report that provides details of any cash flow edit errors that were identified by the process.
NOTE:
You can view the results of running a Cash Flow Edits rule before the system updates the underlying records in the Instrument tables, provided you selected Preview Mode while defining it. If the rule runs in Preview Mode, query the FSI_PROCESS_ERRORS table for any generated errors.
NOTE:
If you do not want to run the process immediately, make a note of the System ID displayed by hovering over the Name. You can use the System ID to schedule the execution of the process on the Operations and select Batch Scheduling window. For more information, see the Batch Execution and Batch Scheduling sections in the OFSAAI User Guide.