Billing

Billing Overview

Billing is the process of claiming amounts due from customers on their lease and loan contracts. Billing charges for rent, fees, and services are processed to include taxes and generate accurate accounting transactions. Documents called invoices or statements of account are created as a notice to the customer for payment.

Compliance with regulatory tax and accounting requirements and efficient collection of payment is essential in this process. Clear presentment of billing charges on invoices is necessary to meet internal billing policy and procedures while making the payable process easy for customers to make prompt and correct payments.

The Oracle Lease and Finance Management billing process consists of the following topics:

Billing Transactions

To begin the billing process, you first determine amounts to be billed, then you process options to format and present invoices in Oracle Lease and Finance Management, then Create Invoices, and finally you View and Adjust Invoices. An active contract in the status described below defines the payment schedule and streams for rent, fees and services to be billed.

Although the processing of billing data from different billing sources varies, every billing transaction of each billing type results in a record in Oracle Lease and Finance Management. The main billing data consists of the following data items:

The following table describes types of billing that financiers may need to bill their customers for and the Oracle Lease and Finance Management concurrent programs used to process the billing.

Types of Billing
Type of Billing Description Concurrent Programs
Contractual Amounts Billing charges for use of equipment, fees, or services specified on the contract. Contractual amounts are charges defined in the contract to be paid on specific dates in a payment schedule. Master Program - Process Billable Streams - Contract
Event Based Billing charges or credit calculated as events occur based upon contract terms and conditions. Event based charges that may be specified in the contract include, but are not limited to, adjustments when the contract is revised or rebooked, quote fees for a repurchase quote, and contract obligations when a contract is terminated early. Master Program - Process Billable Streams - Contract
Variable Rate Lease or loan contracts are linked to an index that defines the interest rate used to calculate the charge for interest payment. Create Receivables Variable Rate Invoices
Usage Billing Billing charges for use of equipment based on counters or meters, for example, the number of clicks or sheets used by a copier, the number of miles driven by a vehicle, or the number of hours of use by a machine. Usage Based Billing
Service Contract Lease or loan contracts are linked to service contracts that process maintenance charges to be billed and combine these service amounts with the contractual amounts on a single invoice. Service Contracts Billing
Service Contract Lease or loan contracts are linked to service contracts that process maintenance charges to be billed and combines these service amounts with the contractual amounts on a single invoice. Usage Based Billing
Usage Based Billing charges for use of equipment based on counters or meters, for example, the number of clicks or sheets used by a copier, the number of miles driven by a vehicle, the number of hours of use by a machine. Service Contracts Billing
Policy Based Billing charges calculated as events occur based upon policies specified in contract terms. Policies that may be specified in the contract include, but are not limited to, late charges or late interest when payments are late, interest charges when funding is disbursed prior to contract booking, and evergreen billing after the contract expires. Calculate Late Interest & Calculate Late Charges
Manual Ad hoc charges based on new events or circumstances that are not billed automatically based on contract payment schedule or terms and conditions. None
When you create a Manual Invoice, the Master Program – Receivables Invoice Transfer program sends billing information to Oracle Receivables
Advance Billing Advance billings are for payments received before the contract is booked. Running the Advanced Billing concurrent program creates an invoice to which the payment can be applied. Advance Billing
Future Pay Future Pay can be used to reserve receipt amounts of future invoices for a contract, or a contract and stream type. Running the Future Pay Sweep program applies allocated amounts to invoices of a contract. Future Pay Sweep
Evergreen When an evergreen contract expires, contractual billing discontinues and evergreen charges are billed in Evergreen Billing Evergreen Billing
Investor Agreement When an investor agreement is activated, you can bill the investor for their stake and fees defined in the agreement. Master Program – Process Billable Streams – Investor Agreement
Taxes Billing charges for property tax and upfront tax and generation of VAT schedules. Upfront taxes are charges over the expected life of the contract that are payable to tax authorities when the contract is booked. None
Oracle E-Business Tax calculates tax based on billing information exported from Oracle Lease and Finance Management to Oracle Receivables.
Third Party Billing charges imported from third-party files containing charges that you want to bill the customer and pass through to the third-party. For example, you may want to import and bill for a county's property tax liability, a bank's non-sufficient funds charge, or a vendor's maintenance fee and pass the receipts back to the third-party. Third Party Billing

Bill Contractual Amounts

Billing for contractual amounts consists of billing charges for use of equipment, fees, or services specified on the contract. Contractual amounts are charges defined in the contract to be paid on specific dates in a payment schedule.

The contractual amount billing process begins by first determining the amounts to be billed, then processing the options to format and present invoices in Oracle Lease and Finance Management. After invoices are formatted and presented, you can create invoices and view and adjust the invoices.

Oracle Lease and Finance Management identifies customers for automatic billing based on the stream types to be billed, the due date for a payment, and the number of print lead days. Print lead days are the number of days before the invoice due dates that you can generate an invoice.

Bill Contractual Amounts Prerequisites

Before you can begin the bill contractual amounts process, you must have an active contract with terms and conditions that define amounts and formulas to calculate billing charges when events occur and a payment schedule with billable streams.

For more information on creating terms and conditions on a contract, see Contract Authoring

Bill Contractual Amounts Procedures

The following table describes the billing process for contractual amounts using periodic billing. A request set has been seeded called Lease Billing. The Lease Billing request set is comprised of the three concurrent programs listed below.

Billing Contractual Amounts Process
Step Description Application
Book Contracts Book contracts with terms and conditions with billing information, and payment schedules for rent, services and fees. Oracle Lease and Finance Management
Run Master Program - Process Billable Streams - Contracts This program is used to process the stream elements to create the billing transactions in Oracle Lease and Finance Management. Oracle Lease and Finance Management
Run Master Program - Receivables Invoice Transfer This program is used to process and transfer Oracle Lease and Finance Management billing transactions to the AR Invoice Interface table Oracle Lease and Finance Management
Run AutoInvoice Master Program This program imports the billing information into Oracle Receivables and creates an invoice with invoice lines. Oracle Receivables

