Time-Based Consolidated Billing Terms

Define time-based consolidated billing terms to generate and deliver consolidated invoices on a predefined schedule agreed upon with your customers.

To define time-based consolidated billing terms, complete these tasks:

  • Define a billing cycle with details of the billing frequency.
  • Define a time-based consolidated billing terms record.
  • Select the sources of transactions to include in consolidated invoices.
  • Identify transactions from the selected sources to exclude from consolidated invoices.

Define a Billing Cycle

To define a billing cycle for time-based consolidated billing terms:

  1. Open the Consolidated Billing Terms workbook.
  2. Select the Billing Cycles tab.
  3. Under Oracle Visual Builder, select Table Row Changes > Insert Rows to add a new row.
  4. In the Billing Cycle Name and Description fields, enter a name and description that identify this billing cycle.
  5. In the Start Date field, select from the date picker the date this billing cycle becomes active.
  6. In the Cycle Frequency field, enter the billing frequency: Daily, Weekly, Monthly.
  7. In the Repeat After field, enter the number of days, weeks, or months after which consolidated billing repeats. For example:
    • Daily: If you enter 2, then invoices are consolidated every other day.
    • Weekly: If you enter 1, then invoices are consolidated once a week on the day defined in the Weekly cycle.
    • Monthly: If you enter 3, then invoices are consolidated every three months on the day of the month defined in the Monthly cycle.
  8. In the Skip Saturdays and Sundays field, select Yes or No to include or exclude weekends. The default is Yes.
  9. If the Cycle Frequency is Weekly, in the Day of Week field, enter one or more days on which to consolidate invoices. Separate multiple values with commas, for example, Monday, Tuesday.
  10. If the Cycle Frequency is Monthly, either:
    • In the Day of Month field, enter one or more days of the month (1 to 31) on which to consolidate invoices. Separate multiple values with commas, for example, 1,15,28; or,
    • In the Last Day of Month field select Yes to consolidate invoices on the last day of each calendar month.
  11. Under Oracle Visual Builder, select Upload Changes to save the billing cycle record.

Define Time-Based Consolidated Billing Terms

To define time-based consolidated billing terms:

  1. Select the Consolidated Billing Terms tab.
  2. Select Table Row Changes > Insert Rows to add a new row.
  3. In the Billing Terms Name and Description fields, enter a name and description that identify this billing terms record.
  4. In the Enabled field, select Yes.
  5. In the Consolidation Method field, select Time-based.
  6. In the Billing Cycle Name field, enter the billing cycle you created in the previous setup.
  7. Select Upload Changes to save the consolidated billing terms record.
  8. Select the Billing Inclusions tab.

    Use this tab to indicate which source transaction lines are to be included in invoices created from these billing terms. The available transaction sources are Order Management and Subscription Management.

  9. Select Table Row Changes > Insert Rows to add a new row.
  10. In the Billing Terms Name field, select the consolidated billing terms that you created in steps 1-7.
  11. In the Transaction Batch Source field, select one of the transaction sources of the source transactions to include in consolidated invoices:
    • Distributed Order Orchestration
    • ORA_Subscriptions
  12. If you want to include another transaction source, repeat steps 9-11 for the same billing terms record.
  13. Select Upload Changes to save the billing inclusions record.
  14. Select the Billing Exclusions tab.

    Use this tab to exclude specific sets of transactions from the transaction sources selected in the Billing Inclusions tab.

  15. Select Table Row Changes > Insert Rows to add a new row.
  16. In the Billing Terms Name field, select the consolidated billing terms.
  17. In the Exclusion Type Code field, select the type of transactions to exclude from consolidation. You can exclude transactions by:
    • Payment Terms
    • Receipt Method
    • Business Unit
    • Legal Entity
    • Unrelated Services
  18. Complete the related field to identify the details of the exclusion:
    • Payment Terms: Transactions assigned the payment terms you enter.
    • Receipt Method: Transactions assigned the receipt method you enter.
    • Business Unit: Transactions belonging to the business unit you enter.
    • Legal Entity: Transactions belonging to the legal entity you enter.
    • Unrelated Services: Enter Yes (the default) to exclude charge lines with services that are not related to the consolidation process.
  19. Select Upload Changes to save the billing exclusions record.
  20. Assign your time-based consolidated billing terms record to the applicable customer account.