LNS — Loans
38 documented tables · 23 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
LNS_LOAN_HEADERS_ALL |
Loans Header Table | satellite-leaning |
LNS_LOAN_PRODUCTS_ALL |
Loan Product Setup Table | hub-leaning |
LNS_EVENTS |
This table stores actionable events for a loan class | hub-leaning |
LNS_ASSETS |
LNS_ASSETS is used to store the assets of a loan participant. | satellite-leaning |
LNS_LOAN_PRODUCT_LINES |
Loan Product Setup Lines Table | satellite-leaning |
LNS_EVENT_ACTIONS |
This table stores actionable events for a Loan type and loan class | satellite-leaning |
LNS_CONDITIONS |
Loan Conditions Table | hub-leaning |
LNS_FEE_ASSIGNMENTS |
Loan Fees Assignment Table | satellite-leaning |
LNS_PARTICIPANTS |
Loan Participants Table | link |
LNS_DEFAULT_DISTRIBS_ALL |
Loans Default Distributions Table - This table establishes the accounting to default for loans and fees. The | link |
LNS_AMORTIZATION_LINES |
Amortization Lines reprensents the details of any give Amortization represented on the Amortization Schedules | link |
LNS_FEES_ALL |
Loan Fees Setup Table | standalone |
LNS_LOAN_PRODUCT_FLAGS |
Loan Product Setup Read-Only Column Names Table | satellite-leaning |
LNS_LOAN_DOCUMENTS |
This table stores all the documents related to a Source Object | standalone |
LNS_LOAN_TYPES |
Loan Types Setup Table | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
LNS_UTILITY_PUB |
PUB | 33 | 38 packages |
LNS_LOAN_HEADER_PUB |
PUB | 4 | 14 packages |
LNS_BILLING_UTIL_PUB |
PUB | 22 | 11 packages |
LNS_FUNDING_PUB |
PUB | 40 | 9 packages |
LNS_TERMS_PUB |
PUB | 9 | 8 packages |
LNS_LOAN_HISTORY_PUB |
PUB | 2 | 8 packages |
LNS_BILLING_BATCH_PUB |
PUB | 27 | 6 packages |
LNS_CUSTOM_PUB |
PUB | 22 | 6 packages |
LNS_DISTRIBUTIONS_PUB |
PUB | 36 | 5 packages |
LNS_FEE_ASSIGNMENT_PUB |
PUB | 9 | 4 packages |