Skip Headers

Oracle Lease and Finance Management Implementation Guide
Release 12.1
Part Number E13577-05
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Seed Data

This appendix covers the following topics:

Stream Purposes

The following table shows seeded Lease Management stream purposes and contains columns for:

Lease Management Seeded Stream Type Purposes
Purpose Name Type Used By Single or Multiple Mandatory Attributes Primary or Dependent Depends On
Accounting ALL, INV User Multiple No Taxable = No
Billable = No
Capitalize = No
Primary  
Accrued Fee Expense ALL System Single for each expense No Taxable = No
Billable = No
Capitalize = No
Dependent Expense
Accrued Fee Income ALL System Single for each fee payment type No Taxable = No
Billable = No
Capitalize = No
Dependent Fee Payment - All Types except Income Fee Payment
Actual Income Accrual LN System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Rent
Actual Property Tax ALL System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Adjusted Property Tax ALL System Single No Taxable = Both
Billable = Yes
Capitalize = No
Dependent Actual Property Tax
Advance Rent ALL System Single for each rent Yes Taxable = Yes
Billable = Yes
Capitalize = No
Dependent Rent
Amortized Fee Expense ALL System Single for each expense No Taxable = No
Billable = No
Capitalize = No
Dependent Expense
Amortized Fee Income ALL System Single for each fee payment type No Taxable = No
Billable = No
Capitalize = No
Dependent Income Fee Payment
Billing Adjustment ALL System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Book Depreciation LS System Single No Taxable = No
Billable = No
Capitalize = No
Primary  
Cure ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Daily Interest - Interest LN System Single Yes Taxable = Both
Billable = No
Capitalize = No
Dependent Rent
Daily Interest - Principal LN System Single Yes Taxable = Both
Billable = No
Capitalize = No
Dependent Rent
Down Payment ALL User Multiple No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Estimated Property Tax ALL User Multiple No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Excess Interest Paid LN System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Dependent Rent
Excess Loan Payment Paid LN System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Dependent Rent
Excess Principal Paid LN System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Dependent Rent
Expense ALL User Multiple No Taxable = Yes
Billable = No
Capitalize = Yes, No, or Null
Primary  
Federal Depreciation LS System Single No Taxable = No
Billable = No
Capitalize = No
Primary  
Fee Payment ALL User Multiple No Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Fee Renewal LS System Single for each fee payment type No Taxable = Yes
Billable = Yes
Capitalize = No
Dependent Fee Payments - All Types
Float Factor Adjustment LS System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Dependent Rent
Funding ALL User Multiple Yes Taxable = Yes
Billable = No
Capitalize = No
Primary  
General Loss Provision ALL, INV User Multiple No Taxable = No
Billable = No
Capitalize = No
Primary  
Insurance Accrual Adjustment ALL System Single No Taxable = No
Billable = No
Capitalize = No
Primary  
Insurance Adjustment ALL System Single No Taxable = No
Billable = No
Capitalize = No
Primary  
Insurance Expense Accrual ALL System Single No Taxable = No
Billable = No
Capitalize = No
Primary  
Insurance Income Accrual ALL System Single No Taxable = No
Billable = No
Capitalize = No
Primary  
Insurance Payable ALL System Single No Taxable = Yes
Billable = No
Capitalize = No
Primary  
Insurance Receivable ALL System Single No Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Insurance Refund ALL System Single No Taxable = Yes
Billable = No
Capitalize = No
Primary  
Interest Catchup LN System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Dependent Rent
Interest Income LN System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Rent, Fee Payment
Interest Payment LN System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Dependent Rent, Fee Payment
Investor Contract Obligation Payable INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Disbursement Adjustment INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Evergreen Rent Payable INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Interest Income LN System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Interest Payable INV System Single No Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Late Fee Payable INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Late Interest Payable INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Payable INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Pre-tax Income LS System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Principal Payable INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Receivable INV System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Investor Rent Buyback INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Rent Disbursement Basis INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Rent Payable INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Rental Accrual LS System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Residual Buyback INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Residual Disbursement Basis INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Residual Payable INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Investor Variable Interest LN System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
Late Fee ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Late Interest ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Lease Income DF, ST System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Rent
Loan Payment LN System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Rent, Fee Payment
Pass-Through Expense Accrual ALL System Single for each Pass-Through Fee Type No Taxable = No
Billable = No
Capitalize = No
Dependent Pass-Through Fee
Pass-Through Fee ALL User   No Taxable = Yes
Billable = No
Capitalize = No
Primary  
Pass-Through Fee Renewal LS System Single for each Pass-Through Fee Type No Taxable = Yes
Billable = Yes
Capitalize = No
Dependent Pass-Through Fee
Pass-Through Renewal Rent LS System Single for each Rent Yes Taxable = Yes
Billable = Yes
Capitalize = No
Dependent Rent
Pass-Through Revenue Accrual ALL System Single for each Pass-Through Fee Type No Taxable = No
Billable = No
Capitalize = No
Dependent Pass-Through Fee
Pass-Through Service ALL System   No Taxable = Yes
Billable = No
Capitalize = No
Primary  
Pass-Through Service Expense Accrual ALL System Single for each Pass-Through Service Payment No Taxable = No
Billable = No
Capitalize = No
Dependent Service Pass-Through
Pass-Through Service Renewal LS System Single for each Pass-Through Service Payment No Taxable = Yes
Billable = Yes
Capitalize = No
Dependent Pass-Through Service
Pass-Through Service Revenue Accrual ALL System Single for each Pass-Through Service Payment No Taxable = No
Billable = No
Capitalize = No
Dependent Pass-Through Service
Pre-funding ALL User Multiple No Taxable = Yes
Billable = No
Capitalize = No
Primary  
Pre-funding Interest Payment ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Principal Balance LN System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Rent, Fee Payment
Principal Catchup LN System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Dependent Rent
Principal Payment LN System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Dependent Rent, Fee Payment
PV Rent LS System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Rent
PV Rent Securitized INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
PV RV LS System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Residual Value
PV RV Guaranteed LS System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Residual Value
PV RV Insured LS System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Residual Value
PV RV Securitized INV System Single Yes Taxable = No
Billable = No
Capitalize = No
Primary  
PV RV Unguaranteed LS System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Residual Value
PV RV Uninsured LS System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Residual Value
Quote Absorbed Fee   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Contract Obligation   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Contractual Fee   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Discount   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Estimated Billing Adjustment   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Estimated Property Tax   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Expense Fee   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Fee   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Financed Fee   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote General Fee   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Income Fee   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Miscellaneous   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Miscellaneous Fee   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Pass-Through Fee   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Per Diem LN, LS System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Principal Balance   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Purchase Amount   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Repurchase Sale Price ALL System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Return Fee   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Rollover Incentive   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Service and Maintenance   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Termination Penalty   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Quote Unbilled Receivables   System Single No Taxable = Both
Billable = Yes
Capitalize = No
Primary  
Renewal Property Tax LS System Single for each Estimated Property Tax No Taxable = Yes
Billable = Yes
Capitalize = No
Dependent Estimated Property Tax
Renewal Rent LS System Single for each Rent Yes Taxable = Yes
Billable = Yes
Capitalize = No
Dependent Rent
Rent ALL User Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Rent Accrual OP System Single for each Rent Yes Taxable = No
Billable = No
Capitalize = No
Dependent Rent
Repair Charge ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Residual Guaranteed LS System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Residual Value
Residual Value LS System Single Yes Taxable = No
Billable = Yes
Capitalize = No
Primary  
Residual Value Insurance Premium LS System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Residual Value
Security Deposit ALL User Multiple No Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Expense ALL System Multiple No Taxable = No
Billable = No
Capitalize = No
Primary  
Service Fee - Amortization Schedule ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - Audit Letter ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - Document Request ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - Exchange Request ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - General ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - Interest Conversion ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - Invoice On Demand ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - Invoice Reprint ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - Payment Change ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - Restructure Request ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - Termination Request ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - Transfer Request ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - Variable Rate Statement ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Fee - VAT Schedule ALL System Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Income ALL System Single for each Service Payment No Taxable = No
Billable = No
Capitalize = No
Dependent Service Payment
Service Payment ALL User Multiple No Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Service Renewal ALL System Single for each Service Payment No Taxable = Yes
Billable = Yes
Capitalize = No
Dependent Service Payment
Specific Loss Provision ALL, INV User Multiple No Taxable = No
Billable = No
Capitalize = No
Primary  
State Depreciation LS System Single No Taxable = No
Billable = No
Capitalize = No
Primary  
Stip Loss Value LS System Single No Taxable = No
Billable = No
Capitalize = No
Dependent Rent
Subsidy ALL User Multiple No Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Subsidy Income ALL System Single for each Subsidy No Taxable = No
Billable = No
Capitalize = No
Dependent Subsidy
Termination Value LS System Single No Taxable = No
Billable = No
Capitalize = No
Dependent Rent
Unscheduled Loan Payment LN System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Dependent Rent
Unscheduled Principal Payment LN System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Dependent Rent
Usage Payment ALL System Single No Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Variable Income Non-Accrual LN System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Variable Interest
Variable Interest LN User Single Yes Taxable = Yes
Billable = Yes
Capitalize = No
Primary  
Variable Interest Income LN System Single Yes Taxable = No
Billable = No
Capitalize = No
Dependent Variable Interest
Variable Interest Schedule LN System Single No Taxable = No
Billable = No
Capitalize = No
Primary  
Variable Loan Payment LN System Single Yes Taxable = Both
Billable = Yes
Capitalize = No
Dependent Rent
Vendor Residual Sharing LS User Single No Taxable = Yes
Billable = No
Capitalize = No
Primary  