To enable contractual billing, you must run the Master Program - Process Billable Streams - Contracts concurrent program. After this concurrent program is active, the process of selecting which contracts and items to prepare for billing is completely automatic. Oracle Lease and Finance Management identifies customers for automatic billing based on the stream types to be billed, the due date for a payment, and the number of lead days. Lead days are the number of days before the invoice due date that you can generate an invoice.

Similarly, if you require usage-based billing, all the necessary background processing automatically runs and generates the excess usage billing data. For usage-based billing items where you want to level-out counter readings across individual counters, you must set up one or more consolidated counter groups.

Run Master Program - Process Billable Streams – Contracts

The Master Program - Process Billable Streams - Contracts concurrent program identifies contracts with streams due for billing and creates billing items. See Concurrent Programs, page B-1.

Event Based Billing

An active contract with defined terms and conditions determines the amounts and formulas used to calculate billing charges when events occur.

Event based billing occurs when billing is charged or credit is calculated as events occur based upon contract terms and conditions. Event based charges that may be specified in the contract include, but are not limited to, adjustments when the contract is revised equipment is repurchased by the vendor, and contract obligation amounts billed when a contract is terminated early.

Event Based Billing Prerequisites

An active contract with defined terms and conditions determines the amounts and formulas used to calculate billing charges when events occur.

Event Based Billing Procedures

To enable event based billing, run the Master Program - Process Billable Streams – Contracts concurrent program. After this concurrent program is active, Oracle Lease and Finance Management selects contracts and items to prepare for billing automatically based on the event. Oracle Lease and Finance Management identifies customers for automatic billing based on the stream types to be billed, the due date for a payment, and the number of lead days. Lead days are the number of days before the invoice due date that you can generate an invoice.

Similarly, if you require usage-based billing, Oracle Lease and Finance Management automatically processes and generates the excess usage billing data. When you create usage-based billing items and want to level counter readings across individual counters, you must set up one or more consolidated counter groups.

Run Master Program - Process Billable Streams – Contracts

The Master Program - Process Billable Streams - Contracts concurrent program identifies contracts with streams due for billing and creates billing items. See Concurrent Programs, page B-1.

Variable Rate Billing

One of the parameters of a contract is the interest type upon which you base the contract. Examples of contract interest rate types include fixed rate interest and variable rate interest. In the case of variable rate contracts, there are several additional parameters you enter when you book or restructure a contract. The most important of these parameters identifies how you calculate the interest as a result of the change in rate.

The four methods for handling the interest adjustment are:

When you perform billing for variable rate contracts, Oracle Lease and Finance Management automatically evaluates the interest rate basis linked to the contract for any increases or decreases in the effective interest rate. If the applicable rate changes, the billing process automatically calculates and bills the appropriate amounts. The interest calculation basis defined on the financial product associated to the contract computes the revised interest or loan payment amounts.

Variable Rate Billing Prerequisites

Before you can execute the variable rate billing process, the following prerequisites apply:

Variable Rate Billing Procedures

To process billing for variable rate interest contracts, run the following concurrent programs:

  1. Create Receivables Variable Rate Invoices

  2. Master Program - Process Billable Streams – Contracts

  3. Master Program - Receivables Invoice Transfer

  4. AutoInvoice Master Program

For more information on variable rate in Oracle Lease and Finance Management, see Variable Rate.

The following table describes the Variable Rate billing process.

Variable Rate Billing Process
Step Description Application
Create Receivables Variable Rate Invoices The interest or loan payment amounts are computed and the stream elements are created or revised in Oracle Lease and Finance Management. Oracle Lease and Finance Management
Run Master Program - Process Billable Streams - Contracts This program is used to process the stream elements to create the billing transactions in Oracle Lease and Finance Management. Oracle Lease and Finance Management
Run Master Program - Receivables Invoice Transfer This program is used to process and transfer Oracle Lease and Finance Management billing transactions to the Oracle Receivables Invoice Interface table. Oracle Lease and Finance Management
Run AutoInvoice Master Program This program imports the billing information into Oracle Receivables and creates an invoice with invoice lines. Oracle Receivables

Run Create Receivables Variable Rate Invoices

The Run Create Receivables Variable Rate Invoices concurrent program performs the following tasks:

Run the Create Receivables Variable Rate Invoices concurrent program after entering the following parameters:

For more information on this and other concurrent programs, see Concurrent Programs, page B-1.

Usage Based Billing

Equipment lessors often include metered equipment in their asset portfolio. Metered equipment, such as copiers, can be charged on a usage basis during the lease term. Usage Based Billing (UBB) enables equipment lessors to calculate the amounts to bill based on usage of the equipment.

Billing charges for use of equipment is based on counters or meters. Examples of UBB include the number of clicks or sheets used by a copier, the number of miles driven by a vehicle, or the number of hours of use by a machine.

When you author and book a lease contract with a usage service line, Oracle Lease and Finance Management automatically creates a contract in Oracle Service Contracts and links it to the Oracle Lease and Finance Management contract. When you enter meter readings to record usage, Oracle Service Contracts calculates the usage based billing amounts. Then, when you run the Oracle Lease and Finance Management billing processes, Oracle Receivables generates a consolidated usage service invoice.

Usage Based Billing Setup

Before you can use Usage Based Billing in Oracle Lease and Finance Management, you must complete all required set up tasks. For information on set up for UBB, see Oracle Lease and Finance Management Implementation Guide.

Usage Based Billing Procedures

The following table describes the UBB billing process.

