Results for “csc_prof_check_rules_tl_u1”

12 results




Overview
Explore in AI Chat

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

Overview

CSC.CSC_PROF_CHECK_RULES_TL is the translation (TL) table for the Oracle E-Business Suite profile check rules defined in the CSC schema. In EBS Release 12.1.1 and 12.2.2, it stores the language-specific expression text used by profile check conditions, while the base table CSC_PROF_CHECK_RULES_B holds the language-independent rule definitions. Together, the _B and _TL tables implement the standard EBS multi-language seed data pattern, where each rule is keyed by CHECK_ID and SEQUENCE and then translated per LANGUAGE.

The table resides in the APPS_TS_SEED tablespace and is marked VALID in the ETRM metadata. Its dependency footprint is minimal: it references no database objects directly (apart from the base table through the CHECK_ID and SEQUENCE semantic definitions) and is exposed to the APPS schema as a synonym. Under a heuristic Data Vault classification the object is satellite-leaning, since it carries descriptive, language-dependent attributes (EXPRESSION, SOURCE_LANG) hanging off the CHECK_ID / SEQUENCE business key rather than defining new hubs or links.

Key Information Stored

  • CHECK_ID – Numeric key that references the CHECK_ID in CSC_PROF_CHECK_RULES_B. Identifies which profile check rule the translation belongs to.
  • SEQUENCE – Numeric key that references the SEQUENCE in CSC_PROF_CHECK_RULES_B. Distinguishes individual rule conditions within the same check.
  • LANGUAGE – VARCHAR2(12) language code of the text held in EXPRESSION.
  • SOURCE_LANG – VARCHAR2(12) language code of the record from which this row was copied during upgrade.
  • EXPRESSION – VARCHAR2(240) holding the value against which the check result is compared.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Who audit columns.
  • SECURITY_GROUP_ID – Used in hosted environments; references FND_SECURITY_GROUPS.
  • ZD_EDITION_NAME – Editioning column documented in the 12.2.2 physical schema.

The surrogate primary key is CSCPCRTL_PK (CHECK_ID, SEQUENCE, LANGUAGE). The unique index CSC_PROF_CHECK_RULES_TL_U1 is the documented business-key candidate; in 12.2.2 it is defined on (CHECK_ID, SEQUENCE, LANGUAGE, ZD_EDITION_NAME), extending the earlier 12.1.1 definition.

Common Use Cases and Queries

Typical uses include validating translated expressions for a given language, reconciling TL rows against their _B parents, and generating audit reports of Who columns after upgrades. A representative query joins the translation and base tables:

  • SELECT b.CHECK_ID, b.SEQUENCE, t.LANGUAGE, t.EXPRESSION FROM CSC.CSC_PROF_CHECK_RULES_B b, CSC.CSC_PROF_CHECK_RULES_TL t WHERE b.CHECK_ID = t.CHECK_ID AND b.SEQUENCE = t.SEQUENCE AND t.LANGUAGE = 'US';
  • Filtering by SOURCE_LANG to identify rows copied during a specific upgrade cycle.
  • Reporting on SECURITY_GROUP_ID when auditing hosted multi-tenant configurations.

Related Objects

  • CSC.CSC_PROF_CHECK_RULES_B – parent base table; join on CHECK_ID and SEQUENCE.
  • FND_SECURITY_GROUPS – referenced via SECURITY_GROUP_ID.
  • APPS.CSC_PROF_CHECK_RULES_TL – the APPS-schema synonym through which the table is normally queried.
  • The CSC_PROF_CHECK_RULES_TL_U1 index and CSCPCRTL_PK constraint, which enforce uniqueness and support lookups by rule key.