Results for “oke_k_std_notes_u1”

12 results




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

Overview

OKE_K_STANDARD_NOTES_B is the base (non-translated) table that stores contract standard notes information within the Oracle E-Business Suite Project Contracts (OKE) module. Standard notes are reusable, pre-defined text blocks — such as boilerplate terms, disclaimer language, or standard contractual clauses — that users attach to projects, contract headers, contract lines, or deliverables rather than retyping them on every agreement. In EBS 12.1.1 and 12.2.2 the table resides in the OKE schema and is maintained as a VALID, multi-org-agnostic repository object, acting as the single source of truth for the note definition itself, while the actual localized text is held in the companion translation table.

From a data-vault modeling perspective, this object exhibits satellite-leaning characteristics. It carries its own surrogate primary key, STANDARD_NOTES_ID, imposed by the OKE_K_STD_NOTES_PK constraint (backed by the unique index OKE_K_STD_NOTES_U1), yet it simultaneously holds three foreign keys pointing outward to OKE_K_HEADERS, OKE_K_LINES, and OKE_K_DELIVERABLES_B. This dual nature — descriptive attributes plus contextual attachment references — means the table functions less as a pure reference hub and more as a satellite that records the note's descriptive payload and its optional linkage context.

Key Information Stored

The table contains 27 documented columns. The most significant are:

  • STANDARD_NOTES_ID — the surrogate primary key, populated via sequence and enforced by OKE_K_STD_NOTES_PK; also the documented business-key candidate through unique index OKE_K_STD_NOTES_U1.
  • K_HEADER_ID — foreign key to OKE_K_HEADERS, tying the note to a specific contract header.
  • K_LINE_ID — foreign key to OKE_K_LINES, scoping the note to an individual contract line.
  • DELIVERABLE_ID — foreign key to OKE_K_DELIVERABLES_B, associating the note with a deliverable.
  • TYPE_CODE — classifies the note category (for example, header, line, or deliverable level).
  • DEFAULT_FLAG — indicates whether the note is applied by default when new contracts are created.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle flexfield (DDF) columns used for client-specific descriptive extensions.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the mandatory WHO audit columns tracking insert and update history.

The translated text itself is not stored here; it is held in OKE_K_STANDARD_NOTES_TL keyed by STANDARD_NOTES_ID.

Common Use Cases and Queries

Typical reporting scenarios include listing all default standard notes for a given contract header, auditing which lines carry boilerplate clauses, and exporting note definitions for legal review. A representative join retrieves header-scoped notes with their translated text:

  • SELECT b.standard_notes_id, t.notes_text, b.type_code, b.default_flag FROM oke.oke_k_standard_notes_b b, oke.oke_k_standard_notes_tl t WHERE b.standard_notes_id = t.standard_notes_id AND b.k_header_id = :header_id AND t.language = USERENV('LANG');
  • Querying DEFAULT_FLAG = 'Y' to enumerate notes inherited automatically during contract generation.
  • Joining to OKE_K_HEADERS and OKE_K_LINES on K_HEADER_ID and K_LINE_ID respectively to produce a contract-level note inventory for compliance reporting.

Because the table is a base table with a TL companion, all user-facing queries should join through OKE_K_STANDARD_NOTES_TL and filter on LANGUAGE to return readable text.

Related Objects

  • OKE_K_HEADERS — parent object for header-level notes via K_HEADER_ID.
  • OKE_K_LINES — parent object for line-level notes via K_LINE_ID.
  • OKE_K_DELIVERABLES_B — parent object for deliverable-level notes via DELIVERABLE_ID.
  • OKE_K_STANDARD_NOTES_TL — translation table holding localized note text, joined on STANDARD_NOTES_ID.
  • OKE_K_STANDARD_NOTES_BH — history table capturing prior versions of note definitions, joined on STANDARD_NOTES_ID.