Event Description
Author a Contract Author a contract with UBB as the billing method and create a usage line.
Service Contract Once a Oracle Lease and Finance Management contract is booked, a service contract is automatically created in Oracle Service Contracts Manager.
Enter Meter Reading In Oracle Service Contracts Manager, enter the meter reading.
Generate OKS Billing To generate billing in Oracle Service Contracts Manager, run the OKS: Service Contracts Main Billing concurrent program, which calculates billing and creates transactions in Oracle Service Contracts Manager.
Transfer OKL Billing To transfer the billing data to Oracle Lease and Finance Management, run the OKL: Usage Based Billing concurrent program, which transfers your Oracle Service Contracts Manager data to Oracle Lease and Finance Management and creates transactions.
Generate OKL Billing To generate billing in Oracle Lease and Finance Management, run the following concurrent programs: Master Program - Process Billable Streams – Contracts; Master Program - Receivables Invoice Transfer; Autoinvoice Master Program.
View Invoices To view the new invoices, navigate to Operations > Invoices and enter the contract data.
Termination To terminate the contract you must terminate both the Oracle Lease and Finance Management version and the Service Contracts Manager version.
Inquiry You can view the Meter Reading History and Billing History for a UBB contract in the Lease Center, Customer Self Service, and Vendor Self Service.

Meter Usage Service

Meter Usage Service consists of billing and collection of the fees for a service based upon usage of output (copies, hours, and so on) or number of units of delivered service (number of hours, number of events). The amount billed, while based on usage, is not for usage, but for the service being provided. The usage is tracked as a basis for calculating the billing amount. The usage is counted, sometimes using a meter, to determine the usage quantity. The values of the pricing sheet are applied to the usage quantity to determine the usage fees to be billed and collected. The pricing sheet may include both an allowance (a minimum usage included in a base price) and an arrange rate (the amount charged per UOM of usage quantity) for any usage quantity amount used in the usage period over and above the allowance provided.

Metered usage service can be combined with metered usage rentals into a bundled usage-based solution wherein all rental and service is billed as a single charge per unit of usage quantity (can include an allowance) and the components of service and rental are separated later and disbursed to the solution providers. The amounts collected for a metered usage service may be retained by the lessor or passed through to the service vendor, depending upon which partner delivers the service to the end user.

Consolidated Group

A consolidated group is required when the metered usage line is priced to apply rates to the usage quantities for multiple serviced asset meters. You can define a consolidated group separately from a contract. The consolidated group should be setup to a specific customer. For the group, all of the pricing structure (price list values), billing information and a usage schedule should be captured. The pricing and billing information from the consolidated group takes precedence over anything defined on the contract for the usage line.

Once the consolidated group is created, it can be selected, in place of a pricing structure template when creating a usage line. Each serviced usage asset that contributes to the group must be associated with the consolidated group pricing setup. You cannot override pricing information defined in the consolidated group. Each serviced usage asset must have all of the other counter information assigned. Only the pricing structure with the defined pricing tiers and the usage service schedule is derived from the consolidated group.

Manage Consolidated Counters During Rebook

You can manage consolidated counters during rebook by performing the following actions:

Before any of the counters are moved, you must terminate assets associated to the usage line during rebook by providing an end date for the Termination Date (one day more than the end of usage period). There must be no gaps between the termination date and end of usage billing period. If there are gaps or overlapping dates, an error is displayed. You must correct the termination date before completing the rebook process. For information on terminating assets, see "Terminate Assets Associated to Existing Usage Lines During Rebook" in this chapter.

You can navigate to an existing usage line and associate the asset that was terminated to either a group or single counter. Meter reads entered for that counter are associated to the new group or single counter. When the next billing is run, the counter that was moved is associated to the new group or single counter.

Service Only Metered Usage Contract Lines

Service only contract lines are those where the assets associated to the metered usage service line are owned by the customer. The assets may have been bought out during a termination in Oracle Lease, or entered as lessee owned asset that the vendor is servicing and pricing based on metered usage. These assets are not financed. Enter them in the Configuration tab during authoring.

Manage Usage Lines During Rebook

For metered usage services, you can change the usage passthrough details and add an asset to an existing usage line when a rebook is activated.

Create Usage Lines During Rebook

You can create usage lines during rebook. You can also associate assets to the new usage line. For information on creating usage lines and associating assets to the new usage lines, see Set Up Usage Lines.

You can perform the following tasks on the new usage lines:

The new usage line and its associated information are added when the rebook is activated.

Update Existing Usage Lines During Rebook

You can update an existing usage line during rebook by clicking the Update button for that existing usage line. On the Update Usage page, you can update the following usage line attributes:

Once the billing has been processed for the usage line, you cannot change the period and number of periods.

Note: Usage effective from and effective to dates are read-only fields on the usage line. The effective from date will be based on the start date of the usage line or the revision date when the contract is rebooked. The effective to date will be derived based on the usage line periods (or frequency) and the number of periods.

Terminate Assets Associated to Existing Usage Lines During Rebook

You can terminate an asset associated to a usage line during rebook by providing an end date for the Termination Date. Perform the following steps in the Usage region of the Additional Charges subtab:

  1. Enter the usage search criteria and click Go.

  2. Click the Usage Asset icon for an existing usage line.

  3. Enter an end date for the Termination Date of an associated asset of that usage line.

  4. Click Apply.

Once the rebook process is completed, the status of the associated asset is Terminated. The termination date for the usage line that has been terminated during rebook is displayed.

Note: You can enter meter readings and run the billing for the last few usage periods even after the counter line has been terminated.

Meter (Counter) Readings

Meter readings are captured for metered usage services in order to bill and collect from end user customers. They are collected from a variety of sources with varying levels of automation and capabilities. Meter readings are captured using the following methods:

The capture of a meter reading includes:

You can capture meter reads as follows:

  1. Identify the counter or meter for which the meter reading applies. This can be done manually by searching for a meter and entering the values or providing the identifying information for any meter reading record in a spreadsheet (for upload) or through electronic transmission.

  2. Select the period of usage. This can be more than one if a previous reading was missed, for which the reading applies is selected or specified with the meter reading record if not entered manually.

  3. Enter the reading values and verify them. You may need to view meter history, validation warnings or errors, or calculated values, such as usage quantities and billing amounts and dates if needed, to verify the reading.

  4. Save or submit the reading record. The period of usage is marked appropriately to indicate the reading for the period has been captured. The calculated billing amount becomes eligible for billing on the due date.

Meter Search

You can search for meters for viewing meter reading history or entering a meter reading. From the Search Results list, you can create and enter a new meter read record, open and view the prior meter reading history.

Entering Meter Reads Manually

