Results for “currency_conversion_code”

50+ results




Overview
Explore in AI Chat

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

Overview

OKL_REPAIR_COSTS_ALL_B is a setup (reference) table in the Oracle Leasing and Finance Management (OKL) module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. Its documented purpose is to store the types of repair that may be required on a leased asset together with a recommended cost applicable to asset condition repairs. In practice it functions as a costing reference used during end-of-lease or mid-term asset assessments, where an assessor records the condition of an asset and the system retrieves a standard recommended repair cost rather than requiring a manually negotiated figure for each occurrence.

The table is owned by the OKL schema and is classified as VALID. Its heuristic Data Vault classification, mined from the foreign-key structure, is standalone; from a dimensional modeling perspective this suggests treating it as a small reference or lookup hub with no dependent link or satellite relationships inside its own boundary. Because it carries ORG_ID, it is also organization-stripped in the multitenant sense: the same repair type may be defined differently for different operating units.

Key Information Stored

The documented physical schema for 12.2.2 lists 15 columns. The most significant are:

Note that no DESCRIPTION or NAME column appears in the documented column list, so the descriptive text of the repair type is likely stored in the associated _TL translation table rather than in the _B base table itself, consistent with the EBS multilingual naming convention.

Common Use Cases and Queries

Typical uses include validating that repair cost setup exists before an asset condition assessment is submitted, extracting recommended costs for lease termination quoting, and reporting on currency exposure when recommended costs span multiple currencies.

A basic lookup of enabled repair costs for an operating unit:

  • SELECT id, cost, currency_code FROM okl.okl_repair_costs_all_b WHERE enabled_yn = 'Y' AND org_id = :p_org_id;

A currency-restatement query using the conversion attributes:

  • SELECT id, cost, currency_code, currency_conversion_rate, currency_conversion_date FROM okl.okl_repair_costs_all_b WHERE enabled_yn = 'Y';

Audit and change-tracking reports commonly filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to identify setup rows modified after a given date. Because the table is a setup table, it is usually populated during implementation through the OKL setup UI and is rarely updated by end users.

Related Objects

The FK/PK metadata classifies OKL_REPAIR_COSTS_ALL_B as standalone, so no child tables were mined from its primary key. The following objects are the most relevant in practice: