Defining the Price List Hierarchy

Oracle Revenue Management and Billing allows you to define the price list hierarchy. It helps you to inherit the price item pricing from the parent price list if the price item pricing is not available in the price list (assigned to the account, person, or parent person). And, if the price item pricing is not available in the parent price list, the system will search for the price item pricing in the parent's parent price list (i.e. in the grandparent price list) and continue till it reaches the last level in the hierarchy.

In other words, when you define the price list hierarchy and assign the price list to an account or a person, the account or person can avail the price item pricing listed on the parent or grandparent price list if it is not available on the assigned price list. However, if the price item pricing is available on both the assigned and parent price lists, the system derives the price item pricing from the assigned price list.

You can define multiple parent price lists for a price list. But, only one parent price list is effective for a particular duration. Two or more price lists can have the same parent price list.

Procedure

To define the price list hierarchy:

  1. Click the Hierarchy or Show All link from the Section in the Price List screen when you are defining, editing, or copying a price list.

    The Hierarchy section appears. It contains the following fields in a grid:

    Field Name Field Description Mandatory (Yes or No)
    Parent Price List Effective From Date Used to specify the date from when the price list inherits pricing from the parent price list. Yes (Conditional)
    Note: This field is required when you are associating the price list with a parent price list.
    Parent Price List Effective To Date Used to specify the date till when the price list inherits pricing from the parent price list.
    Note: The parent price list effective to date cannot be earlier than the parent price list effective from date and later than price list effective end date.
    		 No
    Parent Price List Used to specify the parent price list ID to which you want to associate the price list.
    Note:

    The Search (The Search Icon) icon appears corresponding to this field. On clicking the Search icon, the Price List Search window appears.

    On specifying the parent price list, the description of the parent price list appears corresponding to the Parent Price List field.

    		 Yes (Conditional)
    Note: This field is required when you are associating the price list with a parent price list.
  2. Enter the required details in the Hierarchy section.
    Note: You can search for a price list by clicking the Search (The Search Icon) icon corresponding to the Parent Price List field.
  3. If you want to associate the price list with more than one parent price list, click the Add (The Add Icon) icon corresponding to the parent price list and then repeat step 2.
    Note:

    You can associate a price list with multiple parent price lists. But, only one parent price list is effective for a particular duration. Also, while associating a price list with a parent price list, you can only specify a price list which is effective during the specified duration.

    If you want to remove a parent price list from the price list hierarchy, click the Delete (The Delete Icon) icon corresponding to the parent price list.

  4. Click Save.
    The price list is associated with the parent price lists.

Related Topics

For more information on... See...
How to define a price list Defining a Price List
How to edit a price list Editing a Price List
How to copy a price list Copying a Price List