4. Product

Under the Setup master tab’s drop-down link bar, the product Setup link opens screens that enable you to configure the basic business guidelines necessary to support one or more products in the system. This includes defining the types of collateral your company supports, creating lending instruments, and determining what is included in credit bureau reporting. Setting up the Products screens requires a thorough understanding of the current rules of your business and must be completed before you can use Oracle Financial Services Lending and Leasing. The Products drop-down link opens screens to record data of all the products supported by the system and contains the following links:

Navigating to Products

In the Setup > Setup > Products link enables you to setup the options related to following closed ended products your company offers:

• Asset Types
• Index Rates
• Regulatory Rates
• Currency Exchange
• Scoring Parameters
• Products
• Contract
• Fees
• Asset Billing Rate
• Insurances
• Spreads
• Statement Messages
• Letters
• Subvention
• Escrow

This chapter explains how to setup the screens associated with each one.

4.1 Asset Types

In Assets types you can setup the asset types that can serve as an application or account’s collateral.

The information on the Assets screen is used by the system to automatically display the appropriate collateral screen (Vehicle, Home, or Other) on the Application Entry screen.

The system recognizes the following four types of collateral:

Collateral Type	Description
Home collateral	Homes, manufactured housing, or any real estate collateral.
Vehicle collateral	All vehicle types, such as cars, trucks, and motorcycles.
Household goods and other collateral	All other collateral types not defined as home, vehicle, or unse­cured; for example, household items such as water heaters, tele­visions, and vacuums.
Unsecured collat­eral	All unsecured lending instruments. (This collateral type makes the collateral tabs on the system forms unavailable.)

The Asset Sub Type section allows you to further categorize an asset; for example, the asset type vehicle might be categorized as car, truck, or van.

The Attributes/Addons and Makes and Models sub screens continue to further detail the asset both in description and value. For example, a vehicle asset might include addons such as leather seats and cruise control.

Note

Neither asset types nor asset sub types can be deleted. As they may have been used in the past, the display and processing of that data is still dependent on the existing setup.

To set up the Asset Types

You can either define new Asset Type or specify a new name in the New Asset Type field and click Create Copy to create a copy of selected asset with details.

1. Click Setup > Setup > Products > Asset Types.
2. In the Asset Type section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Asset Type	Specify the asset type.
Description	Specify the description for the asset. (This is the asset type which will appear throughout the system).
Collateral Type	Select the collateral type (the general category that the asset type falls within) from the drop-down list. Note: There is no need to define an asset for UNSECURED COLLAT­ERAL, as by definition there is no asset on such account.
Company	Select the portfolio company to which the asset type belongs, from the drop-down list. These are the companies within your organization that can make Loans using this asset type. This may be ALL or a specific company.
Branch	Select the portfolio branch to which the asset type belongs, from the drop-down list. This is the branch within the selected company that can make Loans using this asset type. This may be ALL or a specific branch. This must be ALL if in the Company field you selected ALL. IMPORTANT: By selecting which asset type to use, the system searches for a best match using the following attributes: 1 Company 2 Branch Hence, the system recommends creating one version of each asset type where ALL is the value in these fields.
Enabled	Check this box to enable the asset type and indicate that the asset type is currently in use.

3. Perform any of the Basic Actions mentioned in Navigation chapter.
4. In the Asset Sub Type section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Asset Sub Type	Specify the asset sub type.
Description	Specify the description for the asset subtype
Asset Property Type	Select the type of property from the drop-down list.
Enabled	Check this box to enable the asset sub type.

5. Perform any of the Basic Actions mentioned in Navigation chapter.
6. Click Setup > Setup > Products > Assets > Attributes/Addons.
7. In the Attributes/Addons section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Attribute/Addon	Displays the asset attribute or addon name for the selected asset).
Description	Select the description for the asset attribute/addon from the drop-down list.
Default	Specify the default text to be copied or displayed when the asset attributes and addons fields are completed on an application for this asset.
Value	Specify the default monetary value to be copied or displayed when the asset attributes and addons fields are completed on an applica­tion for this asset.
Enabled	Check this box to enable the asset attribute/Addon and indicate that it is available for this type of asset.

8. Perform any of the Basic Actions mentioned in Navigation chapter.
9. Click the Setup > Setup > Products > Assets > Makes and Models.
10. In the Makes and Models section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Make	Specify asset make.
Model	Specify asset model.
Style	Specify asset style type.
Model Year	Specify asset model year.
Enabled	Check this box to enable the asset make and model and indicate that it is included on fields for this asset type.

11. Perform any of the Basic Actions mentioned in Navigation chapter.

4.1.1 Usage/Rental Details

The Usage / Rental Details sub tab allows you to define Usage/Rental definition details to categorize the incoming asset usage/rental data based on different parameters. The details maintained here are populated in Origination screen for billing calculation and can also be modified based on requirement.

For more information on how OFSLL handles Usage based leasing, refer to Appendix - Usage Based Leasing chapter and for Rental based leasing, refer to ‘Rental Agreement’ section in Lease Origination User Guide.

1. In the ‘Usage/Rental Details’ section, perform any of the Basic Operations mentioned in Navigation chapter.
2. A brief description of the fields is given below:

   Field:	Do this:
   Agreement Type	Select the agreement type as one of the following from the drop-down list. The selected Agreement Type defines the criteria for pricing selection during billing calculation. - USAGE - RENTAL - USAGE RENTAL Note: Based on the above selected option, the other fields are either enabled or disabled for selection as indicated below: For Usage Agreement Type, the following fields are editable: Calc Method Usage Cycle Min Usage Max Usage Discount % Usage Rollover / Advance Usage Term Calc Method For Rental Agreement Type, the following fields are editable: Discount % Discount Amount Security Deposit For Usage Rental Agreement Type, the following fields are editable: Usage Cycle Max Usage Discount % Discount Amount Security Deposit
   Calc Method	Select the calculation method as one of the following from the drop-down list. - TIERED (billing is based on the defined Usage/Rental Charge Matrix) - NON-TIERED (system automatically chooses the applicable slab based on the final usage value)
   Usage Cycle	Select the frequency of billing the asset usage from the drop-down list. This field is disabled for RENTAL agreement type.
   Min Usage	Specify the minimum usage value of the allowed range. This field is disabled for RENTAL agreement type.
   Max Usage	Specify the maximum usage value of the allowed range. This field is disabled for RENTAL agreement type.
   Discount %	Specify the percentage of discount exempted from final billing.
   Usage Rollover / Advance	Select the type of asset usage calculation as one of the following: - ROLLOVER (remaining usage balance is carried forward to next cycle) - NO-ROLLOVER (remaining usage balance is not carried forward) - ROLLOVER AND ADVANCE (remaining usage balance is carried forward to next cycle + total usage limit for current cycle can be utilized upfront) - ADVANCE (total usage limit for current cycle can be utilized upfront) Note: This field is disabled for RENTAL and USAGE RENTAL agreement type and ‘NO-ROLLOVER’ option is applicable by default.
   Reset Frequency	Specify the reset frequency of the billing cycle. This field is disabled for RENTAL and USAGE RENTAL agreement types and is available for ROLLOVER, ADVANCE and ROLLOVER AND ADVANCE methods of asset usage billing.
   Usage Term Calc Method	Select the type of asset usage term for billing calculation as one of the following from the drop-down list: - ACTUAL - here the current details updated/received is treated as the final record for usage term calculation. - AVERAGE - here system takes the average of usage details received in previous cycles for usage term calculation. The calculation method selected here is populated to ‘Elastic Term Calc Method’ field in Origination/Servicing Collateral screen. This field is disabled for RENTAL and USAGE RENTAL agreement type.
   Discount Amount	If you are defining Usage/Rental Details for RENTAL or USAGE RENTAL type of agreements, specify the discount amount allowed upfront from the final billing. This field is disabled for USAGE agreement type.
   Security Deposit	If you are defining Usage/Rental Details for RENTAL or USAGE RENTAL type of agreements, specify the security deposit amount paid upfront for the term. This field is disabled for USAGE agreement type.
   Excess Rent Collection Method	If you have selected the Agreement Type as USAGE RENTAL, select one of the following type of Charge Matrix to be used to derive the Excess Rent Collection Method from the drop-down list. - USING USAGE MATRIX - USING RENTAL MATRIX

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.1.2 Usage Charge Matrix

The Usage Charge Matrix sub tab allows you to define and maintain different chargeable slabs based on the combination of Billing Cycle and Charge Type. The details maintained here are used for billing calculation based on a particular asset usage.

For more information on how OFSLL handles Usage based leasing, refer to Appendix - Usage Based Leasing chapter and for Rental based leasing, refer to ‘Rental Agreement’ section in Lease Origination User Guide.

1. In the ‘Usage Charge Matrix’ section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Billing Cycle	Select the frequency of the billing cycle for the asset from the drop-down list.
Units From	Specify the minimum number of units from which the current usage charge matrix is applicable.
Charge Per Unit	Specify the amount to be charged for every unit.
Charge Type	Select the Charge Type as one of the following from the drop-down list. The list is displayed based on CHARGE_TYPE_CD lookup. - BASE (Units considered as base and chargeable at base rate) - EXCESS CYCLE (Units beyond base units and chargeable considering excess cycle) - EXCESS LIFE (Units exceeding the total contracted units and chargeable considering excess life cycle) Excess life is not applicable for Rental agreement type.
Enabled	Check this box to enable the charge matrix for usage calculation.

2. Perform any of the Basic Actions mentioned in Navigation chapter.

4.1.3 Rental Charge Matrix

The Rental Charge Matrix sub tab allows you to define and maintain different chargeable slabs based on the combination of Billing Cycle, Rental Duration, Charge Per Cycle and Charge Type. The details maintained here are used for billing calculation based on a particular asset usage.

For more information on how OFSLL handles Usage based leasing, refer to Appendix - Usage Based Leasing chapter and for Rental based leasing, refer to ‘Rental Agreement’ section in Lease Origination User Guide.

1. In the ‘Rental Charge Matrix’ section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Billing Cycle	Select the frequency of the billing cycle for the asset from the drop-down list.
Rental Duration From	Specify the minimum duration for which the rental charge is applicable.
Charge Per Cycle	Specify the amount to be charged for every rental cycle.
Charge Type	Select the Charge Type as one of the following from the drop-down list. The list is displayed based on CHARGE_TYPE_CD lookup. - BASE (Chargeable units exceeding from base units allowed) - EXCESS CYCLE (Chargeable units exceeding from billing cycle units) - EXCESS LIFE (Chargeable units exceeding the total contract term) Excess life is not applicable for Rental / Usage Rental agreement type.
Enabled	Check this box to enable the charge matrix for usage calculation.

2. Perform any of the Basic Actions mentioned in Navigation chapter.

4.2 Index Rates

The Index Rates screen maintains your organization’s history of periodic changes in index rates. It allows you to define index rates to support variable rate lines of credit. The index rate provides the base rate for a credit line where:

interest rate = index rate + margin rate.

The Index section displays the currently defined indexes on the Lookups screen. You may create additional user-defined lookup codes for this lookup type as needed.

Note

You cannot tie an index rate to a product rate.

You can also record any index rate change on the Index Rates screen. During nightly batch processing, all the accounts with that index type are included when posting the RATE CHANGE transaction. After the system processes the batch, the interest rate of the account is changed. The system will use this new interest rate when computing all future interest calculations.

To set up Index Rates

1. Click Setup > Setup > Products > Index Rates.
2. In the Index section, perform any of the Basic Operations mentioned in Navigation chapter.:

   

3. A brief description of the fields is given below:

   Field:	Do this:
   Index Type	Select the type of index from the drop-down list.
   Short Description	Specify a short description of the index.
   Description	Specify the index description.
   Enabled	Check this box to activate the index type.

4. Perform any of the Basic Actions mentioned in Navigation chapter.

The Index Details section allows you to define multiple index values using the Start Dt and Rate fields.

Note

The history appears in descending order, with the most current record at the top.

5. In the Index Details section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Start Dt	Specify the effective start date for the index rate. You can even select the date from the adjoining Calendar icon.
Rate	Specify the new index rate effective from above mentioned date as a percentage. Note: For the FLAT RATE index there should be only one entry with a Start Dt. = 01/01/1900 and a RATE = 0.0000.
Enabled	Check this box to activate the index rate effective from start date men­tioned above.

6. Perform any of the Basic Actions mentioned in Navigation chapter.

Note

Variable rate functionality is not extended to pre-compute accounts.

4.3 Regulatory Rates

Regulatory rate is the interest rate offered while funding a loan contract which may or may not vary from the contract rate (market rate). The regulatory rates tab allows you to maintain various regulatory rate definitions with specific interest rates and criteria which are used in Origination > Contract screen while defining a loan contract with imputed interest. For more information, refer to ‘Imputed Interest’ section in Loan Origination User guide.

To set up Regulatory Rates

1. Click Setup > Setup > Products > Regulatory Rates.
2. In the ‘Regulatory Rates Definition’ section, perform any of the Basic Operations mentioned in Navigation chapter.

   

3. A brief description of the fields is given below:

   Field:	Do this:
   Regulatory section
   Name	Specify an unique name for the regulatory rate definition. This field is not editable once you save the record.
   Description	Specify a description for the regulatory rate definition.
   Start Dt	Select the start date from when the regulatory rate definition is effective using the adjoining calendar.
   End Dt	Select the end date up to when the regulatory rate definition is effective using the adjoining calendar.
   Enabled	Check this box to enable the regulatory rate definition.
   Rate	Specify the regulatory interest rate to be used for calculation. The rate specified here is populated to Origination > Contract screen while defining loan contract with imputed interest.
   Selection Criteria section
   Company	Select the company for the instrument from the drop-down list. This may be ALL or a specific company.
   Branch	Select the branch within the company for the instrument from the drop-down list. This may be ALL or a specific branch. This must be ALL, if you have selected ‘ALL’ in the Company field.
   Billing Cycle	Select the billing cycle frequency for the instrument as one of the following from the drop-down list. MONTHLY (Default) WEEKLY BI WEEKLY QUARTERLY SEMI ANNUAL ANNUAL
   Product	Select the product for the instrument from the drop-down list. This may be ALL or a specific product defined in the system.
   Asset Class	Select the asset class for the instrument from the drop-down list. This may be ALL or a specific asset class. The list is populated based on Asset Class setup defined in the system.
   Asset Type	Select asset type for the instrument from the drop-down list. This may be ALL or a specific asset type. The list is populated based on Asset Types setup defined in the system.
   Sub Type	Select the asset sub type for the instrument from the drop-down list. This may be ALL or a specific asset sub type. The list is populated based on Asset Types setup defined in the system.
   Asset Make	Specify the asset make from the drop-down list. If ALL was selected for either Asset Type or Asset Sub Type, then ALL will be the only available option for selection.
   Asset Model	Specify the asset model from the drop-down list. If ALL was selected for either Asset Type or Asset Sub Type, then ALL will be the only available option for selection.
   State	Select the state for the instrument from the drop-down list. This may be ALL or a specific state.
   Currency	Select the currency for the instrument from the drop-down list. This may be ALL or a specific currency.