You can enter a meter read manually from the Search Results table or the View Meter History page. If the meter read is incorrect or invalid, you can make the correction based on the error or warning and re-validate or save and submit.

Importing or Uploading Meter Readings

You can import or upload multiple meter readings from a single file. To prepare the upload or import meter readings, you can download a spreadsheet format to enter the meter read data. The meter read must have a corresponding period of usage. You can upload from the following locations:

Validating Meter Readings

For validation, in addition to the seeded validations that insure consistent and valid data, you can setup defined error or warning conditions and set the warning and error levels. During manual entry, you can request for validations or submit to run the validations. For the upload or service based entry, you can receive errors and warnings report (internal or external user entry) upon request. In addition, you can setup and define the following validations:

The defined validations are executed for each meter reading entered. If you upload a reading batch, the validations are available as a log file than can be saved and stored locally.

Note: A record can be submitted and recorded with warnings, but not errors.

Missing Meter Readings

A missing meter read is defined as any period of usage with no meter reading on its billing due date. For missing meter reads, an estimate or minimum reading is used to generate the billing and is then adjusted when the actual meter reading is available. Otherwise, the period is not billed and when the next meter read is entered, all previous missing periods are billed together with the reported read period.

To enter a meter read for a missing period, select the period of usage for the missing meter read. If the period is not eligible to be adjusted, it is recorded as read only and the appropriate indicator is made on the period of usage. If the actual reading triggers an adjustment, the period is marked for adjustment, and is processed on the next billing due date (or during a termination if it occurs first).

Using an Estimated or Default Usage Quantity for Missed Readings

Use the Estimation Method to assign a usage quantity for any period with a missing meter reading on the period's billing date. Capture the usage quantity based on the Estimation Method defined in the terms:

If the Estimation Method is set as none, estimated usage quantity is not used for billing. Any allowance defined for appropriate pricing structure for the period is accrued to the allowance of the next period. Once a valid actual meter reading is applied to the correct usage period, the period billing amount is recalculated and the billing adjustment is processed. That period of usage is then marked as complete.

Bill for Metered Usage Service Lines in Evergreen

Billing for a metered usage service depends on an accurate meter reading and a unit-rate based pricing structure to calculate the correct usage charges. The service contract may also have a flat periodic amount in the billing schedule in addition to any rate based usage charges. The rate based usage must be calculated for the specified period of usage based upon a meter reading at, or close to, the end of the period that determines the usage quantity. Billing must continue for metered usage service lines in the IPR/evergreen term unless the contract line is ineligible for IPR. You can define on the contract line if it is eligible for IPR/evergreen separately from the usage asset or the contract. In such cases, billing must continue for metered usage service lines in the IPR/evergreen term unless the contract is ineligible for IPR.

When the financing contract enters into evergreen status, and the metered usage service line is eligible, the Service Contract is also renewed using the same number of months defined for the base term as the term of the renewed contract. The contract start date defaults to +1 day after the original contract end date. The periods of usage will continue on +1 day after the end of the contract base term and use the same frequency as base term. The last meter read must be entered for the last period of usage of the base term in order for the contract to go into IPR.

Meter reads must be captured for period of usage in the IPR term in order to generate billing charges. Any rate changes specified in the price structure dated on the end date of the contract line or any dates that occur during the IPR period are used to calculate the billing amount when the contract line enters the IPR period. Otherwise, the same rate used in the final period of the base term is used.

Each period of usage that occurs in the IPR term is maintained in the same manner as the base term without terminating the metered usage service line.

Service Contract Billing

Many financiers have multiple business units that provide service as well as financial services and want to use the full functionality of Oracle Service Contracts while consolidating their billing for service and lease. You can author a service contract and link to the lease contract in Oracle Lease and Finance Management and consolidate the service and lease charges on one invoice. After running billing in Oracle Service Contracts and Oracle Lease and Finance Management, Oracle Receivables generates a consolidated invoice on the two contracts.

Service Contract Billing Prerequisites

You must have created a service contract in Oracle Service Contracts, created a lease contract and linked the two in Oracle Lease and Finance Management. You must run the Oracle Service Contracts main billing program after meeting the following prerequisites:

Service Contract Billing Procedures

When you author a lease contract and want to consolidate billing from a service contract on the same invoice, create a service contract in Oracle Service Contracts that meets the prerequisites. Then, when you author the lease contract, go to Additional Charges and select the pull-down menu Create Service from Service Contract.

In the Contracts screen you can select Service Contract as the payment type and supplier. Click Apply to link the lease contract to the service contract. When you run the billing for the service in Oracle Service Contracts, the billing charges will not be sent to the Oracle Receivables interface table.

When you run the Service Contracts Billing in Oracle Lease and Finance Management, the service contract billing information is associated with the lease contract. Then, when you run Master Program – Receivables Invoice Transfer in Oracle Lease and Finance Management, the service contract and lease contract billing information are sent together to the Oracle Receivables interface. The consolidated lease and service invoice is generated when you run the Oracle Receivables Master Import Program.

Policy Based Billing

Financiers want the flexibility to initiate billing charges to control policies that discourage late interest and principal payments.

Policy Based Billing Prerequisites

Before you can execute policy based billing processes, you must book contracts with terms and conditions that define the billing parameters.

Policy Based Billing Procedures

Late Interest Billing

Late payments may be subject to a late interest charge. The Late Interest policy determines the late interest charges.

For more information, see the Define Late Charges Parameters, Oracle Lease and Finance Management Implementation Guide.

Run Calculate Late Interest

This concurrent program identifies late payments, calculates interest, and generates bills for Oracle Receivables. See Concurrent Programs, B-1.

Late Charges Billing

If a previous invoice still has a balance outstanding, late charges may apply. The Late Charges policy determines the late charges amount. The late charges amount is either a flat fee or a percentage of the total invoices past due, depending upon the setup configuration.

To begin the calculation of the late charges, you must start the Calculate Late Charges concurrent program. This program evaluates all outstanding invoices to identify the invoices past their grace period and where the late charges are not placed on hold for the contract. After the program identifies a delinquent invoice as eligible for late charges, the penalty automatically applies, based on the rules in the late policy.

