Results for “okl_acc_gen_src_map_uv”

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

Overview

The OKL_ACC_GEN_SRC_MAP_UV view is a reporting-oriented user view within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It exposes the accounting generation source mapping configuration that drives how Oracle Lease Management derives accounting events and their associated attributes from underlying transactional sources. In EBS 12.1.1 and 12.2.2, this view serves as the decoded, presentation-ready counterpart to the OKL_AG_SOURCE_MAPS configuration table, resolving internal lookup codes into human-readable meanings via the OKL_ACCOUNTING_UTIL package. Because it is defined under the APPS schema and marked VALID, it is available for ad-hoc queries, custom reports, and diagnostic investigations of accounting generation behavior. Users searching for okl_ae_line_type typically arrive here because AE_LINE_TYPE is one of the view's principal decoded columns.

Underlying Base Objects

The view is defined over a synonym, OKL_AG_SOURCE_MAPS, which resolves to the base accounting generation source mapping table. The view text confirms this with its FROM clause referencing AGSM (OKL_AG_SOURCE_MAPS). The second documented referenced object is the package OKL_ACCOUNTING_UTIL, which supplies the GET_LOOKUP_MEANING function. That function is invoked repeatedly in the SELECT list to translate coded values into descriptive text. The view therefore does not store data itself; it presents a live, decoded projection of the mapping table rows, filtered implicitly by whatever conditions the caller applies. The presence of ORG_ID indicates multi-org (operating unit) awareness consistent with OKL's setup data model.

Key Columns

• ID — Surrogate primary identifier of the source mapping record.
• AE_LINE_TYPE — The accounting event line type code; decoded for presentation in AE_LINE_TYPE_MEANING using the OKL_AE_LINE_TYPE lookup type.
• AE_LINE_TYPE_MEANING — Descriptive meaning of the accounting event line type, resolved via OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING.
• SOURCE / SOURCE_MEANING — The source table or region from which accounting values are generated, decoded against OKL_ACC_GEN_SOURCE_TABLE.
• PRIMARY_KEY_COLUMN / PK_COLUMN_MEANING — The primary key column used to link the source, decoded against OKL_SOURCE_PK_COLUMN.
• SELECT_COLUMN / SELECT_COLUMN_MEANING — The column selected from the source; its meaning is resolved dynamically against a lookup name constructed from SOURCE, with a special case for FINANCIALS_SYSTEM_PARAMETERS (mapped to OKL_FINANCIALS_SYSTEM_PARAMETE).
• OBJECT_VERSION_NUMBER — Optimistic locking version for the underlying row.
• ORG_ID — Operating unit owning the mapping record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.

Common Use Cases and Queries

This view is principally used to trace how a given accounting event line type sources its values, and to validate configuration before or after accounting generation runs. A typical query filters by line type and operating unit:

SELECT ae_line_type_meaning, source_meaning, pk_column_meaning, select_column_meaning
FROM apps.okl_acc_gen_src_map_uv
WHERE ae_line_type = :p_line_type
AND org_id = :p_org_id;

Analysts investigating a specific source table can invert the filter:

SELECT ae_line_type_meaning, select_column_meaning
FROM apps.okl_acc_gen_src_map_uv
WHERE source = 'OKC_K_LINES'
ORDER BY ae_line_type;

Because meanings are resolved at query time through OKL_ACCOUNTING_UTIL, results always reflect current lookup values. This makes the view suitable for configuration audits, troubleshooting missing or incorrect accounting entries, and building custom reports that document the OKL accounting generation source map without requiring direct access to the base table.