4. Perform any of the Basic Actions mentioned in Navigation chapter.

4.4 Currency Exchange

The Currency Exchange screen maintains currency exchange rates. You can define the currency exchange details and schedule a batch job (SET-IFP- ICEPRC_BJ_100_01 - CURRENCY EXCHANGE RATE FILE UPLOAD) which in-turn pulls the currency exchange rates from desired source at scheduled intervals through input file processing.

To set up the Currency Exchange

1. Click Setup > Setup > Products > Currency Exchange.
2. In the Currency Exchange Rates section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Currency	Select the currency being exchanged from the drop-down list.
Currency Pair	Select the currency to be paired with from the drop-down list.
Effective Date and Time	Specify date and time of the exchange rate. You can even select the date from the adjoining Calendar icon.
Rate	Specify the exchange rate (required).
Enabled	Check this box to activate the currency exchange rate.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.5 Scoring Parameters

With the Scoring Parameters, you can define the scoring parameters of a company’s credit scorecard and behavioral scoring.

While the system’s pricing scores apply to applications and are based on information recorded during origination, behavioral scoring applies to accounts and is based on account history attributes and performed on a monthly basis.

Behavioral scoring

Behavioral scoring examines the repayment trends during the life of the account and provides a current analysis of the customer. This logical and systematic method identifies which accounts are more likely to perform favorably versus accounts where poorer performance is probable. This is useful when determining which other Lines of credit/loan products a customer may qualify for. Behavioral scoring applies to all the three products: loans, lines of credit and leases.

This information appears on the Customer Service form in the Account Details screen’s Activities section.

To set up the Scoring Parameters

You can either define new Scoring Parameters or specify a new name in the New Parameter field and click Create Copy to create a copy of selected parameter with details.