For more information, see the Define Late Charges Parameters, Oracle Lease and Finance Management Implementation Guide.

Run Calculate Late Charges

This concurrent program identifies past due invoices, calculates late charges, and generates bills for Oracle Receivables. See Concurrent Programs, B-1.

You must have created a late charges policy.

Manual Billing

Financiers may want to charge for services or commodities that are not processed automatically. For example, suppose you receive a registration fee related to a contract. As you pay the appropriate vendor for this expense, you may also want to charge the lessee in order to recover your money.

Manual Billing Procedures

The following table describes the Manual Billing process required to create a manual invoice and recover your expense:

Step Description Application
Create Manual Invoice Header & Lines Create a manual invoice with the required billing information. Oracle Lease and Finance Management
Master Program - Receivables Invoice Transfer This program is used to process and transfer Oracle Lease and Finance Management billing transactions to the Oracle Receivables Invoice Interface table. Oracle Lease and Finance Management
AutoInvoice Master Program This program imports the billing information into Oracle Receivables and creates an invoice with invoice lines. Oracle Receivables

Create Manual Invoice Header

To create a manual invoice header, perform the following steps in the Manual Invoices subtab of the Operations tab:

  1. Navigate to Operations > Manual Invoices

  2. Click Create Manual Invoice.

  3. Select the Operating Unit.

  4. Select the Contract Number for which you are billing ad hoc charges.

  5. Enter the Transaction Number.

  6. Enter the Invoice Date.

  7. Enter the Invoice Amount.

Create Manual Invoice Lines

In the Manual Invoice Lines region, enter assets (optional), fee type details, and the amount for each manual invoice line. You can enter multiple invoice lines for a manual invoice.

  1. Select the Fee Type.

  2. Select the Asset Number.

  3. Optionally, enter a Description for the fee.

  4. Enter the Amount for the asset on the invoice line.

  5. If you want to create more manual invoice lines, click Add Another Row, and repeat the previous steps; repeat this for each required manual invoice line.

  6. After you have entered all the manual invoice lines, click Recalculate. After you click the Recalculate button, the Line Amount is displayed in the Grand Total region. The Line Amount displays a total of all the invoice line amounts and must equal to the invoice amount entered on the Manual Invoice header.

  7. Click Apply. After you click Apply, the Manual Invoice is created with the Transaction Number as the Manual Invoice Number.

Searching for Manual Invoices

You can find manual invoices by performing a list search in the Manual Invoices tab of the Operations page. List search is a search tool that helps retrieve information quickly and easily.

Perform the following steps:

  1. Click Show Filters.

    Note: You can hide filters by clicking Hide Filters.

  2. Select the objects using the following filters:

    • Operating Unit (mandatory field)

    • Transaction Number

    • Contract Number

    • Customer Name

    • Bill To Site

    • Invoice Date: This field uses a range of date.

    • Currency

    • Status: You can select multiple options for this filter.

    You can also include additional filters by clicking Add and selecting a filter.

    Note: You can remove the additional filters from the search criteria by clicking the remove filter icon next to each added criteria.

  3. Click Go.

The search results are displayed.

You can save searches by performing the following steps:

  1. After selecting filters, click Save.

  2. Perform the following actions in the Create Saved Search region:

    • Perform the following actions in the Create Saved Search region:

    • Select the Display in Tile checkbox to display a tile having this search's details in the Manual Invoices tab.

      Additional Information: Tiles display the count of search records for the defined search filters. This count can be refreshed by clicking the refresh icon present on each tile. Clicking on a tile will show the filters selected for this saved search.

    • Select the Set as Default checkbox to make a saved search as the default search.

    • Click OK.

Even if a saved search is not saved as a tile, it will be displayed in the drop down beside Show Filters/Hide Filters. You can manage saved searches by clicking Manage Saved Search in this drop down.

Note: You can disable list search using the Disable List Search button in Table Diagnostics. After disabling list search, you can find manual invoices by performing either a simple or advanced search.

A simple search on the Manual Invoices tab includes the following parameters:

An advanced search allows you to expand or refine their search criteria.

Advance Billing

Financiers often require deposits or payments from customers to cover fees and services before a contract is activated. You can improve customer service by creating advance receipts against contracts before activation or during the contract life. You create a manual receipt, select the Application Criteria, Advance, select the contract and run the Advance Billing concurrent program. When you run the billing programs, Oracle Lease and Finance Management automatically creates an invoice and applies the receipt.

Advance Billing Prerequisites

Receive payment before a contract is activated.

Advance Billing Procedures

The following table describes the advance billing process.

Advance Billing Process
Step Description Application
Create Manual Receipt Header & Application Criteria Create a manual receipt and select the Application Criteria, Advance. Oracle Lease and Finance Management
Advance Billing Run the Advance Billing concurrent program to apply payments received before the contract is booked and create an invoice to which the payment can be applied. Oracle Lease and Finance Management
Master Program - Receivables Invoice Transfer This program is used to process and transfer Oracle Lease and Finance Management billing transactions to the Oracle Receivables Invoice Interface table. Oracle Lease and Finance Management
AutoInvoice Master Program This program imports the billing information into Oracle Receivables and creates an invoice with invoice lines. Oracle Receivables

When payments are received before a contract is activated, create a manual receipt in Receipts under the Operations tab. In the Application Criteria, select Advance from the pull-down menu in the Criteria field. Oracle Lease and Finance Management will display a field to enter the Contract Number. The contract can be active.

Run the Advance Billing and Master Program - Receivables Invoice Transfer concurrent programs to transfer the advance billing information to Oracle Receivables that creates an invoice and applies the receipt.

Future Pay

You may be required to reserve receipt amounts of future invoices for a contract, or a contract and stream type. You can create future payment of receipts against contracts. You can reserve receipt amounts fully or partially.

Create Future Payments

The following table describes the process for creating future payments.

Future Pay Process
Step Description Application
Create manual receipt and select application criteria Create a manual receipt in Receipts under the Operations tab. In the Application Criteria region of the Create Manual Receipt page, select Future Pay from the drop-down menu in the Criteria field.

