Search Results okl_ae_line_type




Overview
Explore in AI Chat

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:

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.