1. Click Setup > Setup > Products > Scoring Parameters.
2. In the Parameters section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Parameter	Specify the name of the scoring parameter. The system recom­mends entering a name that in some way reflects how the parameter is used; for example, use FICO_SCORE instead of PARAMETER_1.
Description	Specify a description of the parameter. Again, Specify a name that reflects how the parameter is used; for example, use FICO SCORE and WEIGHTED FICO SCORE instead of FICO SCORE NUMBER 1 and FICO SCORE NUMBER 2.
Data Type	Select the data type of the scoring parameter being defined from the drop-down list. This determines how the system handles the values. (While DATE and CHARACTER are available data types, generally only NUMBER should be used when defining a scoring parameter.
Scoring Type	Select the scoring type from the drop-down list: credit scoring or behavioral scoring.
Enabled	Check this box to enable and indicate that the scoring parameter is available.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

The Formula Definition section allows you to define a mathematical expression of the scoring parameter you want to define. The expression may consist of one or more sequenced entries. All arithmetic rules apply to the formula definition. If errors exist in the formula definition, the system displays an error message in this section when you choose Show Expression.

4. In the Formula Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Seq	Specify the sequence number (the order in which the formula definition variable will be assembled and evaluated).
(	Specify a left bracket, if you need to group part of your formula definition.
Variable	Select the variable from a validated field based on the user-defined table SCR_CRED_SUMMARY: SCORING PARAMETERS, from the drop-down list.
Constant Value	Specify the constant value (optional). You can specify varchar values which includes Numbers, Alphabets/letters, special character/symbols.
Mathemati­cal Operator	Select the math operator to be used on the adjacent formula definition rows, from the drop-down list.
)	Specify a right bracket, if you are grouping part of your formula definition.
Enabled	Check this box to enable the formula and indicate that it is included when building a definition for the scoring parameter.

5. Perform any of the Basic Actions mentioned in Navigation chapter.
6. In the Parameters section, click Show Expression.

The mathematical expression appears in the Formula Expression section (in sequential order) in the Expression field.

4.6 Products

The Product screen defines the closed ended products your organization offers. This screen is enhanced to support Islamic along with the conventional.

A product is based on the following attributes:

• The collateral type and sub type
• The billing cycle
• Whether the amount is paid directly or indirectly to the customer

The Product Definition section records details about the product such as the description, start and end dates, collateral type and sub type, credit bureau reporting attributes, billing cycle, index and rate calculation attributes.

System supports ‘Biennial’ (once every 2 years) and Triennial (once every 3 years) type of billing cycles. Based on the following lookups, the billing cycle ‘frequency’ can be defined:

• BILL_CYCLE_CD
• LOAN_BILL_CYCLE_CD - For Loan accounts, the Biennial and Triennial billing cycles are applicable only for ‘Standard’ Product Category and for both Advance and Arrears type of Rent Collection Methods - Advance (if First Payment Date is equal to Contract Date) and Arrears (if First Payment Date is greater than Contract Date). However, these billing cycles are allowed for Balloon Methods N and N+1 and ‘not allowed’ for Flexible repayment > Skip Months.

The Product Itemization section is used to define itemized entries for a product. This information is used on the Itemization sub screens of the Application Entry and Application screens.

The Rate Adjustments section is used to define the frequency of rate change allowed during interest rate calculations.

To set up the Product

You can either define new Product details or specify a new product code in the New Product field and click Create Copy to create a copy of selected product with details.

7. On the Oracle Financial Services Lending and Leasing home screen, Setup > Setup > Administration > User > Products > Products > Loan.
8. In the Product Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Product	Specify the product code as defined by your organization (in other words, how you want to differentiate the products). For example, products can be differentiated according to asset. The product code, or name, is unique.
Description	Specify the description of the product. (This is the product description as it appears throughout the system).
Start Dt	Specify the start date for the product. You can even select the date from the adjoining Calendar icon.
End Dt	Specify the end date for the product. You can even select the date from the adjoining Calendar icon.
Direct	Check this box, if you need the product to be originated directly to customer. (In this case, the compliance state is the state listed in the customer’s current mailing address.) If unchecked, the product is an indirect lending product; that is, payment is made to the producer. (In this case, the compliance state is the state listed in the producer’s address.)
Flexible Repayment	Check this box to allow flexible repayment for the Product. When you check this check box, the Flexible Repayment Allowed box of Repayment Options section available under Funding tab > Contract sub tab > Replacement sub tab of Funding screen. Note: On the Repayment sub screen of Contract link on Funding screen, you may only enter the desired repayment schedule type in the Repayment section’s Type field if the Flexible Repayment Allowed is selected.
Close Account After Paid-Off	Check this box to allow the account to be closed once the account is paid off i.e. system closes the account after the number of days specified in the system parameter has elapsed. This option is selected by default. If not selected, system ignores the system parameter and does not close the account even if the account is paid off i.e. system keeps the accounts active so that the equity can be traded with other accounts. For information on accounts trading, refer to ‘Appendix - Trading of Accounts’ chapter. Note: If the business practice of a financial institution is ‘not’ to close the accounts then this Indicator need to be unchecked. Mainly in the Vacation Ownership where a Timeshare Loan can be traded anytime even if the account is paid-off, this feature is used.
Customer Credit Limit	Check this box to enable ‘Customer Credit Limit’ tab in Origination module. Using the ‘Customer Credit Limit’ tab, an underwriter can define a specific credit limit for the customer while funding the first application and based on that credit limit, subsequent applications can be funded. For more information, refer to ‘Customer Credit Limit’ details in User Guide.
Same Billing Cycle	Check this box to set the same billing cycle (supported only billing cycles Monthly and Weekly) for all the future applications funded for an existing customer.
Enabled	Check this box to activate the product. Note: You can check this box only when Rate adjustment schedule is maintained, i.e., All the products should be variable rate products.
Skip Credit Bureau Reporting	Check this box to skip credit bureau reporting of all Accounts funded with this product type - i.e. on funding an application, that particular account is enabled with this parameter and is excluded when the metro II batch job is run for credit bureau reporting. This option can also be enabled/disabled at individual account level in Servicing by posting ‘Skip Credit Bureau Reporting Maintenance’ non-monetary transaction. However note that existing behaviour of ‘Stop Bureau Account’ condition would still be applicable.
Collateral Type	Select the collateral type for the product, from the drop-down list. This field identifies what type of collateral is associated with the and assists the system in identifying the correct screen(s) to display.
Collateral Sub Type	Select the collateral sub type for the product, from the drop-down list.
Credit Bureau Portfolio Type*	Select the credit bureau portfolio type for the product, from the drop-down list.
Credit Bureau Account Type*	Select the account type for the product, from the drop-down list. *Note: The Credit Bureau Portfolio Type and Credit Bureau Account Type fields determine how the portfolio is reported back to the credit bureaus.
Billing Cycle	Select the billing cycle for the product, from the drop-down list.if
Category	Select the category as Standard for the conventional product and Islamic for the Islamic product, from the drop-down list. This serves to group products for reporting purposes.
Index Rounding	Select the index rate rounding factor for the product, from the drop-down list. Note: For more information, refer Appendix C: Rounding Amounts and Rate Attributes.
Reschedule Method	Select the rate change reschedule method for the variable rate product, from the drop-down list. Select CHANGE PAYMENT, if you want to automatically recalculate the repayment amounts on the interest rate change. Select UNDEFINED (the default value), if you do not want to take any action on interest rate change.
Reschedule Value	Specify the value in percent (%) to decide the repayment change. For example, if you enter 10, then the periodic repayment amount will change only if the newly computed repayment amount is higher by 10% of the previous repayment amount. Specify 0 if you want to change repayment amounts with every index rate change.

9. Perform any of the Basic Actions mentioned in Navigation chapter.

Note

The 'Reschedule Method' and 'Reschedule Value' fields allows you to define and control the changes in loan payment amount for Variable and Fixed rate loans during originating, funding, and servicing. For more information, refer Variable and Fixed Interest Rate.

4.6.1 Product Itemizations

1. Click Setup > Setup > Administration > User > Products > Products > Loan > Product Itemizations.
2. In the Product Itemization sub screen, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Itemization	Select the itemization type for the product selected in product definition section, from the drop-down list.
Discount Rate	Specify the discount rate.
Sort	Specify the sort order.
Sign	Select +ve for a positive number and -ve for a negative number. Note: The +ve and -ve buttons determine whether the values will increase or decrease the itemization total for the product based on the selected product. Together the contents of the Product Itemization sub screen, positive and negative, add up to the amount.
Enabled	Check this box to indicate that this product itemization is currently available.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.6.2 Rate Adjustments

1. Click Setup > Setup > Administration > User > Products > Products > Loan > Rate Adjustments.
2. On the Rate Adjustments subtab, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Seq	Specify the sequence number of the rate change adjustments. Consider 1 as the initial (first) rate change adjustment frequency. All subsequent frequencies will be considered for rate change adjustments according to their sequence number.
Adjustment Frequency	Select the frequency value for adjustments, from the drop-down list. Currently, the following values are available in the system: RATE CHANGE OCCURS EVERY X YEARS RATE CHANGE OCCURS EVERY X MONTHS RATE CHANGE OCCURS EVERY X DAYS RATE CHANGE OCCURS EVERY BILLING DATE RATE CHANGE OCCURS EVERY DUE DATE RATE CHANGE OCCURS AT MATURITY
Period	Specify the period associated to adjustment frequency. For example, if you select the adjustment frequency as RATE CHANGE OCCURS EVERY X YEARS and enter 5, the rate change occurs every five years.
# of Adjustments	Enter the number of adjustments associated with the adjustment frequency. For example, in above example, if you enter the value as 2, then rate payment adjustment occurs on the product every five years and will happens 2 times before switching to the next adjustment frequency.
Enabled	Check this box to indicate that this rate adjustment is currently available.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.7 Contract

The Contract screen allows you to define the instruments used within your system. A instrument is a contract used by a financial organization with specific rules tied to it. When processing an application, an instrument associated with the application informs the system of the type of contract being used for the approved loan. This ensures that all parameters tied to the instrument are setup for the account as it is booked - without requiring you to do it.

Instruments can be setup at different levels:

• Company
• Branch
• Product
• Application state
• Currency

The following groups of parameters are setup at the instrument level (Each has its own section on the Contract screen):

• Selection Criteria
• Accrual
• Rebate
• Imputed Interest
• Capitalization
• Scheduled Dues
• Billing
• Delinquency
• Payment Caps
• Extension
• Advance Details
• Rate Cap And Adjustments

Items defined in the contract are “locked in” when you choose Select Instrument on the Funding form’s Contract link.

The Contract screen’s Instrument and Description fields allow you to enter the financial instrument’s name and description, for example; INS-LOAN: VEHICLE.

System supports ‘Biennial’ (once every 2 years) and Triennial (once every 3 years) type of billing cycles. Based on the following lookups, the billing cycle ‘frequency’ can be defined:

• BILL_CYCLE_CD
• LOAN_BILL_CYCLE_CD - For Loan accounts, the Biennial and Triennial billing cycles are applicable only for ‘Standard’ Product Category and for both Advance and Arrears type of Rent Collection Methods - Advance (if First Payment Date is equal to Contract Date) and Arrears (if First Payment Date is greater than Contract Date). However, these billing cycles are allowed for Balloon Methods N and N+1 and ‘not allowed’ for Flexible repayment > Skip Months.

To set up the Contract

You can either define new Contract Definition details or specify a new name in the New Instrument field and click Create Copy to create a copy of selected contract with details.

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Administration > Products > Contract > Loan
2. On the Contract Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Instruments section
Instrument	Specify the code identifying the instrument.
Description	Specify the description of the instrument being defined.
Start Dt	Specify the start date for the instrument. You can even select the date from the adjoining Calendar icon.
End Dt	Specify the end date for the instrument. You can even select the date from the adjoining Calendar icon
Enabled	If you check this box, the system will consider this contract definition when selecting a instrument for an application. Note: Once the field is enabled load balances button in balances sub tab will be disabled
Selection Criteria section
Company	Select the company for the instrument from the drop-down list. This may be ALL or a specific company.
Branch	Select the branch within the company for the instrument from the drop-down list. This may be ALL or a specific branch. This must be ALL, if you have selected ‘ALL’ in the Company field.
Billing Cycle	Select the billing cycle selected from the drop-down list.
Product	Select the product for the instrument from the drop-down list. This may be ALL or a specific product.
State	Select the state in which the instrument is used from the drop-down list. This may be ALL or a specific state.
Currency	Select the currency for the instrument from the drop-down list. IMPORTANT: By selecting which type to use, the system searches for a best match using the following attributes: 1. Billing Cycle 2. Start Date 3. Company 4. Branch 5. Product 6. State Hence, Oracle Financial Services Software recommends creating one version of each type, where ALL is the value in these fields.
Pricing	Select the pricing in which the instrument is used from the drop-down list. This may be ALL or a specific pricing.
Accrual section
Accrual Method	Select the accrual method used to calculate interest accrual for this instrument from the drop-down list.
Base Method	Select the base method used to calculate interest accrual for this instrument from the drop-down list.
Start Dt Basis	Select to define the start date from when the interest accrual is to be calculated for this instrument from the drop-down list. Note: If you select the Effective Date, then the interest is calculated from the Contract date + Start Days (indicated below). If you select the Payment Date, then the interest is calculated based on (first payment date + Start Days (indicated below) minus one billing cycle).
Start Days	Specify the number of grace days after which the interest accrual is to be calculated. Ensure that the number of grace days is less than first payment date.
Time Counting Method	Select the time counting method used to calculate interest accrual for this instrument from the drop-down list.
Installment Method	Select the payment installment method from the drop-down list. Note: the system supports an amortized repayment schedule with the final payment potentially differing from the regular payment amount in the other billing cycles. You may choose: Whether the equal installments for each billing cycle includes any minute final payment differences (equal payments) -or- If the final payment amount may be slightly different (final pay­ment differs).
Int Amortization Freq	Select one of the following interest amortization frequency from the drop-down list: - DAILY - if selected, the interest amortization (TAM) GL entries hand-over happens every day. - EVERY BILLING CYCLE MONTH END - if selected, the interest amortization (TAM) GL entries hand-over happens on month end of the account billing cycle. For example, if account billing cycle is quarterly, the GL handover happens on month end of the quarter.
Imputed Interest This section allows you to enable/disable the imputed interest calculation options in Origination > Contract screen. These options are required while funding a loan application with imputed interest for system to calculate ‘Imputed Interest Amortization Schedule’. For more information, refer to ‘Imputed Interest’ section in Loan Origination User guide.
Imputed Interest	Check this box to enable imputed interest related fields in Origination >Contract screen. By default, this option is un-checked.
Capitalization section This section allows you to define capitalization parameters which helps to capitalize the corresponding account balances to the principal balance of the account based on specific frequency. For example, you can capitalize the accumulated Interest or Late Fees to principal balance of the account. You can either capitalize all the balances based on same frequency or define different frequency for each type of balance. Note: Capitalization parameters can also be updated by posting ‘CAPITALIZATION MAINTENANCE’ monetary transaction.
Capitalize	Check this box to enable capitalization parameters for the contract. By default, this option is un-checked. The option is available only for the following product types: - Interest Bearing Loans and Mortgage Loans - Interest Rate Method Lease - Average daily balance Method Line of Credit
Frequency	Select the required capitalization frequency from the drop-down list. The list contains the following types of frequency to either capitalize all the balances based on same frequency or define different frequency for each type of balance. - Based on specific intervals such as Monthly, Quarterly, Annual and so on. - Based on contract Billing Frequency, Billing Date, or Due date. - Specifically on every Month End. - Or - - Based on Balance Frequency to define different capitalization frequency for each balance. This can further be defined in Balances sub tab.
Capitalization Start Basis	Select the capitalization start date from the drop-down list as either Contract Date or First Payment Date to calculate the capitalization frequency accordingly. However, this field is not enabled for Billing date or Due Date type of capitalization frequency.
Grace Days	Specify the grace days allowed in the frequency (minimum 0, maximum 31) before capitalizing the balances to account. This is also the deciding factor for executing the capitalization batch job which is based on Capitalization Frequency + Grace Days. However, note that Grace Days are not accounted for Month End type of capitalization frequency and is ignored even if specified.
Cap Tolerance Amt	Specify the capitalization tolerance amount which is the minimum amount to qualify for capitalization. Any amount less than this is not considered for capitalization of balances. This helps to avoid capitalization of nominal or decimal amounts. Note: There is no specific accounting maintained for non-capitalized decimals with reference to setup.
Rebate section
Pre Compute	Check this box to indicate that this is a precomputed loan.
Rebate Method	Select the rebate calculation method from the drop-down list.
Rebate Term Method	Select the rebate term method from the drop-down list.
Rebate Min Fin Chg Mthd	Select the rebate minimum finance charge calculation method from the drop-down list.
Min Finance Charge	Specify the minimum finance charge value.
Acquisition Charge Amt	Specify the acquisition charge amount.
Scheduled Dues section
Due Day Min	Specify the minimum value allowed for the due day for this instru­ment.
Due Day Max	Specify the maximum value allowed for the due day for this instru­ment. Note: If billing cycle is selected as weekly, then Due Day Max field value cannot be greater than 7.
Max Due Day Change / Year	Specify the maximum number of due day changes allowed within a given year for this instrument.
Max Due Day Change / Life	Specify the maximum number of due day changes allowed over the life of a product funded with this instrument.
Max Due Day Change Days	Specify the maximum number of days a due date can be moved.
Pmt Tolerance Amt*	Specify the payment tolerance amount. This is the threshold amount that must be achieved before a due amount is considered PAID or delinquent. If (Payment Received + Pmt Tolerance: $Value) >= Standard Monthly Payment, the Due Date will be considered as sat­isfied in terms of delinquency. The amount unpaid is still owed.
Pmt Tolerance%*	Specify the payment tolerance percentage. This is the threshold per­centage that must be achieved before a due amount is considered PAID or delinquent. If Payment Received >= (Standard Monthly Payment * Pmt Tolerance% / 100), the due date will be considered satisfied in terms of delinquency. The amount unpaid is still owed. The system uses the greater of these two values.
Promise Tolerance Amt*	Specify the promise tolerance amount. This is the threshold amount that must be achieved before a due amount is considered kept or Broken. If (Payment Received + Promise Tolerance: $Value) >= Promise Amount, the Due Date will be considered kept (satisfied).
Promise Tolerance %*	Specify the promise tolerance percentage. This is the threshold percentage that must be achieved before a due amount is considered kept or Broken. If Payment Received >= (Promised Amt * Promise Tolerance%), the due date will be considered kept (satisfied). The system uses the greater of these two values.
Billing section
Prebill Days	Specify the prebill days. This is the number of days, before the first payment due, that accounts funded with this instrument will be billed for the first payment. Thereafter, the accounts will be billed on the same day every month. If an account has a first payment date of 10/25/2003 and Pre Bill Days is 21, then the account will bill on 10/04/2003, and then bill on the 4th of every month.
Billing Type	Select the billing type for accounts funded using this instrument from the drop-down list.
Billing Method	Select the billing method for accounts funded using this instrument from the drop-down list.
Balloon Method	Select the balloon payment method for accounts funded using this instrument from the drop-down list.
Multiple Billing Asset Rate	Check this box to indicate if multiple asset rates are applicable for one billing period. System considers billing period from current due date to the next due date. Multiple rates are fetched only when rate end date (rate start date + rate frequency) ends one or more cycle(s) before the next due date i.e. current rate record does not cover the entire billing period.
Delinquency section
Late Charge Grace Days	Specify the number of grace days allowed for the payment of a due date before a late charge is assessed on the account.
Stop Accrual Days	Specify the number of days a contract can be in delinquent state, after which the interest accrual must stop for an account. A Batch Job is run daily to select accounts in delinquent status for a pre-defined number of days and post ‘No Accrual transaction’ for such accounts on current date. When the account recovers from Delinquency, the system will then post a ‘Start Accrual Transaction’ on the date the account is recovered from delinquency.
Delq Grace Days	Specify the number of grace days allowed for the payment of a due date before an account is considered delinquent. This affects DELQ Queues, the system reporting, and the generation of collection let­ters.
Time Bar Years	Specify the total number of years allowed to contact the customer starting from the first payment date and beyond which the account is considered delinquent. You can specify any value between 0-999.
Cure Letter Gen Days	Specify the number of delinquency days to initiate cure letter gener­ation.
Cure Letter Valid Days	Specify the number of days during which the issued cure letter is valid. Usually financial institutions will start the collection activities after the lapse of cure letter validity date.
Delq Category Method	Select the delinquency category method to determine how the sys­tem populates delinquency counters on the Customer Service form. Note: This value does not affect credit bureau reporting.
Accrual Post Maturity	Check this box to indicate that this is the post maturity default rate. Extensions allow you to extend the maturity of the contract by one or more terms by allowing the customer to skip one or more payments. The skipped terms are added to the end of the contract.
Cycle Based Fees - This section allows to define the parameters for calculating cycle based fees at individual account level. Using the below parameters, system derives the Cycle Base Fees and updates the account balances on processing the following batch jobs - TXNCBC_BJ_100_01 (CYCLE BASED COLLECTION LATE FEE PROCESSING) and TXNCBL_BJ_100_01 (CYCLE BASED LATE FEE PROCESSING). For more information, refer to ‘Fee Consolidation Maintenance’ section in Appendix chapter. System calculates the below type of fee in combination of associated and master account and is assessed only when total due crosses ‘Threshold’ amount (that is defined in Setup > Products > Contract > Fees tab and Setup > Products > Fees screen): Fee Late Charge (FLC) Percentage of sum of payment due Percentage of sum of standard payment Percentage of sum of billed amount Cycle Based Collection Late Fee Flat amount Percentage of sum of payment due Percentage of sum of standard payment Percentage of sum of billed amount Percentage of payment due Percentage of standard payment Percentage of billed amount Percentage of total due amount Percentage of sum of total due amount Cycle Based Late Fee Flat amount Percentage of sum of total due amount Percentage of sum of payment due Percentage of sum of standard payment Percentage of sum of billed amount Percentage of total due amount Percentage of payment due Percentage of standard payment Percentage of billed amount
Cycle Based Collection Late Fee	Check this box to enable cycle based collection late fee assessment on the account. If selected, the balance type CYCLE BASED COLLECTION LATE FEE is made available in the Balances tab which further allows to define how system should derive the balances when an account is booked and funded. If unchecked (default), system does not display the ‘Cycle based Collection Late Fee’ balance in Contract >Balances tab on clicking ‘Load Balances’ button.
Cycle Based Late Fee	Check this box to enable cycle based late fee assessment on the account. If selected, the balance type CYCLE BASED LATE FEE is made available in the Balances tab which further allows to define how system should derive the balances when an account is booked and funded. If unchecked (default), system does not display the ‘Cycle Based Late Fee’ balance in Contract >Balances tab on clicking ‘Load Balances’ button.
Cycle Based Collection Late Fee Grace Days	Specify the number of grace days allowed before cycle based collection late fee is assessed on the account. This field is enabled only if the Cycle Based Collection Late Fee option is checked above.
Cycle Based Late Fee Grace Days	Specify the number of grace days allowed before cycle based late fee is assessed on the account. This field is enabled only if the Cycle Based Late Fee option is checked above.
Fee Consolidation - If Cycle Based Late Fee is assessed based on above parameters, this section allows to enable/disable the option to consolidate the late fee at Master Account level.
Late Charge at Master Account	Check this box to allow system to consolidate the late charge assessment at master account level.
Cycle Based Collection Late Fee at Master Account	Check this box to allow system to consolidate the cycle based collection late fee assessment at master account level. Ensure that, the option ‘Cycle Based Collection Late Fee’ is also checked for fee consolidation at Master Account level.
Cycle Based Late Fee at Master Account	Check this box to allow system to consolidate cycle based late fee assessment at master account level. Ensure that, the option ‘Cycle Based Late Fee’ is also checked for fee consolidation at Master Account level.
Extension section
Max Extn Period / Year	Specify the maximum number of terms that the contract may be extended, within a given rolling calendar year.
Max Extn Period / Life	Specify the maximum number of terms that the contract may be extended, within the life of the loan.
Max # Extn / Year	Specify the maximum number of extensions that may be granted within a given rolling calendar year.
Max # of Extn / Life	Specify the maximum number of extensions that may be granted within the life of the loan.
Minimum # Pay­ments	Specify the minimum number of payments that must be made before extension.
Extension Gap in Months	Specify the gap between previous extension provided in the account and current one as specific number of months.
Advance Details section
Multi Disburse­ments Allowed	Check this box, if this contract allows disbursement of funds to cus­tomers through multiple advances or draws up to the approved amount within a specified “draw period.” If you select the Multiple Disbursements Permitted box, complete the Advance Details section on the Contract section. (For more information, see the Stages Funding section in this chapter.)
Min Initial Advance	Specify the minimum initial advance amount allowed. This is the smallest possible initial advance that can be disbursed to the bor­rower after funding.
Max Initial Advance	Specify the maximum initial advance amount allowed. This is the largest possible initial advance that can be disbursed to the borrower after funding.
Late Charge Allowed	Check this box to allow disbursement period late charge.
Min Advance	Specify the minimum advance amount. This is the smallest advance amount that a borrower may subsequently request after the initial advance.
Max Advance	Specify the maximum advance amount. This is the largest advance amount that a borrower may subsequently request after the initial advance.
Billing Allowed	Check this box to allow stage funding with draw period billing.
Draw Period Bill­ing Method	Select the method for billing during the draw period from the drop-down list.
Reschedule Ind	Select this check box to indicate that the rescheduling is allowed at the draw period.
Rate Cap & Adjustments section
Max Rate Inc / Year	Specify the maximum rate increase allowed in a year.
Max Rate Inc / Life	Specify the maximum rate increase allowed in the life of the loan.
Max Rate Dec / Year	Specify the maximum rate decrease allowed in a year.
Max Rate Dec / Life	Specify the maximum rate decrease allowed during the life of the loan.
Max # Adjust / Year	Specify the maximum number of rate changes allowed in a year.
Max # Adjust / Life	Specify the maximum number of rate changes allowed during the life of the loan.
Min Int Rate (Floor)	Specify the minimum rate.
Max Int Rate (Ceiling)	Specify the maximum rate.
Payment Caps section
Max Pmt Inc / Year	Specify the maximum payment increase allowed in a year.
Max Pmt Inc / Life	Specify the maximum payment increase allowed in the life of the loan.
Statement section This section allows to define the preferences for Mock Statement generation at Master Account level. Generating a Mock Statement helps to mock the asset billing process with a future date and to get an upfront statement indicating future dues of Master and Associated Accounts. In ‘Vacation Ownership’ industry, such statements are required to forecast future dues based on current ‘Timeshare’ holdings. The selected preference here are propagated to Application > Contract screen when the instrument is loaded.
Mock Statement Req	Select this check box to indicate if the account is to be include in Mock statement Generation. Note: Based on this selection, others fields related to Mock Statement below are enabled and becomes mandatory for providing details.
Mock Start Month	Select the start month of Mock Statements period from the drop-down list. Note: During the ‘Mock Statement Next Run Date’ validation if next run date is less than Contract Date or GL Date, system moves the ‘Mock Start Month’ to same month of next year. For more information, refer to ‘Mock Statement Maintenance’ in Appendix - Non Monetary transactions sections.
Mock Statement Cycles	Select the total number of billings (between 1-12) that are to be generated post Mock Statement Start Date.
Mock Pre Statement Days	Specify the number of Pre bill days allowed before for Mock Statements generation.
Stmt Preference Mode	Select the account statement preference mode as either Email or PHYSICAL from the drop-down list. The selected preference will be propagated to Application > Contract screen when the instrument is loaded.
Other section
1st Pmt Deduc­tion Allowed	Check this box to indicate that the first payment for fixed rate loans using this instrument may be deducted from the producer's pro­ceeds.
1st Pmt Refund Allowed	Check this box to indicate that refunding first payment deductions to the producer is allowed.
1st Pmt Deduc­tion Days	Specify the first payment deduction days. If the first payment for fixed rate loans using this instrument is less than this number of days from funding, the first payment will be deducted from the pro­ducer’s proceeds if 1st Pmt Deduction.
1st Pmt Refund Days	Specify the first payment refund days. If the first payment for fixed rate loans using this instrument is received within this number of days from the first payment date, the first payment deduction will be refunded to the producer if 1st Pmt Refund.
Refund Allowed	Check this box to indicate that refunding of customer over payments are allowed.
Refund Toler­ance Amt	Specify the refund tolerance amount. If the amount owed to the cus­tomer is greater than the refund tolerance, the over payment amount will be refunded if Refund Allowed box is selected.
Anniversary Period	Specify the anniversary term that define the anniversary period. This is based on billing cycle, so normally for MONTHLY the value is 12 and for WEEKLY the value is 52.
WriteOff Toler­ance Amt	Specify the write off tolerance amount. If the remaining outstanding receivables for accounts funded using this instrument is less or equal to the write off tolerance amount, the remaining balance on the account will be waived.
Pre Pmt Penalty	Check this box, if there is a prepayment penalty charged for accounts funded using this instrument.
% of Term for Penalty	Specify percentage of term for prepayment penalty. If the (remaining terms / total terms) expressed as a percentage exceeds this amount, a prepayment penalty will be assessed if the Pre-Pmt Penalty box was selected.
Recourse	Check this box if recourse is allowed. This indicates whether the unpaid balance may be collected from the producer if the consumer fails to perform on the loan.
Max Recourse%	Specify the maximum percentage of the outstanding receivables that may be collected from the producer if the Recourse Allowed box was selected.
Pay Off Fee Allowed	Check this box to allow for a payoff quote fee to be assessed to the account attached to this contract. Note: This will require you to set up a payoff fee at the contract (Fees sub screen) or state (Fee screen) level. For more information, see the following Contract screen (Loan)’s Fees sub screen or Fee screen (Loan) sections in this chapter.
Escrow Allowed	Check this box, if this contract can do escrow of tax and insurances. (For more information, see the Escrow Setup Form chapter.)
Repmt Currency	Select the designated repayment currency for this contract from the drop-down list.
PDC Security Check	Check this box to indicate that post dated checks are the method of repayment for this contract.
Default Pmt Spread	Select the default payment spread to be used when receiving pay­ments for this account if one is not explicitly chosen, from the drop-down list.
Calendar Method	Select the required calendar method for this contract from the drop-down list. The calendar method "Hijri" should be selected, if the product category is selected as Standard in the Products screen. For "Islamic" product category, the calendar method can be either Gre­gorian or Hijri.
ACH Fee Ind	Check this box to indicate that direct debit fee is included. Note: The ACH Fee/Direct Debit Fee balance will be displayed in Balances sub tab only when this checkbox is selected.
Track Down Payment Balance	Select this check box for system to validate if ‘Down Payment Balance’ is loaded. This helps to record the Down Payment balance Agreed and Paid by the customer. If selected, system validates if Down Payment Balance is loaded in the contract setup. However, system does not validate Down Payment Balance if unchecked. This check box is available only for Loan and Lease contracts.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

Extension of Terms

The system facilitates extension of terms, provided the following conditions are satisfied:

• Specified number or more payments made in the account
• Gap between the previous and current extension provided in the account must be a specific number of months that could be specified

If the above conditions are not satisfied, then the system displays an appropriate error message.

A new transaction Force Extension will be available. This transaction will be posted when you want the system to bypass the extension validations defined at the contract level.

When a backdated transaction with TXN Date exists before the transaction date of extension, all the transactions are reversed and posted again. If extension transaction is posted again, then the validation rules are not validated again.

Staged Funding

Staged funding for closed-end loans allows you to disburse funds to customers through multiple advances or draws up to the approved amount within a specified “draw period.”

To create a multiple disbursement contract for a transaction

1. In the Contract Definition section, click Add and complete the fields following the instructions above, making sure to complete the following steps:

• In the Advance Details section, select the Multiple Disbursement Permitted check box. When you select a contract instrument that permits staged funding (multiple disbursements) on the Funding screen, the system copies the information for that instrument from the Setup Module screen’s Contract screen to the Funding screen’s Contract screen.

Note

You cannot clear the Multi Disbursement Allowed box in the Advance section on the Con­tract screen.

• Complete the fields in the Advance Details section to define the limits for initial and subsequent advances for staged funding.

Note

This information appears in the Advance section of the Funding screen’s Contract link.

2. If you choose, set the following application contract edits as an Error or Warning on the Setup Module screen’s Edits screen.

Note

For more information, see the Edits link (Edits screen) section in this chapter.

1. REQUIRED: ADV DRAW END DATE
2. XVL: ADV DRAW END DT MUST BE AFTER CONTRACT DT
3. XVL: ADV DRAW END DT MUST BE LESS THAN FIRST PMT DT - PREBILL DAYS

These edits appear on the Funding screen’s Verification screen.

Repayment scheduling for staged funding

When funding a loan, the system computes repayment schedules from the contract date, irrespective of whether funds have been disbursed or not. The system uses the approved amount (amount financed) for computing repayment schedules on the contract date.

As the might have been disbursed through multiple draws, or the draws have been less than the approved amount, or the amount may have been repaid in some amount before the draw end date, you may need to change the payment amount. In such cases, you can manually change the payment in the system by posting the monetary transaction CHANGE PAYMENT AMOUNT on the Customer Service screen’s Maintenance link.

Disbursements for staged funding

The approved amount for staged funding can be disbursed with the Funding screen or at a later time using the Advances screen. If the first disbursement is requested during funding, you may enter it on the Itemization sub screen of the Funding screen’s Contract screen.

If the entire approved amount is not disbursed during initial funding, it can be disbursed using the Advances screen’s Advance Entry screen.

If the initial amount on the Advance Entry screen is not within the minimum or maximum limits (as entered in the Advance Details section on the Setup Module screen’s Contract screen), the system displays any of the following error or warning messages in the Advances section’s Error Reason field:

• Advance amount is less than the initial advance amount minimum

-or-

• Advance amount is more than the initial advance amount maximum

The Advance Entry screen also allows you to enter subsequent funding / disbursements. If subsequent advances are not within the predetermined minimum or maximum amounts, the system displays any of the following warning or error messages in the Advances section’s Error Reason field:

• Advance amount is less than the allowed subsequent advance amount

-or-

• Advance amount is more than the allowed subsequent advance amount

Additional messages in the Error Field regarding Staged Funding

If you attempt to post an advance after the draw end date, then the system displays the message in the Advances section’s Error Reason field as, "ADVANCE DT IS AFTER DRAW PERIOD END DATE".

If you attempt to post an advance above the approved amounts, including tolerance, the system displays the message in the Advances section’s Error Reason field as "ADVANCE AMOUNT IS MORE THAN THE TOTAL APPROVED AMOUNT INCLUDING TOLERANCE".

Since this is not a revolving loan, if any repayment is made against the approved amount principal balance, the system will not adjust the disbursed amount allowing for subsequent additional staged funding or advances.

Note

There is no change to the payoff quote functionality in the system. The system uses the actual amount of the advance(s) and any interest accrued since the date of the last pay­ment or credit in the PAYOFF QUOTE VALID UPTO DATE value when the payoff quote is requested before the draw end date.

4.7.1 Balances

The Balances sub screen lists the balances that will be established when an account is booked and funded.

CAUTION: Please contact your Implementation Manager for changes to this section.

To set up the Balances

1. Click Setup > Setup > Administration > User > Products > Contract > Loan > Balances.
2. On the Balances sub screen, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Balance Type	Displays the balance type.
Chargeoff Method	Select the charge off method to determine how the outstanding amount of this balance type will be handled from the drop-down list, if the account becomes uncollectable and the product is charged off.
Writeoff Method	Select the write off method to determine how the outstanding amount of this balance type will be handled from the drop-down list, if the account is within the write off tolerance of being PAID.
Reschedule Method	Select the reschedule method to determine how the outstanding amount of this balance type will be handled from the drop-down list, if the account is rescheduled.
Sort	Specify the sort order of how account balances will appear on the Customer Service form’s Balance screen.
Billed	Check this box to indicate that outstanding amounts for this bal­ance type are considered a part of the billed amount. This also determines whether payments applied to this balance type are considered when satisfying outstanding amounts due.
Accrued	Check this box to indicate that outstanding amounts for this bal­ance type will be included when interest is accrued against the account.
Non Performing Rollover	Check this box to indicate that “non-performing” is used as an intermediary status on your general ledger prior to charge off and want to create balances for non-performing accounts for this bal­ance type. Note: (The Non-Performing Rollover box applies only to Balance Types of Advance/Principal and Interest. For all other Balance Types, this box would be cleared).
Non Performing Balance Type	Select the balance type you want to rollover from drop-down list, if you select the Non-Performing Rollover box (Advance/Princi­pal).
Enabled	Check this box to indicate that this balance type will be created when the account is booked and funded
This section is applicable if the capitalization frequency is selected as Balance Frequency for the contract and allows you to define capitalization parameters for a specific type of account balance such as ‘Interest’. Note: The value of parameters defined in this section supersedes the values defined in header section.
Capitalize	Check this box to enable capitalization parameters for the selected balance type. By default, this option is un-checked. Note: The option is disabled for ‘Advance / Principal’ type of Loan or Line contracts and for Lease Receivables.
Frequency	Select the capitalization frequency from the drop-down list. Frequency can be selected using any of the following options: - Based on specific intervals such as Monthly, Quarterly, Annual and so on. - Based on contract Billing Frequency, Billing Date, Due date. - Specifically on every Month End.
Grace Days	Specify the grace days allowed in the frequency (minimum 0, maximum 31) before capitalizing the balances to account. This is also the deciding factor for executing the capitalization batch job which is based on Capitalization Frequency + Grace Days. However, note that Grace Days are not accounted for Month End type of capitalization frequency and is ignored even if specified.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

The system loads the currently defined balances for accounts.

If your organization maintains additional balances, contact your Implementation Manager for information regarding those balances.

4.7.2 Amortized Balances

With the Amortize Balances sub screen, you can select one or more balances to be amortized over the life of the loan. You can also define the amortization method.

To set up the Amortization Balances

1. Click Setup > Setup > Administration > User > Products > Contract > Loan > Amortized Balances.
2. In the Amortization Balances section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Amortize Balance Type	Select the amortize transaction type from the drop-down list.
Amortization Method	Select the amortization method used to calculate the net amortization amount from the drop-down list.
Cost/Fee method	Select the amortization cost/fee method.
Sort	Specify the sort sequence to define the order of the amor­tize balances.
Enabled	Check this box to enable the amortize balance to be created when the account is booked and funded.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.7.3 Itemizations

On the Itemizations sub screen, you can define the itemized components for each type of contract, indicate if it is required, and determine whether it has a positive or negative bearing on the contract itemization math. You can establish the following groups of itemization transactions:

Type	Description
Advance	Total amount of the product that is not a part of financed fees; in other words, the total amount the customer requested to be advanced.
Financed Fees	Fees rolled into the principal balance of the product. Financed fees are also considered to be a part of the finance charge.
Pre-Paid Fees	Fees that are paid by the consumer prior to the funding of the loan. These fees are not rolled into the balance of the product but are consid­ered as part of the finance charge and are included in the calculation of the APR.
Producer	Fees that are paid to or by the producer of the loan; for example, a fee that is being charged to the producer. These transactions will affect pro­ceeds.
Escrow	Allows you to connect the actual escrow itemization with the escrow type and the funding transaction.

To set up the Itemizations

1. Click Setup > Setup > Administration > User > Products > Contract > Loan > Itemizations.
2. On the Itemization sub screen select the option button to indicate the type of itemization you are working with: Advance, Financed Fees, Pre-Paid Fees, Producer, or Escrow.
3. On the Itemization sub screen, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Itemization	Select the itemization from the drop-down list.
Disbursement Type	Select the disbursement type from the drop-down list.
Transaction	Select the funding transaction type from the drop-down list.
Itemization Type	Select the itemization type from the drop-down list. Notes: 1. On selecting the "Prefunding Txns" as itemization type, it indi­cates that this particular itemization expects a payment from the cus­tomer prior to funding. 2. The itemization type "Prefunding Txns" is available only for loans.
Sort	Specify the sort order to define the order of the itemization transac­tions.
Sign	If the itemized transaction increases the group balance, click +ve. -or- If the itemized transaction decreases the group balance, click -ve.
Enabled	Check this box to enable the itemization and indicate that this itemi­zation transaction will be created when the account is booked and funded.
Amortize Bal­ance	Select the amortize balance affected by this itemization transaction from the drop-down list. Note: Advance itemizations do not affect amortize balances.
Refund Calcula­tion Method	Select the refund calculation method from the drop-down list
Taxable	Check this box, if the itemization type is taxable. However, note that the taxable option defined in Setup > Administration > System > Sale Tax screen will supersede with this preference.
Seller Pmt	Check this box to enable seller payment
Escrow	Select the escrow from the drop-down list.
Itemization For­mula	Select the itemization formula description from the drop-down list.
Refund Calcula­tion Method	Check this box to enable Refund calculation Method.
Escrow Required	If this is an escrow account, check this box to indicate that an escrow is required during the application process (though at that time the user can choose Opt Out to decline.)
Discount. Rate	Specify the discount rate for the itemization.

4. Perform any of the Basic Actions mentioned in Navigation chapter.

4.7.4 Fees

Any fees that are defined in the contract are set up on the Fees sub screen. The system currently supports the following contract fees:

• Late charges
• Non sufficient funds
• Extensions
• Prepayment penalties
• Delay Fee
• ACH Fee

The Fees sub screen allows you to define those fees whose value and method of calculation are set at the time of the loan. As these amounts cannot be changed after the product is booked and funded, you should only set up fees here that will not change over the life of the loan. Individual contract fee types may be defined multiple times in order to create graduated fees.

Note

Certain fees, like late fees, can be set up at contract, as well as state level. In such cases, the contract fee, if present, is used first.

To set up the Fees

1. Click Setup > Setup > Administration > User > Products > Contract > Loan > Fees.
2. In the Fees section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Type	Select the fee type from the drop-down list.
Txn Amt From	Specify the lowest transaction amount or balance amount against which this contract fee definition may be applied.
Amount Financed From	Specify the minimum value of amount financed on the contract. Note: This is the 'Contracted loan amount' during origination and would always be the 'Amount Financed' on contract even if principal addition is done through a transaction in servicing.
Method	Select the method of calculating the fee to be assessed from the drop-down list.
Frequency	Select the frequency of calculating the fee to be assessed from the drop-down list.
Threshold Amt	This field is enabled only if the Contract Fee type is either CYCLE BASED COLLECTION LATE FEE or CYCLE BASED LATE FEE. Specify the threshold amount which is less than or equal to minimum fee amount to be assessed. Based on this amount, system calculates and posts the Cycle Based Collection Late Fee or Cycle Based Late Fee based on the account. If calculated fee amount is less than threshold amount, fee is posted with transaction amount = 0. If calculated fee amount is greater or equal to threshold amount, fee is posted based on existing min amt and max amt comparing logic.
Min Amt	Specify the minimum fee amount to be assessed.
Max Amt	Specify the maximum fee amount to be assessed. If you selected FLAT in the Method field, then this field is not used and is normally populated as $0.00.
Percent	Specify the fee percentage of the outstanding transaction amount to be assessed as a fee. This amount will be adjusted to fall within the Min Amount and the Max Amount.
Enabled	Check this box to create the selected contract fee when the account is booked and funded.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.7.5 Behavioral Score Models

You can either define new Behavioral Score Model details or specify a new name in the New Behavioral Model field and click Create Copy to create a copy of selected score model with details.

1. Click Setup > Setup > Administration > User > Products > Scoring Models > Loan > Behavioral Score Models.
2. In the Score Models section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Result section
Max Score	Specify the maximum score allowed. (This is normally the sum of the Max Value fields within the scoring parameters.).
Selection Criteria section
Company	Select the company for the scoring model, from the drop-down list. This may be ALL or a specific company.
Branch	Select branch within the company for the scoring model, from the drop-down list. (This may be ALL or a specific branch. However, if you have selected ‘ALL’ in Company field, then you must select ‘ALL’ for this field).
Product	Select the product for the scoring model, from the drop-down list. This may be ALL or a specific product.
Currency	Select the currency for the scoring model, from the drop-down list. This may be ALL or a specific currency.
Bureau Score Reasons	Check this box if bureau score reason is applicable.
Auto Decision	Check this box if auto decision is applicable.
Model	Specify the code for the scoring model.
Description	Specify a description of the scoring model.
Start Dt	Specify the start date for the scoring model. You can even select the date from the adjoining Calendar icon.
End Dt	Specify the end date for the scoring model. You can even select the date from the adjoining Calendar icon.
Enabled	Check this box to enable the scoring model.

3. Perform any of the Basic Actions mentioned in Navigation chapter.
4. Click ‘Create Copy’ button on the Score Models screen to create copy of the selected record with details.

The Parameters section records the parameters used to determine the score calculated by the scoring model. You can define multiple parameters and adverse action reason associated with each parameter in a scoring model. Each scoring parameter can have maximum values set. The score range is based upon the information in the Range Definition section on the Parameters sub tab.

The system calculates a final score by adding the score for each parameter in the scoring model. A parameter weighted value is used to find the four adverse action reasons, if bureau reasons are not used.

Note

A character parameter range definition should contain the exact value of the parameter. Each scoring parameter should have range definitions defined that encompass all of the values that might result.

5. In the Parameters section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Parameter	Select the parameter from the field, from the drop-down list.
Max Value	Specify the maximum value allowed for the selected parameter.
Adverse Action Reason	Select the adverse action reason.
Weighted Value	Specify the weighted value.
Enabled	Check this box to enable the parameter.

6. Perform any of the Basic Actions mentioned in Navigation chapter.
7. The Range Definition section allows you to translate the calculated value for a scoring parameter into the value to be used, depending on the returned value of the parameter.
8. In the Range Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Value From	Specify the lowest calculated value to apply the specific translation. The ceiling of the range definition is based on the range definition with the next highest Value From or the Max Value of the scoring parameter (whichever is less).
Value From	Select the following options to determine how values for a scoring param­eters are translated: % Max Value – If selected, then the calculated values within the range definition receives a value based on a percentage of the Max Value of the scoring parameter. % Param – If selected, then the calculated values within the range defini­tion receives a value based on a percentage of the calculated value of the scoring parameter. Value – If selected, then the calculated values with in the range definition receives a specific value.
Percent / Value	Specify the percent or value to be used in the translation of the calculated value of the scoring parameter.
Enabled	Check this box to consider this range definition while translating values for this scoring parameter.

9. Perform any of the Basic Actions mentioned in Navigation chapter.

4.8 Fees

The Fee screen allows you to define fees that may be automatically assessed by the system. The Fee Definition section records fees not defined within the Contract screen’s Fees sub screen.

The following fee types are currently supported for automatic assessment:

• Late charge
• NSF
• Extension
• Advance
• Over Credit Limit
• Membership
• Prepayment penalty
• Phone Pay
• Payoff Quote
• Periodic Maintenance
• Rental Fee
• ACH Fee
• Delay Fee
• Other Fee and Tax

Fees can be calculated as either a flat amount or a percentage of payment due based on fee type.

You can specify minimums and maximums for fee amounts in the Min Amt and Max Amt fields. Different fee rules can be setup at the company/branch level.

When Fees are assessed, the system determines the best match using all enabled fee definitions that meet the following criteria:

• Exactly match the fee type being assessed.
• Have an effective date that is greater than or equal to the start date.
• Have a Txn Amt From that is greater than or equal to the outstanding amount related to the fee assessment.
• Match either the value or ALL for all other criteria (Exact matches for each field are given a higher weight than matches to ALL.)

The returned rows are then given a descending rank based on the weighted values and the hierarchical position of the following criteria:

1. Company
2. Branch
3. Product
4. Application state
5. Transaction amount
6. Start date
7. End date
8. Currency

On the ranked rows, the first row is returned as the best match.

Note

Certain fees, like late fees, can be set up at contract, as well as state level. In such cases, the contract fee, if present, is used first. Only if the contract fee is not present in the state fee used.

To set up the Fee

9. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Administration > User > Products > Fees > Loan.
10. In the Fee Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

    

A brief description of the fields is given below:

Field:	Do this:
Fee Rule	Specify the fee rule used to identify the particular fee definition.
Fee Type	Select the fee type from the drop-down list. The system computes these drop-down values from the TXN_TYPE_CD Lookup, with FEE as the sub type.
Start Dt	Specify the start date. You can even select the date from the adjoin­ing Calendar icon.
End Dt	Specify the end date. You can even select the date from the adjoin­ing Calendar icon.
Enabled	Check this box to enable the fee.
Calc Method	Select one of the following method of calculating the fee, from the drop-down list. If ‘Flat Amount' is selected, then minimum fee will be charged. If ‘Percentage’ is selected, then the amount charged will be based on percentage defined subject to minimum and maximum amount (i.e. 'Txn Amt From').
Threshold Amt	This field is enabled only if the Contract Fee type is either CYCLE BASED COLLECTION LATE FEE or CYCLE BASED LATE FEE. Specify the threshold amount which is less than or equal to minimum fee amount to be assessed. Based on this amount, system calculates and posts the Cycle Based Collection Late Fee or Cycle Based Late Fee based on the account. If calculated fee amount is less than threshold amount, fee is posted with transaction amount = 0. If calculated fee amount is greater or equal to threshold amount, fee is posted based on existing min amt and max amt comparing logic.
Min Amt	Specify the minimum amount for the fee.
Max Amt	Specify the maximum amount for the fee. If you selected FLAT amount in the Calc Method field, then this field is not used and is normally populated as $0.00.
Percent	Specify the percentage value of the outstanding transaction amount to be assessed as a fee. This amount will be adjusted to fall within the Min Amount and the Max Amount.
Selection Criteria section
Company	Select the portfolio company from the drop-down list. This may be ALL or a specific company.
Branch	Select the portfolio branch from the drop-down list. This may be ALL or a specific branch. (This must be ALL, if you have selected ‘ALL’ in the Company field).
Channel	Select the channel from the drop-down list, This can be ALL or a specific channel.
Product	Select the product from the drop-down list. This may be ALL or a specific product. The available values come from a validated field based on the selected Billing Cycle setup and the Product setup.
State	Select the state for this fee, from the drop-down list. This may be ALL or a specific state.
Currency	Select the currency for this fee, from the drop-down list. This may be ALL or a specific currency.
Txn Amt From	Specify the transaction or balance amount. The fee is calculated using the specifications of this record only if the transaction amount is greater than the value specified in this field (and less than this field in another record for the same fee). IMPORTANT: When you select the fee to use, the system searches for a best match using the following attributes: 1 Company 2 Branch 3 Product 4 State 5 Amount (Txn Amt From) 6 Effective/start date (Start Dt) Hence, Oracle Financial Services Software recommends creating a version of each fee, where ALL is the value in the these fields. It is also recommended that you define a default printer for an Organization, Division and Department.
Amount Financed From	Specify the minimum value of amount financed on the contract. Note: This is the 'Contracted loan amount' during origination and would always be the 'Amount Financed' on contract even if principal addition is done through a transaction in servicing.

11. Perform any of the Basic Actions mentioned in Navigation chapter.

4.9 Asset Billing Rate

In Asset Billing Rate screen you can setup the various parameters associated with ‘Home’ collateral which serves as the input for ‘Asset Billing’ batch job to process and post the dues on to respective accounts in the system.

The chapter consists of following sections:

• Asset Billing Rate Definition
• Asset Billing Rate Details
• Asset billing Calculations
• Asset Billing Rate Setup - File upload
• Asset Billing Batch Job

4.9.1 Asset Billing Rate Definition

In the Asset Billing Rate Definition tab you can create and maintain ‘Timeshare’ specific Home collateral and account details of an account which are used as a selection criteria.

To set up Asset Billing Rate Definition

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Administration > User > Products > Asset Billing Rate.

   

2. In the Asset Billing Rate Definition section, perform any of the Basic Operations mentioned in Navigation chapter. A brief description of fields are given below:

   In this field:	Do this:
   Name	Enter a unique name for Asset Billing Rate definition. This field is not editable after saving the record or during EDIT.
   Description	Enter the description for Asset Billing Rate definition.
   Enabled	Check this box to enable the record.
   Selection Criteria
   Company	Select the portfolio company from the drop-down list. This list is populated based on Enabled Company definitions main­tained in the system.
   Branch	Select the portfolio branch from the drop-down list.
   Product	Select the type of product associated with the collateral from the drop-down list.
   State	Select the state to which the account operates from the drop-down list.
   Channel	Select the channel from the drop-down list.
   Asset Type	Select asset type from the drop-down list. The list is popu­lated based on assets setup.
   Asset Sub Type	Select the asset sub type from the drop-down list.
   Club Name	Select the Club Name from the drop-down list.
   Phase Number	Select the Phase Number from the drop-down list.
   Site of Inventory	Select the Site of Inventory from the drop-down list.
   Building	Select the Building from the drop-down list.
   Unit	Select the Unit from the drop-down list.
   Week	Select the Week from the drop-down list.
   Room/Unit Type	Select the Room/Unit Type from the drop-down list.
   Usage Type	Select the Usage Type from the drop-down list.
   Resort Identifier	Select the Resort Identifier from the drop-down list.
   Min Points	Specify the minimum points for the asset billing definition.
   Max Points	Specify the maximum points for the asset billing definition.
   Association Id	Select the Association Id from the drop-down list.
   Club Indicator	Check this box to indicate Club Indicator.
   Plus Membership Type	Check this box to indicate Plus Membership Type.
   PR Marking	Check this box to indicate PR Marking.
   Signature Grand Father	Check this box to indicate Signature Grand Father.
   Additional Attributes - This section consists of additional 15 configurable fields as indicated below 5 check boxes - Membership 1-5 Opt 5 drop-down lists - Other Attribute 1-5 5 Calendar fields - Other Attribute 5-10

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.9.2 Asset Billing Rate Details

In the Asset Billing Details sub tab, you can define Transactions, their Calculation Method, and other parameters which are posted by Billing Batch Job.

Note that once a record is created in this section, the same is available in Read-Only mode and you can only Enable or Disable the record in Edit mode.

To set up Asset Billing Rate Details

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Administration > User > Products > Asset Billing Rate.
2. In the Asset Billing Rate Details section, perform any of the Basic Operations mentioned in Navigation chapter. A brief description of fields are given below:

   In this field:	Do this:
   Start Date	Select the date of asset billing from adjoining calendar.
   Transaction	Select the transaction from the drop-down list. This list is populated with transactions where the Transaction code = FOTH%.
   Calc Method	Select one of the following calculation method from drop-down list. - Flat Amt - Rate - Flat Amt + Rate - Tiered Rate - Slab Formula For more information on above calculation methods, refer to ‘Asset billing Calculations’ section.
   Flat Amt	Specify the flat amount or fixed amount to be charged during asset billing calculation. This field is available if the Calc Method is Flat Amt, Flat Amt + Rate, and Slab based Formula.
   Rate	Specify the rate for asset billing calculation. This field is avail­able if the Calc Method is Rate and Flat Amt + Rate.
   Frequency	Select the frequency of asset billing calculation from the drop-down list. The list is populated based on frequency maintained in lookup code.
   % of Calc Amt	Specify the percentage of amount for calculation. By default, this is set to 100.
   Base Points	Specify the base points for asset billing calculation. By default this is set to 1 since a value is required system does not allow to enter ‘0’. This field is available if the Calc Method is Rate, Flat Amt + Rate, Tiered Rate, and Slab Formula.
   Slab Points	Specify the slab points for asset billing calculation. This field is available if the Calc Method is Slab Formula.
   % Increase	Specify the percentage increase in each slab for asset billing calculation. This field is available if the Calc Method is Slab Formula.
   Min Amt	Specify the base minimum amount to be configured for the resulted transaction amount. If the resulted Transaction Calculation Amount is less than the Min Amt defined here, system posts the transaction with Min Amt.
   Max Amt	Specify the maximum amount to be configured for the resulted transaction amount. If the resulted Transaction Calculation Amount is greater than the Max Amt defined here, system posts the transaction with Max Amt.
   Billing Year	Specify the year in which the Rate is applicable. The Billing Year is stamped in billing amount transaction description only for FOTH% transactions.
   Enabled	Check this box to enable the Asset Billing Rate.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.9.2.1 Tiered Rate Details sub tab

The Tiered Rate Details sub tab you can define ‘points’ specific tiers with different rates. This sub tab is enabled only if the transaction calculation method is selected as ‘Tiered Rate’ in Asset Billing Rate Details section. For calculation details, refer to ‘Tiered Rate Calculation’ section.

To set up Tiered Rate Details

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Administration > User > Products > Asset Billing Rate.
2. In the Tiered Rate Details section, perform any of the Basic Operations mentioned in Navigation chapter. A brief description of fields are given below:

   In this field:	Do this:
   From Points	Specify the points from where the respective rate is applica­ble.
   Rate	Specify the rate for defined points range.
   Enabled	Check this box to enable Tiered Rate detail

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.9.3 Asset billing Calculations

This section explains the following calculation methods based on which the Asset Billing is processed in the system:

• Flat Amount Calculation
• Rate Calculation
• Flat Amt + Rate Calculation
• Tiered Rate Calculation
• Slab Formula Calculation

4.9.3.1 Flat Amount Calculation

In ‘Flat Amount’ calculation, system calculates the Transaction Amount using below formula:

Frequency	Billing Cycle	Transaction Amount Calculation
Annual	Monthly	(Flat Amt/12)
Monthly	Annual	(Flat Amt*12)
Annual	Quarterly	(Flat Amt/4)
Quarterly	Annual	(Flat Amt*4)
Annual	Semi Annual	(Flat Amt/2)
Semi Annual	Annual	(Flat Amt*2)
Annual	Annual	(Flat Amt /1)

Consider the above calculation as reference for other combinations of Rate Frequency and Billing cycle.

4.9.3.2 Rate Calculation

In ‘Rate’ calculation, system calculates the Transaction Amount using below formula:

Frequency	Billing Cycle	Transaction Amount Calculation
Annual	Monthly	(Rate/12)*(Billing Points at collateral / Base Points)
Monthly	Annual	(Rate*12)*(Billing Points at collateral / Base Points)
Annual	Quarterly	(Rate/4)*(Billing Points at collateral / Base Points)
Quarterly	Annual	(Rate*4)*(Billing Points at collateral / Base Points)
Annual	Semi Annual	(Rate/2)*(Billing Points at collateral / Base Points)
Semi Annual	Annual	(Rate*2)*(Billing Points at collateral / Base Points)
Annual	Annual	(Rate/1)*(Billing Points at collateral / Base Points)

Consider the above calculation as reference for other combinations of Rate Frequency and Billing cycle.

4.9.3.3 Flat Amt + Rate Calculation

In ‘Flat Amt + Rate’ calculation, system calculates the Transaction Amount using below formula.

Transaction Amount = Flat Amt + Rate * (Billing Points at Collateral/Base Points)

Note

The Rate and Flat amount are adjusted based on Frequency and Billing Cycle.

4.9.3.4 Tiered Rate Calculation

In ‘Tiered Rate’ calculation, system selects the ‘Asset Billing Rate Details’ using the Billing Points at Asset and other asset parameters and calculates the transaction amount by deriving the rate from Tiered Rate table.

Transaction Amount = (Tiered Rate) * (Tiered Points / Base Points)

For example, if an Asset has 1.5 million points and the range is maintained as - for first million points rate=0.66 with Base Points =1000 and for remaining points rate=0.60 with Base Points = 1000, the Transaction Amount = 1million * (0.66/1000) + 0.5 million * (0.6/1000) = 660 + 300 = 960.

Note the following:

• If the range for specific points are not maintained correctly, the same is considered as ‘0’ rate and in-turn the Transaction Amount derived also becomes ‘0’.

For example, if Billing Points are 8000 but if range maintained points is from 10000 with Rate = 0.55 and Base Points = 1, the transaction amount results as (0*(8000/1) =0).

• Rate is adjusted based on Frequency and Billing Cycle as mention in ‘Rate’ Method.

4.9.3.5 Slab Formula Calculation

In ‘Slab Formula’ calculation, system calculates the Transaction Amount using below formula.

Transaction Amount = [Flat Amt] + Ceil[\{Billing Points - Base Points)/Slab Points}*\{%Increase / 100)*Flat Amt}]]