Rules

The Oracle Contracts rules architecture is part of the Oracle Contracts Core contract structure and works in combination with the contract header and lines. Rules are a structured presentation of contract terms and conditions. How the data relate to the contract determines whether the data are captured as a rule or in the header-line structure. In general, rules govern the operation or procedures and processes performed on contract headers, lines, or sub-lines.

For example, a rule can specify a number of days that should elapse between transaction events for a contract. This rule is checked by the process against the first transaction date before picking up the contract and processing it for the second transaction.

Rules comprise four basic components:

Once defined, the rule and rule group definitions are referenced when the rule and rule group values are assigned in the rule tables (OKC_RULES_B and OKC_RULE_GROUPS_B) that correspond to a contract, contract line, or sub-line.

A variety of sources can assign the rule and rule group values, including:

The following table lists all the seeded rules in Oracle Lease Management.

Seeded Rules Used in Oracle Lease Managementruleslist of seeded
Rule Group Rule Group Meaning Rule Name Rule Meaning Rule Component Description Value Set or Source
AMTFOC End of Term Purchase Option, Contract AMTINV Automat-ically Invoice for Fixed Purchase Option RULE_INFORMATION1 Automat-ically Process Fixed Purchase Option Y/N
LABKCL Book Class LABKCL Book Class RULE_INFORMATION1 Book Class FND
LAEVEL Evergreen Eligibility LAEVEL Evergreen Eligibility RULE_INFORMATION1 Eligible for Evergreen Y/N
LAFCTG Factoring LAFCTG Factoring RULE_INFORMATION1 Factoring Date Date Value
LAFCTG Factoring LAFCTG Factoring RULE_INFORMATION2 Factoring Percentage Entered Value
LAFCTG Factoring LAFCTG Factoring RULE_INFORMATION3 Factoring Discount Rate Entered Value
LARNOP Renewal Option LAREND Renewal Notice Days RULE_INFORMATION1 Renewal notice days Entered Value
LARNOP Renewal Option LARNEW Renewal Options RULE_INFORMATION1 Renewal option FND
LARNOP Renewal Option LARNEW Renewal Options RULE_INFORMATION2 Renewal amount Entered Value
LASDEP Security Deposit LASDEP Security Deposit RULE_INFORMATION2 Sec Dep Held until maturity Y/N
LASDEP Security Deposit LASDEP Security Deposit RULE_INFORMATION4 Net Sec Dep from Sale proceeds Y/N
LASDEP Security Deposit LASDEP Security Deposit RULE_INFORMATION5 Sec Dep Held until date Date Value
LATROP Termination Options LAEOTR End of Term Options RULE_INFORMATION1 End of term option FND
LATROP Termination Options LAEOTR End of Term Options RULE_INFORMATION2 End of Term Amount Entered Value
LATROP Termination Options LAMITR Mid Term Options RULE_INFORMATION1 Mid Term Option FND
LATROP Termination Options LAMITR Mid Term Options RULE_INFORMATION2 Mid Term Amount Entered Value
LATOWN Tax Owner LATOWN Tax Owner RULE_INFORMATION1 Tax Owner (for deal) FND

