Results for “loan_payment_frequency”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

LNS_SYSTEM_OPTIONS_ALL is the Loans (LNS) module's system options table in Oracle E-Business Suite, holding the configuration records that define how loan processing behaves for a given operating unit. Each row represents a set of loan-processing defaults and controls, including accounting rules, interest and fee handling, transaction type mappings, and batch processing context. Because the table name carries the _ALL suffix, it is organized by operating unit through the ORG_ID column, which is enforced by the unique index LNS_SYSTEM_OPTIONS_U2. The table is owned by the LNS schema and is documented as VALID at 67 columns in the 12.2.2 reference; the same object exists in 12.1.1.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a link classification. The table's defining role is to associate operational reference data — receivables transaction types, batch sources, ledgers, organizations, and receivables transaction identifiers — with a per-operating-unit configuration record, which is characteristic of a link entity rather than a standalone hub.

Key Information Stored

The surrogate primary key of the table is SYSTEM_OPTION_ID, uniquely enforced by the index LNS_SYSTEM_OPTIONS_U1. The second unique index, LNS_SYSTEM_OPTIONS_U2, is defined on ORG_ID and therefore acts as the business-key candidate at the operating-unit grain. Notable configuration columns include:

• ORG_ID — the operating unit that owns the option record; the decisive context for every lookup.
• SET_OF_BOOKS_ID — the ledger (GL_SETS_OF_BOOKS_11I) used for loan accounting.
• TRX_TYPE_ID, INTEREST_TRX_TYPE_ID, FEE_TRX_TYPE_ID — receivables transaction types (RA_CUST_TRX_TYPES_ALL) used for principal, interest, and fee transactions.
• BATCH_SOURCE_ID — the receivables batch source (RA_BATCH_SOURCES_ALL) applied to generated loan transactions.
• RECEIVABLES_TRX_ID — the receivables transaction identifier used for loan activity.
• GL_ACCT_REVENUE_INTEREST, GL_ACCT_REVENUE_PRINCIPAL, GL_ACCT_REVENUE_OTHER — revenue accounting flexfield assignments for interest, principal, and other income.
• DAY_COUNT_METHOD, COMPOUNDING_FREQUENCY, CALCULATION_METHOD — the core interest calculation conventions.
• LOAN_PAYMENT_FREQUENCY, PAYMENT_IN_ARREARS_FLAG, RATE_ROUNDING, PAYMENT_AMOUNT_ROUNDING — scheduling and rounding behavior.
• LOAN_CURRENCY, LOAN_CLASS_CODE, LOAN_TYPE, LOAN_SUBTYPE, ORIGINAL_TERM, ORIGINAL_TERM_TYPE — loan classification and term defaults.
• DELINQUENCY_THRESHOLD_NUMBER, DELINQUENCY_THRESHOLD_AMOUNT, DAYS_TOBILL_BEFORE_DUE_DATE, DAYS_TOGL_AFTER_DUE_DATE — delinquency and billing/GL timing controls.
• ATTRIBUTE_CATEGORY through ATTRIBUTE20, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER — the standard EBS descriptive flexfield and audit/OA framework columns.

Common Use Cases and Queries

The table is typically queried to resolve loan-processing defaults for an operating unit before creating or processing a loan. A representative pattern joins the option row to its reference tables:

• Resolve transaction types and batch source for an operating unit: select t.name trx_type, i.name interest_type, b.name batch_source from lns_system_options_all o, ra_cust_trx_types_all t, ra_cust_trx_types_all i, ra_batch_sources_all b where o.org_id = :p_org_id and o.trx_type_id = t.cust_trx_type_id and o.interest_trx_type_id = i.cust_trx_type_id and o.batch_source_id = b.batch_source_id.
• Confirm the ledger and revenue accounts applied to loans: join SET_OF_BOOKS_ID to GL_SETS_OF_BOOKS_11I and report GL_ACCT_REVENUE_INTEREST, GL_ACCT_REVENUE_PRINCIPAL, and GL_ACCT_REVENUE_OTHER.
• Audit interest conventions across operating units: return ORG_ID with DAY_COUNT_METHOD, COMPOUNDING_FREQUENCY, and CALCULATION_METHOD.
• Locate organization context: join ORG_ID to HR_ALL_ORGANIZATION_UNITS, and use LNS_SYSTEM_OPTIONS_U2 for direct keyed access by operating unit.

Related Objects

• RA_CUST_TRX_TYPES_ALL — referenced three times (TRX_TYPE_ID, INTEREST_TRX_TYPE_ID, FEE_TRX_TYPE_ID).
• RA_BATCH_SOURCES_ALL — via BATCH_SOURCE_ID.
• GL_SETS_OF_BOOKS_11I — via SET_OF_BOOKS_ID.
• HR_ALL_ORGANIZATION_UNITS — via ORG_ID.
• CS_SYSTEM_OPTIONS — via SYSTEM_OPTION_ID.
• AR_RECEIVABLES_TRX_ALL — via RECEIVABLES_TRX_ID.
• The LNS loan-processing concurrent programs and APIs that read these options at loan creation and payment processing time.