Results for “okl_ae_line_type”
30 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.OKL_ACC_GEN_RULES_V is a reporting and integration view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that exposes the accounting generation rules used by Oracle Lease and Finance Management (OKL). Accounting generation rules determine how the OKL accounting engine derives accounting events and journal entries for lease and finance contracts. Each row in the view represents a single accounting generation rule line, keyed by an accounting event line type (AE_LINE_TYPE) and scoped to a specific set of books (ledger). The view joins the base rules table to the General Ledger ledgers view so that consumers receive both the internal ledger identifier and its user-facing name, and it resolves the stored lookup code for the accounting event line type into a translated meaning. This makes the view directly usable in concurrent programs, BI Publisher reports, Discoverer workbooks, and interface extracts without requiring the caller to perform the lookup join or ledger name resolution independently.
Underlying Base Objects
The view is defined over three documented object references:
- OKL_ACC_GEN_RULES (SYNONYM) — the base table holding accounting generation rule rows. It supplies the row identity, version number, event line type, ledger identifier, operating unit identifier, and audit columns.
- GL_LEDGERS_PUBLIC_V (VIEW) — the public General Ledger ledgers view, joined on
LEDGER_ID = SET_OF_BOOKS_IDto supplySET_OF_BOOKS_NAME. - OKL_ACCOUNTING_UTIL (PACKAGE) — invoked through the function
GET_LOOKUP_MEANING('OKL_AE_LINE_TYPE', ...)to translate the storedAE_LINE_TYPEcode into a readable meaning.
Because the definition uses an inner join against GL_LEDGERS_PUBLIC_V, only rules whose set of books resolves to a current ledger are returned. The view is read-only from the perspective of consumers; no DML is permitted through it, and the underlying data must be maintained through the OKL setup and accounting generation rule maintenance flows.
Key Columns
- ROW_ID — the ROWID of the underlying OKL_ACC_GEN_RULES row.
- ID — primary key of the accounting generation rule row.
- OBJECT_VERSION_NUMBER — optimistic locking version, incremented on each update.
- AE_LINE_TYPE — the accounting event line type code that the rule applies to; this is the column most commonly searched, often under the lookup type name
OKL_AE_LINE_TYPE. - ACCT_LINE_TYPE_MEANING — the user-facing meaning of
AE_LINE_TYPE, derived at query time via OKL_ACCOUNTING_UTIL. - SET_OF_BOOKS_ID / SET_OF_BOOKS_NAME — the ledger identifier and its display name from GL_LEDGERS_PUBLIC_V.
- ORG_ID — the operating unit that owns the rule, used for multi-org security filtering.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.
Common Use Cases and Queries
The view is typically queried to audit rule configuration across ledgers, to drive accounting event processing diagnostics, and to support report extracts. A common pattern filters on the accounting event line type and operating unit:
- Locate rules by event line type:
SELECT id, ae_line_type, acct_line_type_meaning, set_of_books_name, org_id FROM apps.okl_acc_gen_rules_v WHERE ae_line_type = :p_line_type; - List all rules for one ledger:
SELECT id, ae_line_type, acct_line_type_meaning FROM apps.okl_acc_gen_rules_v WHERE set_of_books_id = :p_sob_id ORDER BY ae_line_type; - Resolve a code to its meaning:
SELECT DISTINCT ae_line_type, acct_line_type_meaning FROM apps.okl_acc_gen_rules_v; - Audit recent changes:
SELECT id, ae_line_type, last_updated_by, last_update_date FROM apps.okl_acc_gen_rules_v WHERE last_update_date > SYSDATE - 30;
When filtering by operating unit, callers should apply the appropriate ORG_ID predicate or rely on MOAC (multi-org access control) through the supporting security profile, as the view itself does not enforce organization security.
-
Accounting Entry Line Type
-
Accounting Entry Line Type
-
View: OKL_ACC_GEN_RULES_V 12.2.2
Account generator rule header
APPS.OKL_ACC_GEN_RULES_V·↳ GL_LEDGERS_PUBLIC_V·↳ OKL_ACCOUNTING_UTIL·↳ OKL_ACC_GEN_RULES·Explore OKL module →
-
VIEW: APPS.OKL_AEL_SL_V 12.2.2
-
View: OKL_ACC_GEN_SRC_MAP_UV 12.1.1
APPS.OKL_ACC_GEN_SRC_MAP_UV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AG_SOURCE_MAPS·Explore OKL module →
-
View: OKL_ACC_GEN_RULES_V 12.1.1
Account generator rule header
APPS.OKL_ACC_GEN_RULES_V·↳ GL_LEDGERS_PUBLIC_V·↳ OKL_ACCOUNTING_UTIL·↳ OKL_ACC_GEN_RULES·Explore OKL module →
-
VIEW: APPS.OKL_AEL_SL_V 12.1.1
-
APPS.OKL_TRX_DISTRIBUTION_UV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AE_TEMPLATES_ALL·↳ OKL_TRNS_ACC_DSTRS·Explore OKL module →
-
APPS.OKL_TRX_DISTRIBUTION_UV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AE_TEMPLATES_ALL·↳ OKL_TRNS_ACC_DSTRS·Explore OKL module →
-
View: OKL_ACC_GEN_SRC_MAP_UV 12.2.2
APPS.OKL_ACC_GEN_SRC_MAP_UV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AG_SOURCE_MAPS·Explore OKL module →
-
View: OKL_AEL_SL_V 12.2.2
This view contains the accounting entries created for all the contract, asset and quote transactions. This view is used to enable sub-ledger accounting architecture to display the accounting entries for each Lease transaction.
APPS.OKL_AEL_SL_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_JE_CATEGORIES·↳ GL_JE_CATEGORIES_VL·Explore OKL module →
-
View: OKL_AEL_SL_V 12.1.1
This view contains the accounting entries created for all the contract, asset and quote transactions. This view is used to enable sub-ledger accounting architecture to display the accounting entries for each Lease transaction.
APPS.OKL_AEL_SL_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_JE_CATEGORIES·↳ GL_JE_CATEGORIES_VL·Explore OKL module →
-
View: OKL_AE_LINES_UPDT_UV 12.1.1
APPS.OKL_AE_LINES_UPDT_UV·↳ GL_CODE_COMBINATIONS_KFV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_ACC_EVENTS_ALL·Explore OKL module →
-
View: OKL_AE_LINES_UPDT_UV 12.2.2
APPS.OKL_AE_LINES_UPDT_UV·↳ GL_CODE_COMBINATIONS_KFV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_ACC_EVENTS_ALL·Explore OKL module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2