Note: You can also update an existing manual receipt to future pay by clicking Update on the Manual Receipt page and selecting the Future Pay checkbox.

Oracle Lease and Finance Management
Run Future Pay Sweep program Run the Future Pay Sweep concurrent program to apply allocated amounts to invoices of a contract. This program applies the allocation amount based on whether the amount is for a contract, or a contract and stream type. The application of the allocation amount is based on the following criteria:
  • If it is only for a contract, it applies allocation amount to any open invoice for the contract based on the cash application rule associated with the contract.

  • If it is for a contract and stream type, it applies allocation amount to any open invoices for the contract and stream type based on cash application rule associated with the contract.


After this program is run, receipt allocation balances are updated to deduct applied amounts from allocation balances. Amounts allocated in a receipt are automatically placed on-account.

Note: When this program is run, the system will check whether the receipt on account balance is less than the total allocated amount. If it is, the receipt number will be reported in the output report.

Oracle Lease and Finance Management
Run Future Pay Reverse Allocation program Run the Future Pay Reverse Allocation program to check whether any receipt with an allocation balance has been reversed in Oracle Receivables. If a receipt has been reversed, this program automatically cancels any allocations recorded for the receipt. Oracle Receivables

Evergreen Billing

Financiers require the flexibility to continue billing contracts when the assets continue to be in service after the contract expires. The period after a contract expires without termination and the assets continue to be in service is the evergreen period. Since the contract has expired, contractual billing is discontinued. To continue billing, run Evergreen Billing.

The following table describes the Evergreen billing process.

Evergreen Billing Process
Step Description Application
Evergreen Billing Run the Evergreen Billing concurrent process to apply payments received before the contract is booked and create an invoice to which the payment can be applied. Oracle Lease and Finance Management
Master Program - Receivables Invoice Transfer This program is used to process and transfer Oracle Lease and Finance Management billing transactions to the Oracle Receivables Invoice Interface table. Oracle Lease and Finance Management
AutoInvoice Master Program This program imports the billing information into Oracle Receivables and creates an invoice with invoice lines. Oracle Receivables

Evergreen Billing Prerequisites

To process billing information, you must have contracts in Expired status that have not been terminated.

Evergreen Billing Procedures

On a periodic basis, run the Evergreen Billing and Master Program - Receivables Invoice Transfer concurrent programs to transfer the evergreen billing information to Oracle Receivables that creates an invoice.

Investor Agreement Billing

When financiers negotiate investor agreements, they define the amount of investment or investor stake. The financier may also want to bill the investor for fees incurred in creating the investor agreement. The investor stake amount and fees are defined in the investor agreement. To bill the investor, run the Investor Agreement concurrent program.

Investor Agreement Billing Prerequisites

To process billing information, you must have an active investor agreement with a defined stake amount.

Investor Agreement Billing Procedures

The following table describes the Investor Agreement Billing process.

Investor Agreement Billing Process
Step Description Application
Activate Investor Agreement Author Investor Agreement with stake amount and any fees. Oracle Lease and Finance Management
Master Program – Process Billable Streams – Investor Agreement When an investor agreement is activated, bill the investor for their stake and fees defined in the agreement. Oracle Lease and Finance Management
Master Program - Receivables Invoice Transfer This program is used to process and transfer Oracle Lease and Finance Management billing transactions to the Oracle Receivables Invoice Interface table. Oracle Lease and Finance Management
AutoInvoice Master Program This program imports the billing information into Oracle Receivables and creates an invoice with invoice lines. Oracle Receivables

Create an Investor Agreement and add investors to the agreement with their stake amount. Add any fees to be charged to the investor. Activate the investor agreement. For more information on investor agreements in Oracle Lease and Finance Management, see Investor Agreements.

Run the Master Program – Process Billable Streams – Investor Agreement and Master Program - Receivables Invoice Transfer concurrent programs to transfer the evergreen billing information to Oracle Receivables that creates an invoice with invoice lines for the investor stake and fees to be billed to the investor.

Billing and Taxes

Financiers are required to calculate, collect, and remit transaction-based taxes and meet leasing specific tax requirements within multiple applicable jurisdictions. Oracle Lease and Finance Management and Oracle E-Business Tax are integrated to calculate taxes using lease-specific and common tax parameters.

This integration creates a common infrastructure for tax configuration for multiple legal entities, operating units, and tax jurisdictions and increases the flexibility of your infrastructure to define comprehensive sets of tax rules for tax determination requirements. You can reduce duplication of effort and errors using a common repository to maintain tax related records, and reduce clerical effort generating tax reports for reporting to tax authorities.

For information on processing taxes in Oracle Lease and Finance Management, see Taxes.

Third Party Billing

You can import billing items from a third-party finance company into Oracle Lease and Finance Management. You can import billing files containing charges incurred by the customer that you want to pass through, for example, property taxes, charges for non-sufficient funds, service, and maintenance. After you import billing files, you review them, correct errors, and download them into Oracle Lease and Finance Management tables.

Third Party Billing Prerequisites

To process billing information, you must have an active investor agreement with a defined stake amount.

Third Party Billing Procedures

You must include third-party billing data in a billing import file. You may include the following basic data fields in your data file:

In addition, you can provide other fields, such as vendor, invoice, and source identifiers

Prepare Third-Party Billing Import File for Billing

