Search Results acct_line_type_meaning




Overview
Explore in AI Chat

Overview

OKL_ACC_GEN_RULES_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL – Leasing and Finance Management product. Its documented purpose is to expose the account generator rule header, meaning the top-level definition rows that determine how accounting combinations are constructed for lease transactions. In the Oracle EBS 12.1.1 and 12.2.2 releases, the view presents a denormalized, reporting-friendly projection of the OKL_ACC_GEN_RULES base entity joined to ledger information sourced from the General Ledger schema.

The view is primarily consumed for reporting, inquiry screens, and integration extracts that must resolve the internal SET_OF_BOOKS_ID into a human-readable ledger name. Because it includes the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and ORG_ID for multi-org security, it behaves like a standard EBS transactional view suitable for direct query or inclusion in custom reports, OAF pages, and interfaces.

Underlying Base Objects

The documented base objects referenced by the view are:

  • OKL_ACC_GEN_RULES (SYNONYM) – the driving table that stores the account generator rule header records, including the AE_LINE_TYPE, SET_OF_BOOKS_ID, and ORG_ID attributes.
  • GL_LEDGERS_PUBLIC_V (VIEW) – a General Ledger public view exposing LEDGER_ID and NAME, used to resolve the set of books / ledger name.
  • OKL_ACCOUNTING_UTIL (PACKAGE) – supplies the function GET_LOOKUP_MEANING, invoked to translate the AE_LINE_TYPE lookup code into its display meaning.

Internally the view aliases the rule header synonym as AGRB and the ledger view as GLSOB, joining on AGRB.SET_OF_BOOKS_ID = GLSOB.LEDGER_ID. This join is what makes the view valuable to users who search on "set_of_books_name," since the base table itself stores only the numeric SET_OF_BOOKS_ID.

Key Columns

  • ROW_ID – the ROWID of the underlying rule header row, usable as a unique row identifier.
  • ID – the primary key of the account generator rule header.
  • OBJECT_VERSION_NUMBER – optimistic locking column maintained by the EBS framework.
  • AE_LINE_TYPE – the lookup code that classifies the accounting event line type for which the rule applies.
  • ACCT_LINE_TYPE_MEANING – the decoded, user-facing meaning of AE_LINE_TYPE, resolved via OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_AE_LINE_TYPE', …).
  • SET_OF_BOOKS_ID – the numeric ledger / set of books identifier from the rule header.
  • SET_OF_BOOKS_NAME – the descriptive ledger name obtained from GL_LEDGERS_PUBLIC_V.NAME; this is the column most relevant to the "set_of_books_name" search.
  • ORG_ID – the operating unit, enforcing multi-org access control.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard audit (WHO) columns.

Common Use Cases and Queries

Typical uses include validating account generator rule setup by ledger, listing all rule headers for a specific operating unit, and producing extracts that must show readable ledger names rather than internal identifiers. A basic query is:

SELECT ID, AE_LINE_TYPE, ACCT_LINE_TYPE_MEANING, SET_OF_BOOKS_ID, SET_OF_BOOKS_NAME FROM APPS.OKL_ACC_GEN_RULES_V WHERE ORG_ID = :p_org_id ORDER BY SET_OF_BOOKS_NAME, AE_LINE_TYPE;

To locate rules for a specific ledger by name, filter directly on SET_OF_BOOKS_NAME:

SELECT ID, AE_LINE_TYPE, ACCT_LINE_TYPE_MEANING, SET_OF_BOOKS_ID FROM APPS.OKL_ACC_GEN_RULES_V WHERE SET_OF_BOOKS_NAME = :p_ledger_name;

Because the view joins GL_LEDGERS_PUBLIC_V to the OKL synonym, it returns only rows whose SET_OF_BOOKS_ID matches an existing ledger, providing an implicit validity check on ledger assignment for account generator rules.