Results for “interval_yn”

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

Overview

OKC_TIMEVALUES_V is a reporting and integration view in the Oracle E-Business Suite Contracts Core (OKC) module. It is owned by the APPS schema and is defined as the "View for table OKC_TIMEVALUES." In release 12.1.1 and 12.2.2, the object carries a VALID status, meaning it is a supported, compiled database object available for query by application code, concurrent programs, and external integrations.

The view presents time-value definitions used within contract terms and conditions. In OKC, time values express recurring or conditional timing elements — durations, calendar offsets, and patterns such as day-of-week, month, hour, and minute — that drive clause scheduling, renewals, notifications, and other contract life-cycle behavior. Because the underlying table OKC_TIMEVALUES is generally accessed through the view, OKC_TIMEVALUES_V serves as the canonical read interface, insulating callers from direct table dependencies and enabling the seeded 'N' SFWT_FLAG projection used by Oracle's standard time framework.

Underlying Base Objects

The ETRM metadata documents a single referenced base object: the synonym OKC_TIMEVALUES. The view text confirms this relationship — the FROM clause selects from OKC_TIMEVALUES aliased as TVEB, and the view is a direct projection of that table's columns with no joins, unions, or aggregations. Column names and data types are passed through unchanged, with two notable derivations:

• ROW_ID is mapped from the base table's ROWID pseudo-column, providing a unique physical row identifier.
• SFWT_FLAG is a literal 'N', indicating the row is not sourced from the Sub-Form Workflow/Template extension path.

All remaining columns are direct references to the corresponding OKC_TIMEVALUES columns, prefixed by the TVEB alias. Because the view is read-only against a single synonym, no INSTEAD-OF triggers or materialization are involved.

Key Columns

The view exposes the full OKC_TIMEVALUES column set. Principal columns include:

• ID / ROW_ID / OBJECT_VERSION_NUMBER — Primary identifier, physical rowid, and myQ2 optimistic-locking version token.
• SPN_ID — Reference to the owning standard/contract pattern node context.
• TZE_ID — Time zone reference governing interpretation of the value.
• CNH_ID / DNZ_CHR_ID — Contract header and related contract identity associations.
• TVE_TYPE / TVE_ID_OFFSET / TVE_ID_GENERATED_BY / TVE_ID_STARTED / TVE_ID_ENDED / TVE_ID_LIMITED — Time-value type and the chain of offset, generator, start, end, and limit references that position the value within a timeline.
• DURATION / OPERATOR / BEFORE_AFTER / UOM_CODE — The quantity, comparison operator, direction relative to a reference point, and unit of measure.
• DATETIME / MONTH / DAY / DAY_OF_WEEK / HOUR / MINUTE / SECOND / NTH / INTERVAL_YN — Calendar and clock components enabling recurrence patterns such as "third Monday of each month" or "15 minutes after the hour."
• NAME / DESCRIPTION / SHORT_DESCRIPTION / COMMENTS — Descriptive text.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield segment storage.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard audit columns.

Common Use Cases and Queries

The view supports contract clause scheduling diagnostics, renewal and escalation validation, and migration of time-value definitions between environments. Typical access patterns include:

• Retrieving all time values attached to a contract header for audit.
• Identifying interval-based rules and their recurrence components.
• Joining the view to OKC clause or template structures to reconstruct scheduling behavior.

Representative query:

SELECT id, name, tve_type, duration, uom_code, operator, before_after, day_of_week, hour, minute, interval_yn FROM apps.okc_timevalues_v WHERE dnz_chr_id = :p_contract_id ORDER BY creation_date;

For reporting performance, filter on indexed base-table columns such as ID, DNZ_CHR_ID, or CNH_ID rather than attribute flexfield segments, and avoid selecting ROW_ID unless the physical row reference is specifically required.