Formulas

The following table lists formulas that are part of the Oracle Lease Management seed data:

Seeded Formulas in Oracle Lease Management
Formula Name Description Calculation Parameters
LINE_OEC Calculates the OEC Price per unit * no of units Contract id (mandatory) + Line id (optional)
CONTRACT_SUMOF_RENTS Sum of rents Sum of amounts on stream type - Rent. Use this formula on the booking transaction type template. ?
CONT_RBK_UNBILL_RECEIVABLES Sum of unbilled rents Sum of rent not billed for all active assets on a lease contract. Use this formula on the rebook transaction type. The amount calculation for this formula and the CONTRACT_SUMOF_RENTS formula together gives the correct accounting amounts for the rebook transactions. ?
LINE_RESIDUAL_VALUE Calculates the RV Residual Value per unit Contract id (mandatory) + Line id (mandatory)
CONTRACT_RESIDUAL_VALUE Calculates the RV Residual Value for the contract Contract id (mandatory)
CONTRACT_OEC Contract Capitalized Amount Sum of capitalized amount of all asset lines Contract id (mandatory)
CONTRACT_TRADEIN Sum of Trade Ins Sum of all trade ins from financial asset lines Contract id (mandatory)
LINE_TRADEIN Trade in amount for a line Trade in amount for the asset line Contract id (mandatory) + Line id (mandatory)
CONTRACT_CAPREDUCTION Sum of Capital Reduction Sum of capital reduction of all asset lines Contract id (mandatory)
LINE_CAPREDUCTION Capital Reduction of a line Capital reduction amount for the asset line Contract id (mandatory) + Line id (mandatory)
CONTRACT_FEESCAPITALIZED Sum of Capitalized Fees Sum of capitalized fees lines Contract id (mandatory)
LINE_FEESCAPITALIZED Capitalized Fees for line Capitalized fees for the asset line Contract id (mandatory) + Line id (mandatory)
CONTRACT_CAP_AMNT Total financed amount OEC-Trade in - Cap Reduction + Cap Fees Contract id (mandatory)
LINE_CAP_AMNT Financed amount for line OEC-Trade in - Cap Reduction + Cap Fees Contract id (mandatory) + Line id (mandatory)
CONTRACT_AMNT_PREFNDED Amount pre-funded Sum of all approved requests for specific contract where type = prefunding Contract id (mandatory)
CONTRACT_TOT_FNDED Total funded amount Sum of all approved requests for specific contract Contract id (mandatory)
CONTRACT_TOT_DEBITS Total negative fundings Sum of all approved requests for specific contract where amount is negative (A/P debits) Contract id (mandatory)
CONTRACT_TOT_CRDT_LMT Total credit limit Sum of all credit limit (contract line) for specific contract entity scs_code = 'CREDITLINE_CONTRACT 'Contract id (mandatory)
CONTRACT_CRDT_RMNG Balance credit limit Sum of all credit limit (contract line) for specific contract cs_code = 'CREDITLINE_CONTRACT' and subtract from Funding total Contract id (mandatory)
CONTRACT_TOT_CRDT_NEW_LMT New credit limit Sum of all credit new limit (contract line) for specific contract scs_code = 'CREDITLINE_CONTRACT Contract id (mandatory)
CONTRACT_TOT_CRDT_ADDN Additional credit limit Sum of all credit addition (contract line) for specific contract scs_code = 'CREDITLINE_CONTRACT Contract id (mandatory)
CONTRACT_TOT_CRDT_REDN Reduction in credit limit Sum of all credit addition (contract line) for specific contract scs_code = 'CREDITLINE_CONTRACT Contract id (mandatory)
AM_UNBILLED_RECEIVABLES Future Dues for a lease Sum of unbilled rents (at present value) - advance rent Contract id (mandatory)
AMCTOC Principal Balance for a loan Principal Balance Contract id (mandatory)
AM_DISCOUNT_RATE Discount Rate Original Capitalized Cost * (-0.1) Contract id (mandatory)
AM_QUOTE_FEE Quote Fee Original Capitalized Cost * 0.1 Contract id (mandatory)
AM_RETURN_FEE Return Fee Original Capitalized Cost * 0.1 Contract id (mandatory)
AM_ROLLOVER_INCENTIVE Rollover Incentive Original Capitalized Cost * 0.1 Contract id (mandatory)
AM_SECURITY_DEPOSIT Security Deposit refundable Balance Security Deposit Amount Contract id (mandatory)
AM_TERMINATION_PENALTY Termination Penalty Original Capitalized Cost * 0.1 Contract id (mandatory)
AM_ESTIMATED_PROPERTY_TAX Estimated Property Tax Estimated Property Tax Contract id (mandatory)
VARIABLE_INCOME_ACCRUAL Variable Income Amount Principal * Interest Rate * No of days to accrue / No of days in a year Contract id (mandatory)
LP_NET_INVESTMENT_VALUE Balance investment on contract Operating Lease - Net Book Value, DF Lease - Net Investment Value and Loan - Principal Balance Contract id (mandatory)
CS_ADVANCE_RENT Advance Rent Advance Rent Contract id (mandatory)
CS_SECURITY_DEPOSIT Security Deposit Security Deposit Contract id (mandatory)
CS_NET_INVESTMENT Net Investment Rent + Residual Value - Unearned Income Contract id (mandatory)
NET_GAIN_LOSS_QUOTE Net Gain/Loss The net gain loss resulting from a termination quote N/A

