Search Results okc_qa_check_lists_tl_u2




Overview
Explore in AI Chat

Overview

OKC.OKC_QA_CHECK_LISTS_TL is the translation (TL) table for Oracle Quality Assurance checklist definitions within the Oracle Contracts (OKC) module of Oracle E-Business Suite. It stores language-dependent, translatable attributes of a QA checklist — specifically the checklist name and its short description — while the non-translatable attributes are held in the companion base table, OKC_QA_CHECK_LISTS_B. This separation follows Oracle's Multi-Lingual Support (MLS) standard, permitting a single logical checklist to exist in multiple installed languages without duplicating the structural or control attributes.

In EBS 12.1.1 and 12.2.2, the table resides in the APPS_TS_TX_DATA tablespace (PCTFREE 10), and its unique indexes reside in APPS_TS_TX_IDX. Under the heuristic Data Vault classification derived from its foreign-key structure, this table is a standalone object — it is not modeled as a dependent satellite linked to a parent hub through a documented FK other than the hosted-environment reference to FND_SECURITY_GROUPS. Where the table participates in the Contracts QA checklist model, the natural hub candidate is the base table OKC_QA_CHECK_LISTS_B keyed by ID.

Key Information Stored

  • ID — Primary key column, shared with OKC_QA_CHECK_LISTS_B. It is the surrogate identifier of the checklist and forms part of the composite primary key OKC_QA_CHECK_LISTS_TL_PK (ID, LANGUAGE).
  • LANGUAGE — Standard MLS column and part of the primary key; identifies the installed language of the translated row.
  • SOURCE_LANG — Standard MLS column recording the language in which the row was originally authored.
  • NAME — The QA checklist name (VARCHAR2(150)). This is a business-key candidate, enforced through the unique index OKC_QA_CHECK_LISTS_TL_U2 (NAME, LANGUAGE, ZD_EDITION_NAME).
  • SHORT_DESCRIPTION — User-entered free-format abbreviated description (VARCHAR2(600)) providing the translated summary of the checklist.
  • ZD_EDITION_NAME — Editioning column (VARCHAR2(30)) used with the unique indexes OKC_QA_CHECK_LISTS_TL_U1 (ID, LANGUAGE, ZD_EDITION_NAME) and OKC_QA_CHECK_LISTS_TL_U2, supporting online patching in 12.2.x.
  • SFWT_FLAG — Flag column documented as not used.
  • SECURITY_GROUP_ID — Used in hosted environments; the only documented foreign-key reference, to FND_SECURITY_GROUPS.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who columns capturing audit and concurrency information.

Two unique indexes serve as business-key candidates: OKC_QA_CHECK_LISTS_TL_U1 (ID, LANGUAGE, ZD_EDITION_NAME) and OKC_QA_CHECK_LISTS_TL_U2 (NAME, LANGUAGE, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical use cases include multilingual checklist lookup and reporting, translation validation, and joining the translation rows back to base structural attributes. A common query pattern retrieves the checklist name and description for a specific language while joining to the base table for non-translatable data:

  • Retrieve translated rows for a single language: SELECT ID, NAME, SHORT_DESCRIPTION FROM OKC.OKC_QA_CHECK_LISTS_TL WHERE LANGUAGE = :p_language.
  • Report all languages defined for a checklist: filter on ID = :checklist_id and order by LANGUAGE.
  • Identify missing translations by comparing each ID's available LANGUAGE values against the installed FND_LANGUAGES set.
  • Join to OKC_QA_CHECK_LISTS_B on ID to combine translated names with base attributes.
  • Filter by SECURITY_GROUP_ID in hosted deployments that enforce security-group partitioning.

Because the name is unique per language, reports should always constrain NAME by LANGUAGE to avoid ambiguous matches.

Related Objects

  • OKC_QA_CHECK_LISTS_B — The base table holding non-translatable checklist definitions; joined on ID, and the source of the translatable columns according to MLS standards.
  • OKC_QA_CHECK_LISTS_TL# — The referenced object listed in dependency data, associated with the table's interface/package generation.
  • FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for hosted-environment security partitioning.
  • FND_LANGUAGES — Used to interpret LANGUAGE and SOURCE_LANG values and to evaluate translation coverage.
  • OKC_QA_CHECK_LISTS_TL_U1 / OKC_QA_CHECK_LISTS_TL_U2 — The unique indexes enforcing the ID/LANGUAGE and NAME/LANGUAGE business keys.