Skip Headers

Oracle Transfer Pricing User Guide
Release 12.1
Part Number E13524-03
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Common Rule Management Tasks

This chapter focuses on the rule management tasks that are common across all rules in this application.

This chapter covers the following topics:

Overview of Common Rule Management Tasks

The rule management tasks that are common to business rules in this and other applications are as follows.

Note: You can perform these tasks from the home page for the type of rule with which you are working. Depending on the rule type, some tasks might not be available.

The procedures for carrying out these tasks are the same for each rule type, except for rule-specific steps explicitly stated in the rule-specific documentation.

The Rule Home Page

The Rule home page is the gateway to all rules and related functionality of the application. From there, you can navigate to other related pages.

On the header of the Rule home page, you can perform simple queries on Folder, Rule Name and Effective Date.

The following table shows the page components.

Name Type Default Value Required/ Optional Updatable LOV, additional information
Folder Drop Down Set in Application Preferences Required - for filtering the rules under the folder No – Only able to select from presented list. N/A
(Rule) Name Text Box None Optional – for filtering the rules on Rule Name Yes You can specify all or part of a rule name For example, if you want to see only those Rules which start with ‘A' – Enter A in the text field
Effective Date Date Field None Optional – for filtering the rules on Version Effective Dates Yes Returns those Rules with Version effective dates that correspond with the date you enter
Go Button N/A N/A No Initiates rule search based on specified criteria.
Create Rule Button N/A N/A No IInitiates the rule creation process.
Expand All Link N/A N/A No Displays rules with version information
Collapse All Link N/A N/A No Displays only the Rule names
Focus Link N/A N/A No Displays the selected Rule and Version information only.
(Rule) Name Link N/A N/A No Links to the Rule's basic details
Start Date Display Value N/A N/A No Version effective start date
End Date Display Value N/A N/A No Version effective end date
Approval Status Display Value N/A N/A No Displays whether this Rule version is approved, submitted, or new
Approved By Display Value N/A N/A No Who approved the Rule version
Approved Date Display Value N/A N/A No When was the rule version approved
Submit Icon N/A N/A No Click to have the rule version approved
Approved rules can run against production or non-production datasets
Unapproved rules can only run against non-production datasets.
Revert Icon N/A N/A No Click to restore a rule definition to its previous approved state.
For example, if you modify an approved rule definition, the approval status automatically changes to Not Approved. If, for some reason, you do not wish to keep the modifications, you can revert these changes to the last approved version.
Duplicate Icon N/A N/A N/A Initiates process for duplicating rules. Explained later in this document
Run Icon N/A N/A N/A Initiates process for running Rules Explained later in this document.

Searching for Rules

Search for a business rule to perform any of the following tasks:

Procedure

  1. Navigate to the rule home page for the appropriate rule type.

  2. Search for the rule, as follows:

    1. Select the folder in which the rule is stored.

    2. (Optional) Enter the name of the rule.

    3. (Optional) Select the effective date.

    4. Click Go.

      Only rules that match the search criteria are displayed.

      Please refer to Overview of Common Rule Management Tasks for more information.

Creating Rules

You create a rule to specify the way you want a particular task or business process to be carried out by the application. Creating a rule is a two-step process, in which you first specify the properties for the rule itself, and then specify the properties for the rule version.

Procedure to Create a Rule and Version

  1. Navigate to the home page of the rule you want to create.

  2. Click Create to display the rule definition page.

  3. Select the folder in which you want to store the rule.

  4. Enter a name for the rule.

    Important: The name of a rule must be unique across all the rules and rule types in the entire database, not just at the folder level.

  5. (Optional) Enter a brief description for the rule.

  6. Select the required access for other users.

  7. Click Continue.

    The version definition page is displayed.

  8. Type the name of the version for the rule.

  9. Select the effective start and end dates using the date picker. Alternatively, you can type them in the space provided.

    Important: Each version must have a unique date range, as compared to all other versions for the same rule.

    Note: If not specified otherwise in the related profile option, the defaults for the effective start and end dates are January 1, 1900 and December 31, 2500.

  10. Specify any other properties or options that may apply for the version that you are creating.

  11. Click Finish.

    Please refer to Overview of Common Rule Management Tasks for more information.

Viewing and Updating Rules

You can view existing rules and rule versions, and you can update certain properties for rules and versions.

Note the following considerations with regard to updating rules and versions:

Procedure

  1. Navigate to the home page of the rule you want to update.

  2. Search for a rule. For further information, see Searching for Rules.

  3. Click Update corresponding to the rule or version that you want to update if you are familiar with the rule or version details and would like to update the rule or version directly. Alternatively, click on the rule or version to view details and then click Update on the View page.

    Procedure to Update a Rule

    1. Update the Name or Description.

    2. Click Apply.

Duplicating Rules

You can duplicate rules and versions to avoid having to enter data multiple times. This saves time and effort and also reduces mistakes. You can duplicate only the version, or you can duplicate both the rule and the version.

