4.6 Pricings
The Pricing screen records pricing information related to your products. the system uses the information in the Pricing Definition section to identify the correct pricing for an application, depending upon the product and the specific application parameters. the system will always search for a unique match.
When you choose the Select Pricing while making a decision on the Underwriting window, the system displays the best match and completes the Pricing and Approved sections under Summary sub tab. The information in the Approved section cite the minimum amounts for the selected product, though the user can edit these figures.
The system determines the best match by looking at all enabled pricing strings on the Pricing screen that meet the following criteria:
- Exactly match the application values for the Promotion and Billing Cycle fields.
- Are less than or equal to the application values for the Term, Amount, Age, and Start Date fields.
- Match either the application value or ALL for all other criteria.
Exact matches for each field are given a higher weight than matches of ALL. The returned rows are then ranked based on the weighted values and the hierarchical position of the field (see above). They are then ranked by start date. The system recognizes the first row returned as the best match.
Note:
- You should set up a default pricing for each billing cycle and pricing that the system can select to ensure error-free performance. Oracle Financial Services Software recommends creating a single version of each edit type, where ALL is the value in the selection criteria fields listed above. If the system cannot find a pricing match, it will display an error message.
- The system supports the bulk uploading of product pricing setup data. This allows you to upload multiple setup data, avoid re-entering setup data, and more importantly, reduce data entry mistakes. The system currently supports uploading using a fixed-length format only, where each data is at a pre-fixed position. You can run batch jobs with the Set Code SET-BLK to upload pricing and GL data.
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
- LOC_BILL_CYCLE_CD - for Line of Credit accounts
To set up the Pricing
- On the Oracle Financial Services Lending and Leasing home screen, click Setup > Setup > Administration > User > Products > Pricings > Line.
- In the Pricing Definition section, perform any of the Basic Operations mentioned in Navigation chapter.
A brief description of the fields is given below:
Table 4-16 Pricing Definition
Field Do this Pricing* Specify the code for the pricing. Description* Specify the description for the pricing. * Together these two fields define the name of the pricing. Start Dt Specify the start date for this pricing. You can even select the date from the adjoining Calendar icon. End Dt Specify the end date for this pricing. You can even select the date from the adjoining Calendar icon. Enabled Check this box to enable the pricing. Result section Draw Period Specify the draw term for which this pricing is valid. Repmt Period Specify the repayment term for which this pricing is valid. Max Credit Specify the maximum credit Limit for this pricing. Index Select the index type associated as FLAT/PRIME RATE from the drop-down list. Margin From Specify the minimum margin rate for the selected index type. Margin To Specify the maximum margin rate for the selected index type. Maturity Index Select the maturity index type associated as FLAT/PRIME RATE from the drop-down list. Maturity Margin Rt From Specify the minimum margin rate for the selected maturity index type. Maturity Margin To Specify the maximum margin rate for the selected maturity index type. Selection Criteria Company Select the portfolio company for this pricing, from the drop-down list. This may be ALL or a specific company. Branch Select the portfolio branch for this pricing. This may be ALL or a specific branch. (This must be ALL if in the Company field you selected ALL), from the drop-down list. Billing Cycle Select the billing cycle for this pricing, from the drop-down list. Product Select the product for this pricing, 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 and the product setup. State Select the state for this pricing, from the drop-down list. This may be ALL or a specific state. Pro Group Select the producer group for this pricing, from the drop-down list. This may be ALL or a specific producer group. Pro Type Select the producer type for this pricing, , from the drop-down list. This may be ALL or a specific producer type. Producer Region Select the region of the producer. Producer Territory Select the territory of the producer. Producer Select the producer from the drop-down list. This may be ALL or a specific producer. The available values come from a validated field based on the product group and product type. Grade Select the credit grade for this pricing, from the drop-down list. This may be ALL or a specific grade. Credit Limit Specify the minimum credit limit for which this pricing is valid. Asset Class Select the asset class 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. You may create additional user-defined lookup codes for these lookup types as needed. Asset Type Select the asset type from the drop-down list. This may be ALL or a specific asset type. The available values come from a validated field based your assets setup. SubType Select the asset sub type from the drop-down list. This may be ALL or a specific asset sub type. The available values come from a validated field based your assets setup, and is linked to the selected asset type. Asset Make Select the asset make from the drop-down list. The available values come from a validated field based your assets setup and is restricted based on the selected Asset Type and Asset Sub Type. For example, 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 Select the asset model from the drop-down list. The available values come from a validated field based your assets setup, and is restricted based on the selected Asset Type and Asset Sub Type. If ALL was selected for either Asset Type or Asset Sub Type, then ALL will be the only available selection for the asset model. Age Specify the asset age (the minimum age for the selected pricing).
Note: If your entry in this field is based on the number of years of age of the asset and not the actual year of make, you must update this entry annually to ensure that the proper pricing is available.
Trade-In Specify if there is a trade in of an asset by selecting Yes/No. Mileage If there is a Trade-In of an existing asset, then specify its mileage in km. Currency Select the currency for this pricing, from the drop-down list. Promotion Select the promotion applicable to this pricing from the dropdown list. The available values come from a validated field based on the promotions setup. Asset Value Specify the asset value. LTV Specify the loan to value ratio. Existing Customer Select one of the following options from the drop-down list to define the applicability of the current pricing definition:
ALL - Applicable to both existing and new customers
YES - Applicable to existing customer only
NO - Applicable to new customer only.
Based on the selection criteria, system defaults the first pricing for applications with Existing customer flag = Y at primary applicant details.
Existing Customer Since (In Years) Specify the duration from when customer account was created in the system up to the current date in years. Selection Criteria : Business - allows you to indicate the age of business by evaluating the total number of years elapsed. Years In Business Specify the total number of years in business. - Perform any of the Basic Actions mentioned in Navigation chapter.
Parent topic: Product