My Oracle Support Banner

How to find the Query/table/view Information For OLFM Setup (Doc ID 2347983.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Lease and Finance Management - Version 12.2.6 and later
Information in this document applies to any platform.


Need to generate a query to obtain the OLFM setup data values from the database.

The data required is from Menu > Oracle Lease and finance Management > Setup

Provide the tables involved on this screen.

Setup >Pricing > Stream Types

Setup >Pricing > Stream Generation Template

Setup > Formulas > Functions

Setup > Formulas > Operands

Setup > Formulas > Formulas

Lease > Setup > Accounting > Accounting Templates > Create Accounting

Template Set (B)

Lease > Setup > Accounting > Products > Product Templates (B)

Setup > Products > Products



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.