The resultant amount will always be rounded-up.

For example,

Transaction Amount = [491.32+[{(61000-5000)/2500}*{(30.4/100)*491.32}]]

= [491.32+ [Round-up {22.4}*{149.36}]]

= [491.32+3435.28]

Transaction Amount = 3926.6

Note

The Rate and Flat amount are adjusted based on Frequency and Billing Cycle.

4.9.4 Asset Billing Rate Setup - File upload

The data in Asset Billing Rate screen can also be created and updated from an external file through SET-IFP input file upload process. While doing so, ensure that the file format of Header and Details record are maintained in required order and the input file is placed in upload area.

During the scheduled batch job run, the asset billing batch job picks-up the data in input file and loads on to the system to create Asset Billing Rate setup records.

However, before processing the details, system performs the following validations:

• If Name of the record is unique and duplicate record is not being updated.
• For Tiered Rate, the details are added only if the Calc Method = Tiered Rate. If not, system displays an error indicating ‘Tiered Rate Details are not required for <Calc Method>’ and the record is added in bad file.
• For update to existing record details, only Enable/Disable option is supported. If there is a mismatch in the name of the record, batch job errors out with message ‘Record not found’ and the record is added in bad file.
• For new records, all the fields are mandatory and default values are applicable.
• Values provided in fields which are of lookup type are validated with lookup code. In case of mismatch, batch job errors out with message ‘Lookup value not matching’ and the record is added in bad file.
• Negative values is not added for number fields.
• Base Point's field does not contain negative, ‘0’, or decimal values.

