Siebel Pricing Administration Guide > Creating and Assigning Price Lists >

About Effective Dates for Pricing Line Items

You can create effective dates for individual line items in a price list, cost list, discount matrix, or component-product price adjustment.

The application prevents you from entering overlapping effective dates for the same line item when you enter effective dates using the New Effective Date button, as described in Giving a Product Multiple Prices with Different Effective Dates.

For example, if a price list has a line item for Product X with a price that is effective from January 2005 through June 2005, do not enter another line item for Product X with a price that is effective from March, 2005 through December 2005, because the product would have two different prices during several months.

This section describes several scenarios that show how the application resolves overlapping dates.

The New Time Interval Overlaps with One Existing Time Interval

This section describes several possible scenarios where a new time interval overlaps with an existing time interval.

If the effective dates in the new record overlap with the existing record's start date, as shown in Figure 1, or with the existing record's end date, as shown in Figure 2, the application displays an error message and does not enter the new effective dates.

Figure 1. New Time Interval Overlaps with an Existing Start Date

Figure 2. New Time Interval Overlaps with an Existing End Date

However, if the new time interval is entirely within an existing time interval and does not overlap with the start or end date, as shown in Figure 3, then the application creates three time intervals, as shown in Figure 4.

Figure 3. New Time Interval Is Within an Existing Time Interval

Figure 4. The Application Creates Three Time Intervals

Likewise, if the new time interval is entirely within an existing time interval but its end date is the same as the end date of the existing interval, as shown in Figure 5, then the application creates two time intervals, as shown in Figure 6.

Figure 5. New Time Interval Is Within an Existing Time Interval and Has the Same End Date

Figure 6. The Application Creates Two Time Intervals

However, if the new time interval is entirely within an existing time interval but its start date is the same as the start date of the existing interval, as shown in Figure 7, then the application displays an error message and does not create the new time interval.

Figure 7. New Time Interval Is Within an Existing Time Interval and Has the Same End Date

However, if the new time interval extends beyond the existing time interval, as shown in Figure 8, then the application displays an error message and does not create the new time interval.

Figure 8. New Time Interval Extends Beyond an Existing Time Interval

The New Time Interval Overlaps with Two Existing Time Interval

This section describes the possible scenarios where a new time interval overlaps with two existing time intervals. The effective dates in the new record may overlap with the effective dates in two existing records, as shown in Figure 9, Figure 10, Figure 11, or Figure 12. In all of these cases, the application displays an error message and does not enter the new effective dates.

Figure 9. New Time Interval Covers One Record and Overlaps with Another's End Date

Figure 10. New Time Interval Covers One Record and Overlaps with Another's Start Date

Figure 11. New Time Interval Covers Two Existing Records

Figure 12. New Time Interval Overlaps with One Record's Start Date and One's End Date