To prepare a third-party billing import file, perform the following steps:

  1. In all rows, set the value of the column TRX_STATUS_CODE to "SUBMITTED".

  2. Create a SQL*Loader control file specific for the data file to be imported. This step should be done by a technical consultant with knowledge of SQL*Loader programming language. The control file describes the format of the data file to be imported. SQL*Loader does not validate data.

  3. Run SQL*Loader to load the data file. Running SQL *Loader is a concurrent job that takes two arguments: name of data file and name of control file. This job produces an audit report.

  4. Review the SQL*Loader audit reports. The report indicates the number of records which have been successfully or unsuccessfully loaded from data file into the Oracle interface table. Only data records with wrong format are rejected. That is, records with an invalid customer ID are accepted and loaded into the database. These records are rejected by a validation process in the next step.

  5. Run the concurrent program Third Party Billing Import to pass all records from the billing import interface table to Oracle Lease and Finance Management transaction tables. he process validates data for referential integrity. For example, every record must have an amount, contract ID, and type of charge. Moreover, if optional data is supplied, it is validated. For example, if a vendor ID is provided, it should correspond to an active vendor. Note that all the records that passed the checks in the previous step are loaded into the database. f the data is loaded correctly, the column TRX_STATUS_CODE is set to "PROCESSED". If the concurrent program detects errors, the column TRX_STATUS_CODE is set to "ERROR".

  6. Review the audit and exception reports that the concurrent program Third Party Billing Import generated. All validated records are copied to Oracle Lease and Finance Management transaction tables. Rejected records remain in the interface table. The audit report shows the number of excepted and rejected records. The exception report displays rejected records and corresponding error messages.

  7. If any records are rejected, then fix the invalid records until there are no error records.

  8. Repeat these steps until all records are accepted.

Transaction Summary

You can drill down to the specific billing transaction lines to obtain more detailed information in Oracle Lease and Finance Management. Transaction summary information appears in three main areas:

Transaction Summary Procedures

The transaction summary process consists of the following steps:

  1. Retrieve Transaction Summary Records

  2. View Transaction Line Results

  3. View Transaction Line Details Results

Retrieve Transaction Summary Records

You can search and retrieve transaction summary records by specifying any or all of the following fields:

The initial results show you the following fields about an invoice:

View Transaction Line Results

When you click on an invoice in the Transaction Summary results area, the Transaction Lines page appears. This page contains summary information about the invoice in the header, including the Invoice Amount and the Balance. In the Lines section, a breakdown of the lines of the invoice that shows how much was paid and how much is still due for each line of the invoice.

The fields that appear in the Lines region are as follows:

View Transaction Line Details Results

When you click Details for an invoice in the Transaction Summary results region, the Transaction Line Details page appears. This page contains summary information about the invoice in the header, including the Invoice Amount and the Balance.

In the Streams region of the page is a breakdown of the streams history within each line of the invoice that shows how much was paid and how much is still due for each stream of each line of the invoice. The fields that appear in the Streams region are as follows:

Options to Generate and Present Invoices

Options to Generate and Present Invoices Overview

Once billing transactions are processed, the charges must be presented to the customer for payment in invoices or statements of account. When invoices clearly present charges, they are easy to understand to meet the needs of both the customer and the financier.

Sample Invoice Formats

Customers often request clear presentment of billing to make their payable process easier to pay promptly and correctly. Financiers may want to minimize invoice volume while building better customer relationships and winning repeat business through management of their invoices. The following examples describe invoice options.

Example 1

Invoice Format – display invoice information at the level of detail to meet customer requirements. For example, a customer may want invoice detail to match their purchase order or to be notified with an invoice message when certain events occur.

Example 2

Create Invoices

Create Invoices Overview

Creating invoices for lease and loan contracts includes the following tasks:

To complete these tasks, generate billing data through a combination of processes and concurrent programs in Oracle Lease and Finance Management and other Oracle applications.

The billing process also creates disbursements, when required, to passthrough billing charges from customers to vendors for services or from customers to investors for investment returns.

Create Invoices Prerequisites

To create invoices, you must complete the following setups:

Set Up Billing in Oracle Receivables

When you setup billing in Oracle Receivables for each customer that you want to invoice, you must enable consolidated billing for lease and loan contracts in Oracle Receivables. To setup billing in Oracle Receivables, see the Oracle Receivables Implementation Guide.

Define Invoice Grouping Rules and Accounting

Oracle Receivables is seeded with the default OKL INVOICE grouping rule to group Oracle Lease and Finance Management billing transactions using the following parameters: Invoice Group Type, Private Label, OKL Billing Transaction Number, Contract ID, Source of Billing Transaction and Invoice Format Type. You can configure Invoice Groups in Oracle Lease and Finance Management if the seeded grouping rule in Oracle Receivables does not meet your requirements.

Run the Oracle Lease and Finance Management Pre-Billing Report

Before you run concurrent programs to generate billing data, run the Oracle Lease and Finance Management Pre-Billing Report to identify potential errors or incomplete and missing billing information that will prevent the billing programs from completing successfully. The Pre-Billing Report identifies errors in billing information that are difficult to correct once the billable streams are processed in Oracle Lease and Finance Management and transferred to Oracle Receivables. The Pre-Billing Report identifies the contracts for which errors can occur due to disabled bank accounts, disabled receipt methods, incorrect bill-to-site, inaccurate sales representative, and invalid GL code combinations.

Prerequisites to generate billing data are defined in the Billing Transactions prerequisites sections.

Create Invoices Procedures

The objective of the Create Invoices process is to generate billing information in Oracle Lease and Finance Management and pass the information to Oracle Receivables in order to generate an invoice. There are two main stages in the process: the billing information preparation stage and the invoice generation stage. In the billing information preparation stage, you perform one or more of the following sets of billing tasks:

Billing Preparation

In the billing information preparation stage, you perform one or more of the following sets of billing tasks:

Invoice Generation

After the billing preparation stage, you must run the following programs in the invoice generation stage:

If you require passthrough or syndication disbursements to vendors, investors, or suppliers, Oracle Lease and Finance Management sends the required data for invoice approval and payments to Oracle Payables. See Disbursements Overview.

Important: Passthrough billing for services created in Oracle Service Contracts is not possible. The receipt of payments process is a combination of Oracle Lease and Finance Management and Oracle Receivables procedures. When you receive payments and electronic transfers, receipts apply to invoices. Late payments and delinquent invoices result in billing items. The diagram, Procedures to Generate Receipts Data, in Receipt of Payments, Oracle Lease and Finance Management User's Guide, describes the concurrent programs and processes of Oracle Lease and Finance Management for generating receipts data.

The procedures to generate billing and disbursement data call the accounting engine for each transaction created, and automatically create the accounting entries defined in your accounting templates. Oracle Receivables accounts for the receipts procedures.