4.9.5 Asset Billing Batch Job

The billing batch job TXNDDT_BJ_100_01 (BILLING/DUE DATES PROCESSING) facilitates to process the asset billing dues on account for ‘Home’ collateral and posts the corresponding transactions.

Listed below is the sequence of processing steps:

1. Billing batch job picks-up the Vacation Ownership (VO) parameters from Servicing > Account > Collateral (Home) > Vacation Ownership tab.

• The required accounts for Asset billing batch job processing is selected based on the type of account selected in ‘Due Amt Account Type’ field. I.e. in ‘Vacation Ownership Details’ section if the ‘Billing’ option is checked and the Due Amt Account Type is selected as Current or Linked or Master Account, then the billing batch job posts the transactions based on Asset Billing Rate setup in Current account or Linked Account of current Account or Master Account of current Account respectively.
• In addition, system includes the asset billing points of Linked Account/Associated Account only if the status of those accounts are in any of the status defined in lookup code ‘ACC_STATUS_BILLING_CD’ (ACCOUNT STATUS FOR ASSET BILLING CODES). Account statuses which are not maintained in the lookup code are excluded for asset billing calculation. However, If no statuses are maintained in the lookup, then system will consider all statuses for consolidation.
  • If billing flag is checked and Due Amt Account Type = Current Account, billing batch job posts the transactions based on Asset Billing Rate setup in ‘Current’ account.
  • If billing flag is checked and Due Amt Account Type = Linked Account, billing batch job post the transactions based on Asset Billing Rate setup in ‘Linked Account of current Account’.
  • If billing flag is checked and Due Amt Account Type = Master Account, billing batch job post the transactions based on Asset Billing Rate setup in ‘Master Account of current Account’.

