OKL — Lease and Finance Management
415 documented tables · 928 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
OKL_TRX_TYPES_B |
Transaction types | hub |
OKL_K_HEADERS |
Oracle Lease Management shadow table for Oracle Contracts Core header tables, OKC_K_HEADERS_B and OKC_K_HEAD | hub-leaning |
OKL_SUBSIDY_POOLS_B |
This table stores subsidy pools data | hub-leaning |
OKL_FE_ADJ_MAT_ALL_B |
Pricing adjustment matrix header table | hub-leaning |
OKL_K_LINES |
Oracle Lease Management shadow table for Oracle Contracts Core line tables, OKC_K_LINES_B and OKC_K_LINES_TL. | hub-leaning |
OKL_STRM_TYPE_B |
Holds the definition of payment types. | hub |
OKL_PRODUCTS |
Define the financial treatment for the contract. | hub |
OKL_FE_RESI_CAT_ALL_B |
Residual Category Set Base | hub |
OKL_VP_CHANGE_REQUESTS |
Change request table for Vendor Agreements | hub-leaning |
OKL_CONTEXT_GROUPS_B |
Grouping of list of parameters required by the Formulae. | hub-leaning |
OKL_FORMULAE_B |
Definition of formulae. It also holds the context group required by the formula | hub |
OKL_INVOICE_TYPES_B |
The "type" of invoice in terms of which transactions, stream types, cash flows will be grouped onto the invoic | satellite-leaning |
OKL_INVC_LINE_TYPES_B |
The "type" of invoice line in terms of which transactions, stream types, cash flows will be grouped into the i | hub-leaning |
OKL_TRX_QUOTES_ALL_B |
Termination, restructure or repurchase quotes | hub |
OKL_SUBSIDIES_ALL_B |
This table stores subsidy setups. | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
OKL_API |
API | 7 | 1197 packages |
OKL_DEBUG_PUB |
PUB | 8 | 205 packages |
OKL_RULE_PUB |
PUB | 74 | 71 packages |
OKL_CONTRACT_PUB |
PUB | 38 | 58 packages |
OKL_EXECUTE_FORMULA_PUB |
PUB | 2 | 55 packages |
OKL_TRX_CONTRACTS_PUB |
PUB | 23 | 40 packages |
OKL_CONTRACT_STATUS_PUB |
PUB | 4 | 37 packages |
OKL_STREAMS_PUB |
PUB | 25 | 34 packages |
OKL_TRX_ASSETS_PUB |
PUB | 10 | 27 packages |
OKL_ACCOUNT_DIST_PUB |
PUB | 6 | 25 packages |