Invoice Format

Invoice Format Overview

Financiers want to speed collections and customer inquiry response by presenting bills in formats that meet your business requirements and customer needs. You can create multi-line receivable invoices from Oracle Lease and Finance Management and use invoice grouping rules to present invoices that are clear to understand by your customers.

For example, if a customer wants to receive one invoice from your global operations, you have the flexibility to create billing charges from your multiple business units and consolidate charges for rent, fees, and services in one invoice.

To reduce the number of invoices processed, you can group invoices from multiple customer accounts into a single customer invoice.

And if a customer wants to track invoice details for each contract, you can list all charges as separate lines associated with the same contract. Then print and view individual or consolidated invoices in Oracle Lease and Finance Management.

Oracle Receivables is seeded with the default OKL INVOICE grouping rule to group Oracle Lease and Finance Management billing transactions using the following parameters:

You can also configure Invoice Groups in Oracle Lease and Finance Management if the seeded grouping rule in Oracle Receivables does not meet your requirements.

Invoice Format Procedures

If the seeded grouping rule in Oracle Receivables does not meet your requirements, you can define an Invoice Group in Oracle Lease and Finance Management by performing the following tasks:

Create Invoice Grouping Rule

To create an Invoice Group in Oracle Lease and Finance Management, go to Setups > Receivables > Invoice Groups. Give the Invoice Group a name and description and assign it to an Operating Unit.

If you want to group invoices billed on multiple contracts with the same billing terms, you can check the Multi-Contract Invoice box. In this example, do not check the Multi-Contract Invoice box because the scenario does not require invoice grouping across multiple contracts.

Define Invoice Types

The Invoice Types define separate invoices. For example we can create two invoices, one for Rent and one for Fees. In this example, the Rent Invoice Type could include invoice lines for rent and property tax streams and the Fees Invoice Type could include invoice lines for installation, legal, and vendor fees.

Define Invoice Line Types

Create an Invoice Line Type for each Invoice Type to define invoice lines. For example, create invoice lines for rent and property tax. At this point, we have named the invoice lines. To generate billing charges on the invoice line, click Streams (I) to associate streams with the Invoice Line Type.

Associate Stream Types To Invoice Line Type

After completing the previous steps, select the rent streams to be associated with the Invoice Line Type, for example, Rent. When this Invoice Group is associated with a contract and you run billing processes, the rent streams associated this Invoice Line Type, Asset Rent, will be added and the total displayed as an invoice line on the Rent invoice.

Associate Billing Information to Invoice Customer Account

The invoice contact information is based on the Bill To role associated with the invoice customer account. To derive the contact information from a different Bill To role, you must update the Billing To Contact Override system option in the Billing Options region of the Operational Options page.

To update the Billing To Contact Override system option, perform the following steps in the Operational Options page:

  1. Click Update.

  2. In the Billing Groups Contact Override system option of the Billing Group Options region, select the appropriate value from the list of values for Billing To Contact Override.

  3. Click Apply.

Consolidate Billable Amounts into a Single Invoice

Consolidating billable amounts into a single invoice is important because it provides simplified invoices that are easy to track and process. Lessors can consolidate all contract charges independent of the following factors:

Assign Dates for Unscheduled Invoices

Date assignment for unscheduled invoices aligns the unscheduled invoice date with the rent due date. It ensures that the billable amounts can be presented in a single invoice. This consolidates the charges with rent and presents in the same invoice.

You can enable date assignment for unscheduled invoice sources by using the following system options in the Consolidation Options region of the Operational Options page in the Setup tab:

To enable date assignment for unscheduled invoice sources, perform the following steps in the Operational Options page:

  1. Click Update.

  2. From Consolidation Options in the Billing Options region, select the appropriate unscheduled invoice checkboxes to align their due dates with rent.

    Note: You can define the number of tolerance days in the Alignment Tolerance Days system option.

  3. Click Apply.

Complete the date assignment process by running the Assign Due Dates for Invoices concurrent program.

Consolidate Invoices Across Different Revenue Recognition Basis

Lessors require consolidating billable charges in the same invoice regardless of their accounting revenue recognition method. Lessors can do this by using the Non Contingent Cash Basis Revenue Recognition Basis.

If lessors need to consolidate invoices with non accrual revenue recognition method with invoices with accrual revenue recognition, they must select the Non Contingent Cash Basis Revenue Recognition Basis in the stream type setup of the non accrual billable stream.

Note: The Sub-Ledger Accounting (SLA) source Stream Revenue Recognition Basis is required to configure cash basis accounting for Non Contingent Cash Basis streams.

View and Adjust Invoices

Not only are billing details important to customers, and third parties, including collection agents and vendors, but they are vital to internal departments responsible for accounting, customer service, cash management, collections, vendor relationships and investor relationships. Clear and accurate billing information provides critical information to help employees meet their responsibilities to:

View BPA Invoice Details

Oracle Bill Presentment Architecture (BPA) enables you to view a copy of the invoice as presented to the customer.

You can view BPA invoices by navigating to Operations > Invoices, entering your search criteria, and selecting the invoice you want to view. Click Display Invoice after you have selected your invoice.

Select Lease Invoice Details

When configuring your BFA Template Assignment Rules in Oracle Bill Presentment Architecture, you can select Oracle Lease and Finance Management attributes to be evaluated in the automatic invoice template selection process. Then when you create your BFA Invoice Formats, you can select the same attributes to be displayed in the invoice.

The following Oracle Lease and Finance Management attributes can be selected:

For more information on BFA setup, see the Oracle Bill Presentment Architecture User's Guide.

Manual Invoice for Metered Usage Service

An invoice for metered usage may need adjustment due to an incorrect meter read entry or incorrect price. You can generate a manual invoice for usage adjustments, and disburse the correct invoice amounts based on the defined Passthough terms. You can adjust the invoice amount for usage in Base term and Evergreen. If Passthough terms are defined for the usage, the disbursement percent and processing fee percent is applied to the manual invoice based on the corrected usage amount.