This chapter discusses the procedure for validating and cleansing your Account table data before you process it to generate transfer pricing results.
This chapter covers the following topics:
Cash Flow Edit rules allow you to verify the accuracy and check the completeness of your Account table data. See: Performing Cash Flow Edits.
The procedure for working with and managing the Cash Flow Edits rule is similar to that of other Oracle Transfer Pricing business rules. It includes the following steps:
Searching for Cash Flow Edit rules. See: Searching for Rules.
Viewing and Updating Cash Flow Edit rules. See: Viewing and Updating Rules.
Duplicating Cash Flow Edit rules. See: Duplicating Rules.
Deleting Cash Flow Edit rules. See: Deleting Rules.
Ideally, you should create and run Cash flow Edit rules on your Account table data before you submit it to the cash flow engine for processing. See:
Related Topics
Cash Flow Edit Logic, Oracle Financial Services Reference Guide
Creating a Cash Flow Edit rule is a one-step process. You define both the attributes that uniquely describe a particular Cash Flow Edit rule and the data to be validated or cleansed by that rule on the Create Cash Flow Edit Rule page.
Procedure
This table describes some terms in the pages used for this procedure.
| Term | Description |
|---|---|
| Conditions | One of the two components that determine the data that will be cleansed by Cash Flow Edit rules. Previously known as the Data Filter ID, this field allows you to select a subset of data for processing by selecting a Condition that was previously created. Its default value is blank. |
| Tables | One of the two components that determine the data that will be cleansed by Cash Flow Edit rules. This field allows you to select the Account tables that need to be included in a Cash Flow Edit process. |
| Preview Mode | Selecting this check box allows you to view the results of running a Cash Flow Edit rule before the system updates the underlying records in the Account tables. Its default value is unchecked. |
| Available Tables | One of the two Shuttle Control windows, it contains the names of the Account tables available for inclusion during a Cash Flow Edit process. |
| Selected Tables | One of the two Shuttle Control windows, it contains the names of the tables that have already been selected for processing by the Cash Flow Edit process. |
Navigate to the Cash Flow Edits rule home page.
Click Create.
The Create Cash Flow Edits Rule page is displayed.
Complete standard steps for this procedure. See: Creating Rules.
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 entering any of the Cash Flow Edit components, the Rule will be saved but no data would be selected for cleansing.
(Optional) Select Preview Mode. You can also select Preview Mode on the Cash Flow Edits rule run page.
Important: If you do not select Preview Mode, data inconsistencies are corrected and a log of the changes is output to the log table.
(Optional) Select a Condition.
Select the Account tables.
Note: Use the Shuttle Control to select the Account tables that you want to include in the Cash Flow Edit process. You can move Account 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 Rule, the system shows them the next time you open the rule.
A table name shown in the Selected Tables does not appear in the Available Tables.
Click Apply.
The Cash Flow Edits rule is saved and the home page is displayed.
Related Topics
Overview of Cash Flow Edits Rules
You execute a Cash Flow Edit rule to check the accuracy and the completeness of your Account table data.
Prerequisites
Procedure
Navigate to the Cash Flow Edits rule home page.
Click Run corresponding to the rule you want to execute. The Cash Flow Edits run page is displayed.
Note: You can view the results of running a Cash Flow Edits rule before the system updates the underlying records in the Account tables, provided you selected Preview Mode while defining it.
(Optional) Select Preview Mode if you did not do so on the Create Cash Flow Edits rule page.
Important: If you do not select Preview Mode, data inconsistencies are corrected and a log of the changes is output to the log table.
Click Submit to execute (run) the rule.
The Requests page is displayed.
Important: In case you do not want to run the rule immediately, click Apply to save the settings, and make a note of the Job ID displayed by the application. You can use the Job ID to schedule the execution of the rule on the Process Management tab. See: About Concurrent Programs and Requests, Oracle Enterprise Performance Foundation User's Guide.
Procedure to Determine the Object ID of the Cash Flow Edits Process
Click Refresh repeatedly on the Requests page until the Phase (status) of the Cash Flow Edits process is displayed as completed.
Click on Details. The Requests details page is displayed.
Click View Log on the Requests details page.
Note the Load Data ID. The Object ID is numerical part of the Load ID. For example, if the Load ID is FTP.RUNBCPROCID11375, then 11375 is the Object ID.
You can use the Object ID to view the results of the Cash Flow Edits process as follows:
Create a Condition associated with the Object ID Number. See: About Conditions, Oracle Enterprise Performance Foundation User's Guide.
Query the FTP_CF_CORRECTIONS table with a Data Inspector rule to view the data. See: About the Data Inspector and Data Inspector Rules, Oracle Enterprise Performance Foundation User's Guide.
Important: You can also use the Requests subtab on the Process Management tab to determine the Object ID of the Cash Flow Edits process. See: About Concurrent Programs and Requests, Oracle Enterprise Performance Foundation User's Guide.
Related Topics