When duplicating a version, the rule-related details cannot be updated. All existing versions for a rule are listed at the bottom of the duplicate page.

When you duplicate the version and the rule, a new rule is created with a copy of the version.

Procedure

  1. Navigate to the home page of the rule or version you want to duplicate.

  2. Search for a rule. For further information, see Searching for Rules.

  3. Click Duplicate corresponding to the version of the rule that you want to duplicate.

Procedure to Duplicate a Version

  1. Select Version to create a new version in the same Rule.

  2. Enter a unique name for the version.

  3. (Optional) Enter a brief description for the version.

  4. Select the effective start and end dates using the date picker. Alternatively, you can enter them in the space provided.

    Caution: The new version's date range must not overlap with any of the existing version date ranges.

  5. Click Finish.

Procedure to Duplicate a Rule and Version

  1. Select Rule and Version to create a new rule and a version.

  2. Select the folder in which the rule will be stored.

  3. Enter a name for the rule.

  4. Enter a name for the version.

  5. (Optional) Enter a description for the version.

  6. Update the effective start and end dates using the date picker. Alternatively, you can type them in the space provided.

  7. Click Finish.

    Please refer to Overview of Common Rule Management Tasks for more information.

Deleting Rules

You can delete rules that are no longer needed. To delete a rule, you delete all of the versions that are associated with that rule.

Caution: Once deleted, a rule cannot be retrieved.

Restrictions on deleting rules or versions are:

Procedure

  1. Navigate to the home page of the rule you want to delete.

  2. Search for a rule. For further information, see Searching for Rules.

  3. Click Delete corresponding to the rule or the version of the rule that you want to delete.

    Please refer to Overview of Common Rule Management Tasks for more information.

Extracting and Loading Rules

Enterprise Performance Foundation utilizes iSetup for extracting and loading rules in a folder within a single environment and for extracting and loading rules across multiple environments. For example, you can develop and test business rules in a testing environment and then load those rules to a production environment.

The Extract/Load features can also handle sub-objects. For example, the Enterprise Performance Foundation Mapping Rule type "Retrieve Statistics" is comprised of a mapping rule and a statistic definition. The statistic definition also includes a Condition. When you extract or load the "Retrieve Statistics" rule, both the statistic definition and its condition will automatically be included in the process.

The Extract and Load options are available through iSetup and let you initiate an Extract of a Folder's rules. Using the Load page you can load the extracted rules to the specified user's folder. You can extract, or load the following types of rules:

Prerequisites, Guidelines, and Considerations

In order to extract and load rules successfully, you must first ensure that the following requirements are met and that the systems are set up properly:

The Dimension Member and Dimension Hierarchy Migration and Loader Process

The migration and loader process is a simple two-step operation:

  1. Login to Enterprise Performance Foundation Administrator in the target environment and migrate the dimension members and/or dimension hierarchies.

  2. Login to Enterprise Performance Foundation Administrator in the target environment and load the dimension members and/or dimension hierarchies.

Step 1: Migrate the Dimension Members or Dimension Hierarchies

Follow these steps to migrate Dimension Members or Dimension Hierarchies

  1. Login to Enterprise Performance Foundation Administrator in the target environment and navigate to the Process Management tab and select the Requests sub tab.

  2. Migrate Dimension Members or Dimension Hierarchies

    Note: A registered database link must be in place between the source and target environments.

    To Migrate Dimension Members:

    1. Schedule a Request by selecting Dimension Member Migration for the Program Name and click Next

    2. Set Parameters: select a Source Database, select the Dimension to be migrated and click Next.

    3. Enter Scheduling parameters (optional) and click Next.

    4. Enter Recipient Notifications (optional) and click Next.

    5. Enter Printing styles (optional) and click Next.

    6. Review parameters and click Submit.

    To Migrate Dimension Hierarchies:

    1. Schedule a Request by selecting ‘Dimension Hierarchy Migration' for the Program Name and click Next.

    2. Set Parameters: select a Database Link, select a Dimension, enter a Hierarchy from the source environment, enter the Hierarchy Version (optional), enter Dimension Name (optional) and click Next.

    3. Enter Scheduling parameters (optional) and click Next.

    4. Enter Recipient Notifications (optional) and click Next.

    5. Enter Printing styles (optional) and click Next.

    6. Review parameters and click Submit.

  3. Navigate to the Process Management tab and select the View Requests sub tab to monitor the progress of the migration program.

    Note: Clicking on the Details hyperlink of the request will display a page where you can view the log generated by the migration.

Step 2: Load the Dimension Members or Dimension Hierarchies