Workflows

The following table lists workflows that are part of the Oracle Lease Management seed data:

Seeded Workflows in Oracle Lease Management
Workflow Name File Name Functional Area Description
OKL CS Equipment Exchange. OKLCSEQU.wft Lease Center This work flow is used in equipment exchange to exchange the equipment in the background after getting the necessary approvals.
OKL CS Transfer Assumption Request OKLCSTRQ.wft Lease Center This work flow is used to carry out a Transfer and Assumption Request after receiving the appropriate approvals.
OKL CS Billing Correction Request. OKLCSBCW.wft Lease Center This work flow is used for Billing Correction Request to notify an Administrator about any corrections.
OKL CS Billing Refund Request. OKLCSBRW.wft Lease Center This work flow is used for Billing Refund Request to notify an Administrator about any Refunds.
OKL CS Convert Interest Type OKLCSCIT.wft Lease Center This work flow is used to notify an Administrator about any changes in the interest types.
OKL CS Contract Lease Renewal. OKLCSKLR.wft Lease Center This work flow is used for lease renewals.
OKL Stream Generation - Outbound OKLSTOUT.wft Authoring Workflow to start an out-bound transaction with Pricing Engine for Streams Generation. Steps: 1. Receive raised Business Event to send out bound xml message. 2. Call ECX api to check for validity of the generated document. 3. Report Error if applicable. 4. Call ECX API to send the document.
OKL Stream Generation - Inbound OKLSTIN.wft Authoring Workflow to start an in-bound transaction coming from Pricing Engine for Streams Generation. Steps: 1. Capture the business event for Inbound xml message. 2. Process Stream Results.
OKL - IN Gather Third Party Insurance Information OKLININF.wft Authoring To gather third-party information when customer fails to provide insurance proof, and the lessor cannot sell insurance.
Lease Account Generator OKLFLXWF.wft Accounting You can use this workflow to generate account combinations instead of the seeded sources.
Approve Contract Portfolio OKLAMATK.wft Asset Management This workflow routes the contract portfolio for approval.
Notify Contract Portfolio Execution OKLAMCPE.wft Asset Management This workflow notifies the remarketer for the contract portfolio execution.
Approve Restructure OKLAMRQT.wft Asset Management This workflow routes the restructure for approval.
Approve Gain / Loss OKLAMGAL.wft Asset Management This workflow routes the gain / loss on termination for approval.
Approve Partial Quote OKLAMPAR.wft Asset Management This workflow routes partial quotes for approval.
Shipping Instructions OKLAMNSI.wft Asset Management This workflow is used to inform the shipping details for an asset.
Notify Internal Transport Department OKLAMNTD.wft Asset Management This workflow is used to inform the internal transport department the shipping details for an asset.
Send Quote OKLAMNQT.wft Asset Management This workflow is used to send a quote.
Repurchase Acceptance OKLAMRAC.wft Asset Management This workflow informs user(s) of the acceptance of a repurchase quote.
Termination Quote Acceptance OKLAMPPT.wft Asset Management This workflow informs user(s) of the acceptance of a termination quote.
Restructure Quote Acceptance OKLAMRQT.wft Asset Management This workflow informs user(s) of the acceptance of a restructure quote.
Notify Remarketer OKLAMNRM.wft Asset Management This workflow informs the remarketing team of a new asset assignment
Notify Collections OKLAMNCO.wft Asset Management This workflow informs the collections agent of updates on returns in the case of a repossession.
Notify Repossession Agent OKLAMNRA.wft Asset Management This workflow informs the external repossession agent of a new repossession request.
Notify Provider OKLAMNPR.wft Asset Management This workflow informs the provider of service and/or maintenance of the asset return.
Asset Repair OKLAMAAR.wft Asset Management This workflow routes asset repair requests for approval.
Request Title Return OKLAMRTR.wft Asset Management This workflow requests the 3rd party title holder to return the title on the expiration of the contract.
Remarketing Order Cycle OKLAMROM.wft Asset Management This workflow defines the order cycle in Order Management for remarketed assets.
Credit Application Request OKLSOCAR.wft Sales and Origination Notifies the Lease Credit Analyst of credit request recommendations from Oracle Credit Management.