Before the due calculation, batch job validates VO parameters with the following:

• If the selected Usage Type sub code is ‘FULL’, system considers Full points for rate derivation and ‘Billing points’ is considered for Transaction Amount calculation.
• If the selected Usage Type sub code is ‘HALF’, system considers ‘Billing Points’ for Transaction Amount calculation but rate is derived using full points.
• If the ‘First Year Proration’ check box is selected, then the rate is derived using full points and the Transaction Amount is calculated based on prorated points (not on full points).
• The prorated points are calculated based on Asset ‘Usage Start Date’.
  • If the usage start date year is equal to first due year, then system prorates the points as indicated in example below:

If First Due Date = 01/01/2018, Usage Start Date = 01/10/2018,

Prorated Points = Billing Points * (13-1)/12= Billing Points *1

If First Due Date = 01/01/2018, Usage Start Date = 03/10/2018

Prorated Points = Billing Points * (13-3)/12= Billing Points*10/12

Note: Number ‘13’ here is used as constant.

• If the usage start date year is before the due date year, system considers the full points for calculating the Transaction Amount and no proration is required here.

2. Batch job looks of best matching Asset Rate details and Asset Billing definition in Setup.
3. Batch job checks for status (Y/N) of ‘Multiple Billing Asset Rate’ indicator at Account Details > Contract > Billing level to decide if multiple asset rates are applicable for one billing period or not.

• If ‘N’, system picks the latest rate which is less than or equal to DUE DATE. In this case only one best match record is fetched to derive Transaction Amount and no multiple asset rates are applicable for one billing period.
• If ‘Y’, system fetches multiple rates only when rate End Date (i.e. rate start date + rate frequency) ends with one or more cycle(s) before the next due date. This implies that current rate record does not cover the entire billing period.
• However, if ‘Multiple Billing Asset Rate’ is set to Y but there is no ‘Rate’ available for Due period beyond the Rate End date, system applies the same rate that is picked for Due Period which is Less than or Equal to Due End Date.

4. Batch job posts the matched transactions at account level based on calculation method. The following Asset Billing Rate Details are stamped on the transaction posted:

• Asset Id (Assets)
• Asset Rate Id (Asset Billing Rate Definition)
• Asset Rate Details Id (Asset Billing Rate Details)
• Rate Start Date (Asset Billing Rate Details)
• Rate Frequency (Asset Billing Rate Details)
• Calculation Method (Asset Billing Rate Details)
• Rate (Asset Billing Rate Details)
• In case of Tiered Rate, Effective Rate is stamped
• Base Points (Asset Billing Rate Details)
• Slab Points (Asset Billing Rate Details)
• % Increase (Asset Billing Rate Details)
• Billing Year (Asset Billing Rate Details)

On posting the transactions, following validations and outcome are handled:

• If the respective balance for transaction is missing, batch job fails with an error message indicating ‘Account #: Transaction posting failed Balance not available’ in Batch > Request Results block and does not process the account due amount calculation.
  • This can be rectified by posting ‘Add balance to Account’ non-monetary transaction. For more information, refer to Appendix - Non-Monetary transactions section in Servicing User Guides.

• If the transaction posting failed due to an issue in Access grid configuration or Product configuration at transaction codes, batch job displays error indicating ‘Account #: Transaction posting failed <Reason>’ and does not process the account due amount calculation.
• If the Resulted transaction amount is less than Min Amount defined, batch job considers the Min amount and posts the transaction.
• If the Resulted transaction amount is greater than Max Amount defined, batch job considers the Max amount and posts the transaction.

4.10 Compensation

With the Compensation screen, you can define compensation plans for producers who supply the financial institution with applications for loans. These compensation plans can be set up at various levels depending upon your organization’s needs.

This information is used on the Compensation sub tab on the Origination > Application > Contract tab. The Compensation Plan field lists the plans available based on the contract in use for the application. When you click Load on the Compensation sub tab, the system adds the information setup on the Compensation screen.

Compensation can be paid to a producer in a number of ways:

Payment calculation method:	Description:
AS EARNED	The compensation amount is paid out in pieces over the life of the product based upon the interest earned.
PAY AS U GO	The compensation amount is paid out in pieces over the life of the product based upon the interest received by virtue of the payment.
UPFRONT	The entire compensation amount is paid at the time of booking the loan.
UPFRONT MONTH END	The entire compensation amount is paid at the month-end of booking the loan.
UPFRONT MONTH END (amortize spread formula)	The amount financed will be amortized at a rate equal to the difference between the contract rate and buy rate. The finance charge thus derived would be considered the base compensation amount. the system then allows this base compensation to be split into two components: 1) Upfront compensation amount 2) Remaining compensation amount. The disbursement method will apply to the remaining compensation portion (total compensation minus the upfront amount).

Compensations can be charged back from a producer, if a product is prematurely paid or charged off. The charge back amount can be calculated using the following methods:

• Earned
• Percentage

You can specify whether the unearned portion or a certain percentage of the total compensation is to be charged back in case of early payoff or charge off.

The period for which the charge back plan can remain active can be set up according to:

• Number of days
• Term (number of months)

To set up the Compensation

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Administration > User > Products > Compensation > Loan.
2. In the Compensation Plan Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Code	Specify the compensation code.
Description	Specify a description of the compensation plan being defined.
Start Dt	Specify the start date for the compensation plan. You can even select the date from the adjoining Calendar icon.
End Dt	Specify the end date for the compensation plan. You can even select the date from the adjoining Calendar icon.
Enabled	Check this box to enable the compensation plan.
Result section
Disbursement Method	Select the method for calculating the compensation disbursement to be paid, from the drop-down list.
Formula Method	Select the type of formula to be used to calculate the compensation to be paid, from the drop-down list. The system uses following formula methods: FLAT AMOUNT - Flat amount is paid. SPREAD BASE FORMULA - A formula based on the spread between the buy rate and the interest rate offered to the consumer is used. PERCENTAGE OF AMOUNT FINANCED - To calculate the compensation based on percentage of amount financed.
Formula	Select the formula to be used to calculate Compensation, from the drop-down list. The list is sorted with available option based on Formula method selected.
Factor	Specify the compensation factor; that is, the percentage applied to the compensation to be paid. If this value is not 100.00, it will reduce the compensation amount.
Addl Factor	Specify the additional compensation factor. If this value is not 100.00, it will further reduce the compensation amount.
Max Spread Or Percent	Specify the maximum compensation Spread. This limits the Spread on which compensation will be paid. Spreads exceeding this value will be treated as if the spread was the specified value.
Flat Amt	Specify the flat compensation amount.
Upfront%	Specify the percentage of the compensation allocated upfront.
Paid Off Method	Select the method of the compensation that will be recovered by the producer, from the drop-down list, if the amount is paid early,.
Paid Off Basis	Select the basis used to determine the amount of compensation to be recovered from the producer, from the drop-down list, if the amount is paid early.
Paid Off Days	Specify the number of days in which the compensation can be recovered, if the Basis is selected as Days.
Paid Off Term	Specify the term in which the compensation can be recovered, if the Basis is selected as Term.
Paid Off Percent	Specify the percent of the compensation that will be recovered by producer, if the amount is paid off.
Charge off Method	Select the method of the compensation that will be recovered by the producer, from the drop-down list, if the amount is charge off.
Charge off Basis	Select the basis used to determine the amount of compensation to recover from the producer, from the drop-down list, if the product is charged off as uncollectable.
Charge off Days	Specify the number of days in which compensation can be recovered, if the Basis is DAYS.
Charge off Term	Specify the number of terms in which compensation can be recovered, if the Basis is TERM.
Charge off Percent	Specify the percent of the compensation that will be recovered by producer if the account is charged off as uncollectable, and the charge off basis is PERCENTAGE.
Selection Criteria section
Company	Select the portfolio company, from the drop-down list. This may be ALL or a specific company.
Branch	Select the portfolio branch within the company for the selected compensation plan, from the drop-down list. This may be ALL or a specific branch. This must be ALL if in the Company field you selected ALL.
Billing Cycle	Select the billing cycle for the compensation plan, from the drop-down list.
Product	Select the product for the selected compensation plan, from the drop-down list. This may be ALL or a specific product. The available values come from a validated field based on the selected Billing Cycle setup and the Product setup.
State	Select the state for the selected compensation plan, from the drop-down list. This may be ALL or a specific state.
Currency	Select the currency for the selected compensation plan, from the drop-down list. This may be ALL or a specific currency.
Pro Group	Select the producer group for the compensation plan, from the drop-down list. This may be ALL or a specific producer group.
Pro Type	Select the producer type for the compensation plan, from the drop-down list. This may be ALL or a specific producer type.
Producer	Select the producer for the compensation plan, from the drop-down list. This may be ALL or a specific producer. The available values come from a validated field based on the Pro Group and Pro Type.
Grade	Select the credit grade for this compensation plan, from the drop-down list. This may be ALL or a specific grade.
Amt	Specify the minimum amount financed for the compensation plan.
Term	Specify the minimum term for the compensation plan.
Asset Class	Select the asset class for the compensation plan, from the drop-down list. This may be ALL or a specific asset class. The available values come from a validated field based on the Collateral Type.
Asset Type	Select asset type for the compensation plan, from the drop-down list. This may be ALL or a specific asset type. The available values come from a validated field based on your assets setup.
SubType	Select the asset sub type for this compensation plan, from the drop-down list. This may be ALL or a specific asset sub type. The available values come from a validated field based on your assets setup.
Asset Make	Specify the asset make from the drop-down list. If ALL was selected for either Asset Type or Asset Sub Type, then ALL will be the only available selection for the asset make.
Asset Model	View the asset model from the drop-down list. If ALL was selected for either Asset Type or Asset Sub Type, then ALL will be the only available selection for the asset model (display only).
Age	Specify the asset age.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.11 Commission

The Commission screen allows you to calculate dealer commissions for additional products (for example, life insurance and disability insurance) for lease sold by the dealer and entered in the Itemization sub screen during lease origination. You can setup the various commission plans, which you use or select during funding.

In addition to the criteria, you can also define the insurance itemization, as well as the commission itemization for which the plan is valid.

You can select one of the following two system-defined methods to calculate the commissions:

• Flat amount
• Percentage of itemization amount.

To set up the Lease Commission Plan

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Administration > User > Products > Commission > Lease.
2. In the Commission Plan Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Code	Specify the commission code.
Description	Specify the commission plan description.
Start Dt	Specify the start date associated with the commission. You can even select the date from the adjoining Calendar icon.
End Dt	Specify the end date associated with the commission. You can even select the date from the adjoining Calendar icon.
Enabled	Check this box to enable the compensation plan.
Results section
Calculation Method	Select the commission calculation method as either ‘Flat Amount’ or ‘Percentage of Itemization Amount’ from the drop-down list.
Value	Specify the commission value.
Commission Itemization	Select the commission itemization from the drop-down list.
Selection Criteria section
IMPORTANT: When you select commission to use, the system searches for a best match using fields in this section. Hence, Oracle Financial Services Software recommends creating one version of each compensation where ALL is the value in these fields when you have the option.
Company	Select the portfolio company associated with the commission, from the drop-down list.
Branch	Select the portfolio branch associated with the commission, from the drop-down list.
Billing Cycle	Select the billing cycle associated with the commission, from the drop-down list.
Product	Select the product associated with the commission, from the drop-down list.
State	Select the state associated with the commission, from the drop-down list.
Currency	Select the currency associated with the commission, from the drop-down list.
Pro Group	Select the producer group associated with the commission, from the drop-down list.
Pro Type	Select the producer type associated with the commission, from the drop-down list.
Producer	Select the producer associated with the commission, from the drop-down list.
Grade	Select the credit grade associated with the commission, from the drop-down list.
Amt	Specify the minimum itemization amount associated with the commission.
Term	Specify the minimum insurance, warranty term associated with the commission, from the drop-down list.
Asset Class	Select the asset class associated with the commission, from the drop-down list.
Asset Type	Select the asset associated with the commission, from the drop-down list.
SubType	Select the asset sub type associated with the commission, from the drop-down list.
Asset Make	Select the asset make associated with the commission, from the drop-down list.
Asset Model	Select the asset model associated with the commission, from the drop-down list.
Age	Specify the asset age associated with the commission.
Ins/Warranty Itemization	Select the insurance or warranty itemization associated with the commission, from the drop-down list.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.12 Insurance

Most financial institutes offer financing for insurance to the borrowers; examples include credit life, credit disability, and GAP. The insurance product offer permits the customer to cancel the insurance in mid term or automatically end when the product matures or is paid-off. The system supports financing of insurance products during origination and automatically end the insurance when the product is paid-off. The system also can compute the rebate premium based on “Rule of 78” or “Actuarial” method. As the customer might cancel the insurance in mid term of the Lease, the system computes the premium rebate on a prorate basis. This also applies to additional insurance purchase during the life of the Lease. Normally, mid term insurance cancellations have associated fees and grace period. In such cases, the customer may cancel the insurance during the grace period without accruing any fees. However, when a customer cancels after the grace period, the result is a predefined fees which the system deducts from the computed rebate.

The system supports mid term insurance cancellation with and without grace period and cancellation fees. With this enhancement of insurance processing, you can define the premium rebate computation with a prorate basis.

You can define financed insurance related itemizations in the Origination Fees screen, as you have in previous releases with the Insurance screen. You can also set the refund method to “Pro Rate Basis” in the Refund Method field in the Contract Itemization section on the Itemization sub screen during setup with the on the Contracts screen.

To set up the Insurances

You can either define new Insurance details or specify a new code in the New Insurance field and click Create Copy to create a copy of selected insurance with details.

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Products > Insurance > Loan.
2. In the Insurance Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Code	Specify the code associated with the insurance product.
Description	Specify a brief description of the insurance product.
Start Dt	Specify the date from which you can start offering the product to customers. You can even select the date from the adjoining Calendar icon.
End Dt	Specify the date from which to stop offering the product to customers. You can even select the date from the adjoining Calendar icon.
Enabled	Check this box to allow the offering of this insurance product.
Result section
Insurance Type	Select the insurance types available for financing, from the drop-down list.
Insurance Company	Specify the name of the company through which the insurance product is offered.
Cancellation /Refund Allowed	Check this box to allow the insurance rebate or refund for cancellation or paid-off.
Grace Days	Specify the number of grace days allowed for cancellation without charging a cancellation fee.
Refund Calculation Method	Select the insurance premium refund/rebate calculation method to be used when insurance is cancelled, from the drop-down list.
Cancellation Fee	Specify the amount of the cancellation fee to be charged when the insurance is cancelled.
Grace Day's Cancellation Fee Allowed	Check this box to allow cancellation fees during grace period.
Deduct Fee From	Select one of the followings option from the drop-down list to deduct the cancellation fee: Premium amount - which is deducted upfront before computation Rebate amount - which is deducted after computation
Selection Criteria Section
Company	Select the portfolio company that can offer the insurance product, from the drop-down list. Select ALL if offered by all companies.
Branch	Select the branch of the specified portfolio company that can offer the insurance product, from the drop-down list. Select ALL if offered by all the branches of the specified portfolio company.
Product	Select the product for which you can offer the insurance product, from the drop-down list. Select ALL if offered for all the products.
State	Select the state for which you can offer the insurance product, from the drop-down list. Select ALL if this is offered for all the states.
Currency	Select the currency for which you can offer the insurance product, from the drop-down list. Select ALL if this is offered for all the states.

3. Perform any of the Basic Actions mentioned in Navigation chapter.
4. Click ‘Create Copy’ button in the Insurance Definition section to create copy of selected record with details.
5. In the Insurance Details section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Insurance Sub Type	Select the insurance sub type you want to define for the entry in the Insurance section, from the drop-down list. For example SINGLE.
Term From	Specify the minimum term for the insurance sub type.
Rate	Specify the rate for premium calculation per $1,000.00 for the insurance sub type.
Max Coverage Amt	Specify the maximum coverage amount covered by the insurance sub type.
Enabled	Check this box to enable the insurance.

6. Perform any of the Basic Actions mentioned in Navigation chapter.

4.13 Spreads

The Spreads screens allows you to define the payment allocation strategy used by your business while applying payments to accounts. Spreads are selected on the Payment Entry (Payment Maintenance) screens.

Depending on account status and condition, you can also define various combinations of spreads for same account using the Spread Matrix, which can be defaulted when particular accounts are selected for payments.

The Spreads screens consists of the following tabs:

• Spread Definition
• Spread Matrix

4.13.1 Spread Definition

The Spread Definition section is used to define individual spreads. Many common spreads have already been defined. With each spread, you can define the due date advancement method to use, bring current, future, or None.

The Spreads screen records the order in which balances are satisfied when a payment is applied to an account. (Unless someone indicates otherwise, payments will be applied against each balance type, in sort order, until either there is no remaining balance, or the payment has been completely allocated.)

To set up the Spreads

You can either define new Spread Definition details or specify a new name in the New Spread field and click Create Copy to create a copy of selected spread definition with details.

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Products > Spreads > Loan > Spread Definition.

In the Spread Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Spread	Specify the code identifying the spread.
Description	Specify the description for the spread. (This usually reflects when this spread is used.).
Due Dt Adv	Select the due date advancement code that determines how payments applied using this spread will affect due amounts, from the drop-down list. The system uses the following prede­fined Due Dt Adv Codes: NONE – Payments applied using this spread will not affect the due amounts of the account in any way BRING CURRENT – The payment allocations for transac­tions against an account’s outstanding balances that make up the billed balances. This will be applied against billed due amounts FUTURE – The payment allocations for transactions against an accounts outstanding balances that make up the billed balances. This will be applied against billed due amounts. Any remaining amount allocated against billed balances will be accumulated and applied against future due amounts. FUTURE WITH PRINCIPAL, INTEREST THEN ESCROW FUTURE WITH ESCROW, THEN PRINCIPAL AND INTER­EST
Enabled	Check this box to enable the spread.

2. Perform any of the Basic Actions mentioned in Navigation chapter.
3. In the Spread Transaction Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Balance Type	Select the balance type to allocate a portion of the received payment, from the drop-down list. Note: Oracle Financial Services Software recommends that you always setup an ADVANCE/PRINCIPAL balance type for each spread.
Cycle	Specify the balance cycle during which to apply payments. This collects payment on bad (unpaid) cycles. You can go back by only five cycles. Cycle will have a value of 0 for loans.
Sort	Specify the sort order in which the balance type has payments allocated against it.
Enabled	Check this box for the system to consider this spread transaction when allocating payments.

4. Perform any of the Basic Actions mentioned in Navigation chapter.

To Load Details

1. Create a record in Spread Definition section, with Enabled check box unchecked.
2. Click Load Details button, the system will load the spread transaction definition details.

4.13.2 Spread Matrix

The Spread Matrix tab in Spreads screens allows you to define and maintain different combinations of spreads depending on a particular account status, Conditions, Primary Customer State, Amount Financed and Priority.

When there are multiple spreads defined for an account with different conditions, you can set the priority for the system to sequence the same.

The details maintained here are used to default the ‘Spread’ when a particular account is selected in the Payment Entry or Payment Maintenance screen.

To set up the Spread Matrix Details

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Products > Spreads > Loan > Spread Matrix.

   

2. In the Spread Matrix section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Start Dt	Select the start date for the spread from the adjoining calen­dar.
End Dt	Select the end date for the spread from the adjoining calen­dar.
Enabled	This check box is selected by default indicating that the spread is enabled.
Spread	Select the required product active spread from the drop-down list.
Selection Criteria
Account Sta­tus	Select the account status for the spread from the drop-down list.
Account Condition	Select the account condition for the spread from the drop-down list. Note: You can define multiple conditions for the same account.
State	Select the state of the primary applicant from the drop-down list.
Loan Amt From	Specify the value of Loan amount from where the system should consider the current spread.
Priority	Specify the priority when there are multiple conditions posted on the same account. System considers the least numbered priority as first in the sequence.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.14 Statement Messages

The Messages screen allows you to set up messages that appear on account statements sent to customers. You can set up statement messages for different products. When the system generates a statement for an account, all statement messages matching the selection criteria are included in the statement file for that account.

The system inserts the message in the Text field into the statement file produced during the nightly batch job for the appropriate consumers.

A record of an account’s statement history, including the messages included in the statement, appears on the Statement’s screen on the Customer Service screen.

To set up the Messages

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Administration > User > Products > Statement Messages > Loan.
2. In the Statement Messages section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Seq	Specify the sort sequence of how the statement message should be printed.
Code	Specify the message code identifying the statement message.
Start Dt	Specify the first date the statement message is available. You can even select the date from the adjoining Calendar icon.
End Dt	Specify the last date the statement message is available. You can even select the date from the adjoining Calendar icon.
Enabled	Check this box to enable the message.
Result section
Text	Specify the text of the statement message.
Selection Criteria section
Company	Select the company for the statement message from the drop-down list. This may be ALL or a specific company.
Branch	Select the branch within the company for the statement message from the drop-down list. This may be ALL or a specific branch. This must be ALL if in the Company field you selected ALL.
Product	Select the product for which this statement message will be used from the drop-down list. This may be ALL or a specific product.
Currency	Select the currency for the statement message from the drop-down list. This may be ALL or a specific currency.
Producer	Select the producer for the statement message from the drop-down list. This may be ALL or a specific producer. The available values come from a validated field based on the Pro Group and Pro Type. IMPORTANT: By selecting which message to use, the system searches for a best match using the following attributes: 1. Company 2. Branch 3. Product 4. Producer 5. Currency Hence, Oracle Financial Services Software recommends creating one version of each edit type where ALL is the value in these fields.

4.15 Letters

The Letters screen allows you to define letters that the system automatically generates when the application or the account for a products meets certain conditions, or “trigger events.” Each letter has its own trigger event. For example, you can configure the system to automatically send a welcome letter when an application becomes an account or send a collection letters when an account becomes delinquent.

The system supports the following types of letters:

Type of letter:	Definition:
ACCOUNT STATEMENT	Generated when account is to receive a billing statement (this time is defined in contract setup). Letter is sent to customer.
ADVERSE Action letter	Generated in nightly batch jobs for applications that were declined. This letter is sent to the consumer to indicate the reasons why the application was declined.
CONDITIONAL ADVERSE	Generated in nightly batch jobs for applications that were declined.
ACTION LET­TER	This letter is sent to the consumer to indicate the reasons why the application was declined. This letter also indicates steps that the con­sumer may take to gain approval of the application.
COLLECTION LETTER 1	Generated when an account becomes delinquent. This is the first dunning letter sent to the customer.
COLLECTION LETTER 2	Generated when an account remains in delinquency for an extended period. This is the second dunning letter sent to the customer.
COLLECTION LETTER 3	Generated when an account remains in delinquency for an extended period, even after having received previous notices. This is the final dunning letter sent to the customer.
CONTRACT FUNDING fax/email	Generated when an application is APPROVED: FUNDED or condi­tioned: funded. This letter is sent to the producer.
DECISION FAX/EMAIL	Generated when an application is APPROVED, conditioned, or rejected. This letter is sent to the consumer or producer, depend­ing on whether the product is a direct or in-direct loan.
PAID IN FULL LETTER	Generated in nightly batch jobs when the account pays off. This letter is sent to the customer.
PAYOFF QUOTE LET­TER	Generated when a payoff quote is created for an account. This letter is sent to the customer.
WELCOME LET­TER	Generated when an application is APPROVED: FUNDED. This letter is sent to the consumer. STATEMENT PAST MATURITY Generated when an accounts are matured but unpaid. This letter is sent to the account holders as a reminder to make their payments.

When the system generates letters, it searches the Letters screen for letter definitions that meet the following criteria:

• Definition is enabled.
• Definition is an exact match of the letter code being generated.
• Definition is a match of either the application/account value or ALL for all other criteria.

Exact matches for each field are given a higher weight than matches to ALL.

The returned rows are then given a descending rank based on the weighted values and the hierarchical position of these fields:

1. Company
2. Branch
3. Product
4. State
5. Currency

On the ranked rows, the first row is returned as the best match.

To set up the Letters

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Administration > User > Products > Letters > Loan.
2. In the Letter Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Letter Code	Specify the code for the letter.
File Name	Specify the file name of the Oracle report used to generate the letter. The file should be named <File Name>.rep on your server.
Letter Type	Select the type of letter you want to generate from the drop-down list.
Channel	Select the application source (channel) for the letter from the drop-down list. This may be ALL or a specific channel.
Enabled	Check this box to enable this letter definition.
Result section
Batch Printer	Select the batch printer being used to generate the letter from the drop-down list.
Batch User	Select the user who will submit this letter from the drop-down list. This will normally be set to BATCH.
Selection Criteria section
Company	Select the portfolio company for which this letter will be used from the drop-down list. This may be ALL or a specific company.
Branch	Select the portfolio branch for which this letter will be used from the drop-down list. This may be ALL or a specific branch. This must be ALL if in the Company field you selected ALL).
Product	Select the product for which this letter will be used from the drop-down list. This may be ALL or a specific product.
State	Select the state for which this letter will be used from the drop-down list. This may be ALL or a specific state.
Currency	Select the currency for which this letter will be used from the drop-down list. This may be ALL or a specific currency.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.16 Subvention

The Subvention Setup screen’s loan Subvention tab allows you to set up Loan subvention plans for producers (groups or individuals). Multiple producers may contribute to one subvention plan or a plan can be set for a specific producer.

Subvention Types

Subvention can be offered in many forms for vehicle loans. The most common format is the rate subvention for vehicle loans. Rate subvention involves sharing the finance charge (interest) by the participant (most frequently with the manufacturer). The finance company sets its buy rate (the minimum cost to the company to extend the loans to a customer). If the customer rate is less than this buy rate, then the amount is equivalent to the interest amount for the difference (the buy rate minus the customer rate) is paid by the participant as the subvention amount.

Currently Oracle Financial Services Lending and Leasing supports the following subvention types:

Loan subvention types:

• Rate
• Cash bonus
• Buy down

Subvention plans can be defined for one participant (for example, a manufacturer or a particular dealer) or group of participants (such as a dealer association). One subvention plan could have multiple sub plans and multiple participants could participate to each sub plan.

Example

Subvention plan:

• “Summer Special Event”

Subvention sub-plans for above plan:

• 1.9% for 36 months

- or -

• 2.99% for 48 months

- or -

• 3.99% for 60 months

- or -

• $1500.00 cash bonus

Multiple participants may participate in each sub plan. For example, for the 1.9% rate, 1% might be shared by the manufacturer and 0.9% might be shared by the dealer. Similarly, for the $1,500 cash bonus, $1,000 might be shared by the manufacturer and $500 by the dealer. Or, the complete $1,500 might be covered by the manufacturer.

Collection of subvention amounts can be set for each participant in the subvention plan with the Collection Method.

Oracle Financial Services Lending and Leasing supports following collection methods:

Type	Details
UPFRONT	The entire subvention amount is collected at the booking of the Loan from the producer proceed.
UPFRONT STATEMENT	The entire subvention amount is collected at the time of the subven­tion statement.
PAY AS U GO	The subvention amount is billed to the producer when the customer pays the Loan payment. The producer is due for the amount at each statement.

Subvention Refund

There are times when a Loan is either paid-off early or gets charged off and the finance company refunds the unearned subvention amount back to the producer. The refund is available only when the subvention amount is collected from the producer proceeds (upfront) or the whole amount is billed in the first statement (Upfront Statement).

You can set up the system to allow refunds only for a certain period and not beyond that. The period can be set differently for charge offs and paid offs and can be based on two methods:

1. Days
2. Term

The system provides the following methods for refund amount calculation:

1. Earned
2. Percentage

The earned method is used to refund the unearned portion of the collected subvention amount. The percentage method is used to refund a certain percentage of the subvention amount collected.

4.16.1 Loan Subvention Plans

The Loan Subvention Plans screen allows you to set up subventions for Loans.

To set up the Loan Subvention Plans screen.

1. On the Oracle Financial Services Lending and Leasing home screen, Click Setup > Setup > Products > Subvention > Loan.
2. The system displays the Loan Subvention screen. The details are grouped into three.

• Plan Definition
• Sub Plan Definition
• Plan Details.

3. In the Plan Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Code	Specify the subvention plan code.
Description	Specify the subvention plan description.
Company	Select the company name from the drop-down list.
Branch	Select the branch name from the drop-down list.
State	Select the state from the drop-down list.
Start Date	Specify the start date for the subvention plan (required). You can select the date even from the adjoining Calendar icon.
End Date	Specify the end date for the subvention plan. You can select the date even from the adjoining Calendar icon.
Enabled	Check this box to activate the record.
Selection Criteria
Billing Cycle	Select billing cycle from the drop-down list.
Product	Select the product from the drop-down list.
Asset Class	Select the asset class from the drop-down list.
Asset Type	Select the asset type from the drop-down list.
Asset Sub Type	Select asset sub type from the drop-down list.
Asset Make	Select asset make from the drop-down list.
Asset Model	Select the asset model from the drop-down list
Asset Age	Specify the asset age.

4. Perform any of the Basic Actions mentioned in Navigation chapter.
5. In the Sub Plan Definition section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Code	Specify the subvention sub plan code.
Description	Specify the subvention sub plan description (required).
State	Select the state from the drop-down list.
Pro Group	Select the producer group from the drop-down list.
Pro Type	Select the producer type from the drop-down list.
Producer	Select the producer from the drop-down list.
Enabled	Check this box to activate the record.
Amt From	Specify the amount.
Subvention Type	Select the subvention type from the drop-down list.
Grade	Select the grade from the drop-down list.
Term	Specify the term.
Asset Class	Select the asset class from the drop-down list.
Asset Type	Select the asset type from the drop-down list.
Sub Type	Select asset sub type from the drop-down list
Asset Make	Select asset make from the drop-down list.
Asset Model	Select the asset model from the drop-down list
Age	Specify asset age.

6. Perform any of the Basic Actions mentioned in Navigation chapter.
7. In the Plan Details section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Participant	Select the participant from the drop-down list.
Collection Method	Select the collection method for the subvention plan from the drop-down list.
Transaction	Select the transaction code from the drop-down list.
Rate	Specify the subvention rate.
Enabled	Check this box to activate the record.
Calculation section:
Method	Select the subvention calculation method from the drop-down list. The list displays the following values: - SPREAD DEFAULT - SPREAD DEFAULT - (minus) PRESENT VALUE - FLAT AMOUNT - % OF AMT FINANCED - % OF AMT FINANCED + FLAT AMOUNT
Override	Check this box to allow overriding the rate at the time of under­writing / funding.
Max Amt	Specify the maximum subvention amount.
% Amt Financed	Specify the percentage of amount financed to derive the Subven­tion Amount. For example: If Amount Financed = 100$, and % of Amt Financed = 5%, then the Subvention Amount = 100 * 0.05 = 5$
Flat Amt	Specify the flat amount.
Factor	Specify the subvention factor.
Spread Max	Specify the maximum subvention spread value.
Refund section:
Paid Off Method	Select the method from the drop-down list, if the account is paid-off early.
Paid Off Basis	Select the basis from the drop-down list, if the account is paid-off early.
Paid Off Period	Specify the number of terms in which the subvention can be refunded to the producer, if the account is paid-off early.
Paid Off Percent	Specify the refund percentage, if the account is paid-off.
Charge Off Calc Method	Select the calculation method from the drop-down list, if the account is charged-off.
Charge Off Basis	Select the charge off basis from the drop-down list.
Charge Off Period	Select the charge off period from the drop-down list.
Charge Off Percent	Select the charge off percent from the drop-down list.
Amortization section:
Balance Type	Select the amortize balance type from the drop-down list.
Method	Select the amortize method from the drop-down list.
Frequency	Select the amortize frequency from the drop-down list.
Cost / Fee	Select the cost / fee from the drop-down list.

Perform any of the Basic Actions mentioned in Navigation chapter.

4.17 Escrow

Oracle Financial Services Lending and Leasing provides tax and insurance escrow for loans. The Escrow screen contains subsection that allow you to set up these features.

This chapter explains the Escrow screen and how to set up escrow in the system.

4.17.1 Escrow

The Escrow Definition screen allows you to review or set up escrow definitions for taxes and insurance and note whether or not cushion is allowed.

Navigating to Escrow

1. On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Products > Escrow. The Escrow details can be setup across three subsections:

• Escrow
• Shortage/Cushion Rules
• Disbursement Rules

4.17.1.1 Escrow

To setup Escrow

1. Click Setup > Setup > Products > Escrow > Escrow.
2. In the Escrow Definitions section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Escrow	Specify the escrow code. This is protected against update and cannot be changed after initial set up.
Description	Specify the escrow description.
Escrow Type	Select the escrow type, usually insurances or taxes from the drop-down list.
Cushion Allowed	Check this box if the escrow you are defining allows for cushion. Note: Cushion rules are used to determine how much cushion should be retained.
Incl 1098	Check this box to include in 1098 reporting.
Enabled	Check this box to enable the escrow definition.

3. Perform any of the Basic Actions mentioned in Navigation chapter.

4.17.1.2 Shortage/Cushion Rules

In Shortage/Cushion Rules, you can review and set up escrow analysis shortage/cushion rules. Shortage/cushion rules determine how much cushion you are allowed on a particular escrow line and if there is a predicted shortage, how to eliminate it by increasing payment.

To setup Shortage/Cushion Rules

1. Click Setup > Setup > Products > Escrow > Shortage/Cushion Rules.
2. In the Rules section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Rule	Specify the rule code. This is protected against update and cannot be changed after initial set up.
Description	Specify the rule description.
Start Dt	Specify the start date for this rule. You can even select the date from the adjoining Calendar icon.
End Dt	Specify end date for this rule. You can even select the date from the adjoining Calendar icon.
Enabled	Check this box to enable the rule.
Parameters section
Shortage Threshold	Select the shortage threshold, either an amount or number of install­ments, from the drop-down list.
Shortage Value	Specify shortage threshold value.
Shortage Spread Increase%	Specify shortage spread increase percent.
Term	Specify shortage spread term.
Max Term	Specify the maximum amount of shortage spread terms.
Surplus Amt	Specify surplus threshold amount for this rule.
Company	Select the company for this rule from the drop-down list.
Branch	Select the branch for this rule from the drop-down list.
Product	Select the product for this rule from the drop-down list.
State	Select state for this rule (required). IMPORTANT: When you select which escrow rule to use, the system searches for a best match using the following attributes: 1. Company 2. Branch 3. Product 4. State Hence, the system recommends creating one version of each rule, where ALL is the value in these fields.

3. Perform any of the Basic Actions mentioned in Navigation chapter.
4. In the Rule Details section, perform any of the Basic Operations mentioned in Navigation chapter.

A brief description of the fields is given below:

Field:	Do this:
Escrow Type	Select escrow type from the drop-down list.
Cushion Type	Select cushion type from the drop-down list.
Cushion Value	Specify cushion value.

5. Perform any of the Basic Actions mentioned in Navigation chapter.

Note

While considering the cushion rules, preference is provided either for all records and then for Insurances or taxes maintained in a particular shortage or cushion rule.

4.17.1.3 Disbursement Rules

The Rules screen allows you to define the disbursement rules for your escrow.

To setup Disbursement Rules

1. Click Setup > Setup > Products > Escrow > Disbursement Rules.
2. In the Escrow Disbursement Rules section, perform any of the Basic Operations mentioned in Navigation chapter.

   

A brief description of the fields is given below:

Field:	Do this:
Disbursement Rule	Specify the disbursement rule. This is protected against the update and cannot be changed after initial set up.
Description	Specify the description.
Company	Select the company from the drop-down list.
Branch	Select the branch from the drop-down list.
Start Dt	Specify the start date. You can even select the date from the adjoining calendar icon.
End Dt	Specify the end date. You can even select the date from the adjoining calendar icon.
Enabled	Check this box to enable this disbursement rule.
Disbursement section
Jan%	Specify the percent to be disbursed in January.
Feb%	Specify the percent to be disbursed in February.
Mar%	Specify the percent to be disbursed in March.
Apr%	Specify the percent to be disbursed in April.
May%	Specify the percent to be disbursed in May.
Jun%	Specify the percent to be disbursed in June.
Jul%	Specify the percent to be disbursed in July.
Aug%	Specify the percent to be disbursed in August.
Sep%	Specify the percent to be disbursed in September .
Oct%	Specify the percent to be disbursed in October.
Nov%	Specify the percent to be disbursed in November.
Dec%	Specify the percent to be disbursed in December.
Total%	Displays total annual disbursement percentage. This figure is the sum of the monthly disbursements and must equal 100 per­cent .

3. Perform any of the Basic Actions mentioned in Navigation chapter.

Note

You cannot save the disbursement rule, if the Total% is not equal to 100.