Follow these steps to load the Dimension Members or Dimension Hierarchies

  1. Login to Enterprise Performance Foundation Administrator in the target environment and navigate to the Process Management tab and select the Requests sub tab.

  2. Load Dimension Members or Dimension Hierarchies

    Note: A registered database link must be in place between the source and target environments.

    To Load Dimension Members:

    1. Schedule a Request by selecting ‘Dimension Member Loader' for the Program Name and click Next.

    2. Set Parameters: select Execution Mode, select the Dimension to be loaded and click Next.

    3. Enter Scheduling parameters (optional) and click Next.

    4. Enter Recipient Notifications (optional) and click Next.

    5. Enter Printing styles (optional) and click Next.

    6. Review parameters and click Submit.

    To Load Dimension Hierarchies:

    1. Schedule a Request by selecting ‘Dimension Hierarchy Loader' for the Program Name and click Next.

    2. Set Parameters: select the Hierarchy Loader Rule Name, select the Execution Mode, select the Dimension, select the Hierarchy Name, select the Hierarchy Definition Name and click Next.

    3. Enter Scheduling parameters (optional) and click Next.

    4. Enter Recipient Notifications (optional) and click Next.

    5. Enter Printing styles (optional) and click Next.

    6. Review parameters and click Submit.

  3. Navigate to the Process Management tab and select the View Requests sub tab to monitor the progress of the loader program.

    Note: Clicking the Details hyperlink of the request will take you to a page where you can view the log generated by the loader.

The iSetup Extract and Load Process

The extract and load process is a simple two-step operation:

  1. Login to iSetup in the source environment; extract the rules in a folder by selecting or creating a Selection Set.

  2. Login to iSetup in the source environment; select the extract file and load to the source or target environment.

Step 1: Extract the rules in a folder

Note: If Workflow is enabled, only versions with an Approval Status of: New, Approved, or Not Approved can be extracted.

Use the following procedure to extract rules in a folder

  1. Login to iSetup and navigate to the Migrations tab and select the Selection Sets sub tab.

  2. Create or select an existing Selection Set.

    Note: A Selection Set contains the rules that the extract program will use to pull the types of objects in the selected environment.

    To create a Selection Set

    1. Click Create and select the template to pick which objects will be extracted:

      • Profitability Manager Setups such as Mapping Rules, Conditions, Statistics and Factor Table rules)

      • Oracle Transfer Pricing Setups (such as Prepayment rule, Prepayment Table rule, Rate Index rule, Adjustments rule, Alternate Rate Output Mapping rule, and Transfer Pricing Process rule)

    2. Click Continue and enter a name for the Selection Set and choose the Source Instance from which the Selection Set will extract the objects.

    3. Select the types of rules you want to extract. For example, you can choose Mapping, Conditions, Statistics and Factor Table rules.

    4. Click the Filter icon and choose the folder that contains the rules you wish to extract. You must choose a folder for each rule type that you include in the Selection Set.

    5. Click Apply to create the Selection Set.

  3. Click Extract to begin the extract process and then click Create

  4. Enter a name for the extract process, and choose the Source Instance and the appropriate Selection Set from the list.

    Note: Users have the option to change the Selection Set and Source Instance; however, changing the Selection Set and/or Source Instance may invalidate the filters set at the time of the creation of the Selection Set.

  5. Click Continue to navigate to the Schedule page and enter execution details.

  6. Click Finish to submit the extract request. You will be returned to the Extracts page where you can view the progress of the extract.

    Note: Clicking on the Name hyperlink of the extract will take you to a page where you can view the log generated by the extract.

    Note: An extract will generate a .zip file that can only be used in a Load.

Step 2: Load the folder rules to an environment

Note: Loading rules to an environment different from the Source environment will require setting up an Instance Mapping on the Oracle iSetup Administration Tab. For more information, see: Working with Registered Database Links, Oracle Enterprise Performance Foundation User's Guide.

Follow this procedure to load the folder rules to an environment

  1. Login to iSetup and navigate to the Migrations tab and select the Extracts sub tab.

  2. Search for an active Extract and select.

    Note: An Active Extract is an extract that has a Normal Status indicator.

  3. Click Load to navigate to the Set Parameters page and enter a name for the load process to be executed.

    Note: Users have the option to change the extract load file by updating the Data Source field. Users also have the option to select the target environment for the load, migrating the rules to the target instance. The Target Instance will only display registered DBC file names.

  4. Click Next to view the Set Objects Details page. This is an informational page for the objects that will be created/updated in the target environment.

  5. Click Next to navigate to the Schedule page and enter execution details.

  6. Click Finish to submit the load request. You will be taken to the Loads page where you can view the progress of the load.

  7. Clicking on the Name hyperlink of the load will display a page where you can view the log generated by the load.

iSetup Load Rule Behavior

If the rules of a folder have been loaded successfully, subsequent loads of the rules will either overwrite the rules in the folder if they exist for the same effective date range or add itself to the rule when the effective date ranges are different.

An extracted rule cannot be loaded into a rule where it will cross the effective date ranges of any two existing versions within the rule.

Furthermore, an extracted rule cannot be loaded into a rule where it will overwrite the effective date range of a rule that has been used in a calculation (a locked rule).

Extracts or Loads of rules with sub-objects have the following distinctions: