Seed Data

This appendix covers the following topics:

Stream Purposes
Rules
Formulas
Workflows

Stream Purposes

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

Type - indicates the types of templates in which the Purpose can be used by book class.
1. ALL means the Purpose can be used in all stream generation templates with a product type of Financial Product.
2. LS means the Purpose can be used in stream generation templates with a product type of Financial Product and Book Class of Operating Lease, Direct Financial Lease, or Sales Type Lease.
3. LN means the Purpose can be used in stream generation templates with a product type of Financial Product and Book Class of Loan or Loan-Revolving.
4. INV means the Purpose can be used in stream generation templates with a product type of Investor Product.
Used By- User indicates the stream purpose is selected by the user during booking or other processes. System indicates the stream purpose is used by the system without being selected by the user.
Single or Multiple - Single means only one stream type with this purpose can be added to the stream generation template. Multiple means one or more stream types with this purpose can be added to the stream generation template.
Mandatory- indicates if the stream Purpose is mandatory on the type of stream generation template used.
Attributes- indicates whether a stream Purpose is Taxable, Billable, and can Capitalize.
Primary or Dependent- indicates whether a stream purpose is primary or dependent.
Depends On - for dependent stream purposes only, indicates the primary stream purpose to which the stream is dependent.

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:

Rule definition
Rule group definition
Rule values
Rule group values

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:

Master Lease Agreement
Vendor Agreements (Operating Agreements and Program Agreements)
Product
Contract Interface
Profile Options

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.