Due Date based on Bill Creation or Completion Date

Oracle Revenue Management and Billing enables you to derive the bill due date for an account using the bill creation or completion date. In order to calculate the bill due date for an account using the bill creation or completion date, you need to attach an algorithm which is created using the C1DUDTCALC algorithm type to the Override Due Date system event of the respective customer class. This algorithm contains the following parameters:

• Days To Add - Used to specify the characteristic type which indicates the number of days you want to add to the bill creation date or bill completion date in order to derive the bill due date. This type of characteristic is defined for an account.

• Specific Date - Used when you want a specific date to be a bill due date. In such case, the month and year for the bill due date are derived from the bill creation date or bill completion date. This parameter is used when the characteristic type specified in the Days To Add parameter is not defined for the account. If the derived bill due date is earlier than bill creation date or bill completion date, the system adds one month to the bill due date. Here, the parameter value should be greater than zero and less than or equal to 28.

• Due Date Rule - Used to specify the characteristic type which indicates whether the bill due date should be calculated considering the business days (i.e. excluding weekends and holidays) or considering the calendar days (i.e. including weekends and holidays). This type of characteristic is defined for a division. The system derives the characteristic from the division to which the account belongs. Here, you must specify a predefined characteristic type which has the following two characteristic values:

  Characteristic Value	Should be…
  W	Used when you want to calculate the bill due date considering the business days (i.e. excluding weekends and holidays). The system derives the business days from the work calendar of the division. If the holidays are defined in the work calendar of the division, the system excludes the holidays along with weekends during bill due date calculation.
  C	Used when you want to calculate the bill due date considering the calendar days (i.e. including weekends and holidays). The system derives the calendar days from the work calendar of the division.

• Date To Consider - Used to indicate whether you want to calculate the bill due date using the bill creation date or bill completion date. The valid values are:

  • BILL_​CRE_​DT - Used when you want to calculate the bill due date using the bill creation date.

  • BILL_​COMP_​DT - Used when you want to calculate the bill due date using the bill completion date.