Results for “accr_sty”

4 results




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

Overview

APPS.OKL_CS_SCHACCR_AMOUNT_UV is a reporting view in the Oracle E-Business Suite (EBS) Lease and Finance Management / Enterprise Contract Management module, part of the ETRM (Enterprise Transaction and Reference Model) schema family. The view presents accrued subsidy stream amounts associated with lease contracts, exposing the contract identifier (KLE_ID), the monetary amount of each stream element, and the effective stream element date. It is designed to support accrual accounting reporting and downstream integration processes that need to translate raw stream element data into subsidy accrual figures.

The view is particularly relevant to users investigating the OKL_STRMTYP (stream type) reference because its definition relies on stream type resolution through the OKL_SGN_TRANSLATIONS table using the JTOT_OBJECT1_CODE value 'OKL_STRMTYP'. It effectively decodes sign translations into concrete stream types and then filters those types by their stream type purpose to isolate subsidy accruals.

Underlying Base Objects

The view is defined over four documented base objects, referenced through APPS synonyms:

  • OKL_STRM_TYPE_B — the stream type definition table, appearing three times (aliases STR_TYPE, ACCR_STY, SUB_STY) to resolve the accrual stream type, the matching type by code, and the subsidy subtype respectively.
  • OKL_STREAMS — the stream header table, holding the contract link (KLE_ID), the stream type reference (STY_ID), and the current/active attributes.
  • OKL_STRM_ELEMENTS — the stream element (detail) table, supplying the individual AMOUNT and STREAM_ELEMENT_DATE records.
  • OKL_SGN_TRANSLATIONS — the sign translation table, used to map the translation value to a stream type identifier through the 'OKL_STRMTYP' object code.

The joins establish a chain from the sign translation to a subsidy stream type, from that to a matching accrual stream type by code, and from there to active streams and their element details.

Key Columns

  • KLE_ID — the contract or lease identifier (from OKL_STREAMS.KLE_ID) to which the accrued amount belongs. This is the primary grouping key for reporting.
  • AMOUNT — the monetary value of the stream element (from OKL_STRM_ELEMENTS.AMOUNT), representing the accrued subsidy amount.
  • STREAM_ELEMENT_DATE — the effective date of the stream element, used for period-based accrual reporting and aging.

Common Use Cases and Queries

Typical use cases include subsidy accrual reporting by lease, reconciliation of accrued subsidy amounts against general ledger balances, and data feeds to downstream accounting engines. Because the view filters streams to SAY_CODE = 'CURR', ACTIVE_YN = 'Y', and PURPOSE_CODE IS NULL, results reflect only currently active streams without a specific purpose code.

A representative query aggregates accrued subsidy amounts by contract:

  • SELECT kle_id, SUM(amount) total_accrued, MIN(stream_element_date) first_date, MAX(stream_element_date) last_date FROM apps.okl_cs_schaccr_amount_uv GROUP BY kle_id ORDER BY kle_id;

Analysts investigating a specific stream type or translation value may join the view back to OKL_STRM_TYPE_B or OKL_SGN_TRANSLATIONS to trace how 'OKL_STRMTYP' entries resolve into subsidy accruals, making this view a useful bridge between reference data and financial amounts.