Search Results jtf_rs_resource_extns_tl




Overview
Explore in AI Chat

Overview

JTF_RS_RESOURCE_EXTNS_TL is a translated (TL) child table in the JTF — CRM Foundation product of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It stores the language-dependent descriptive attributes of resources managed by Oracle CRM applications. Resources modeled here originate from heterogeneous source systems such as Oracle HR (employees), Oracle Receivables/HZ (customers, contacts, and other parties), or vendor-related sources. The table's documented primary key is RESOURCE_ID, with RESOURCE_NUMBER and USER_ID also described as unique keys in the underlying resource model.

Structurally, the table is a translation companion to the base JTF_RS_RESOURCE_EXTNS table. It carries a composite primary key, JTF_RS_EXTNS_TL_PK, defined over RESOURCE_ID, CATEGORY, and LANGUAGE, and relies on a foreign key from RESOURCE_ID back to JTF_RS_RESOURCE_EXTNS. A second documented foreign key references FND_SECURITY_GROUPS through SECURITY_GROUP_ID, providing multi-tenant data isolation consistent with the Oracle CRM Foundation security architecture. Physically, the ETRM 12.2.2 schema documents eleven columns under the JTF schema.

Under a heuristic Data Vault classification, the FK topology suggests a satellite-leaning role: the table hangs off the JTF_RS_RESOURCE_EXTNS hub-style parent and carries descriptive, language-scoped attributes rather than introducing new business entities or many-to-many relationships. This classification should be treated as a modeling suggestion, not a normative Oracle definition.

Key Information Stored

Only the documented columns are described below. The most significant include:

  • RESOURCE_ID — Surrogate identifier of the resource; part of the composite primary key and the FK to JTF_RS_RESOURCE_EXTNS.
  • CATEGORY — Classification discriminator of the extension record; part of the composite primary key.
  • LANGUAGE — The language code qualifying the translated row; part of the composite primary key.
  • RESOURCE_NAME — The translatable, language-specific display name of the resource.
  • SOURCE_LANG — The source language from which the translation was derived.
  • SECURITY_GROUP_ID — Tenant/security group key with FK to FND_SECURITY_GROUPS.
  • CREATED_BY, CREATION_DATE — Who-created audit columns.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Who-updated audit columns.

The business-key candidate documented as unique index JTF_RS_EXTNS_U1 is (RESOURCE_ID, LANGUAGE, CATEGORY), reinforcing that a single resource may have multiple rows distinguished by language and category. The surrogate primary key JTF_RS_EXTNS_TL_PK is (RESOURCE_ID, CATEGORY, LANGUAGE).

Common Use Cases and Queries

Typical use cases include multilingual resource name display, CRM reporting on resource metadata, and translation completeness auditing. A common join retrieves the localized name for a resource alongside its base record:

SELECT t.resource_id, t.category, t.language, t.resource_name
FROM jtf_rs_resource_extns_tl t
WHERE t.language = USERENV('LANG');

To detect missing translations, compare distinct languages against the base table. To honor multi-tenant access control, filter by SECURITY_GROUP_ID aligned to the FND security profile. Reporting on RESOURCE_NAME with LANGUAGE is useful for localized resource directories.

Related Objects

  • JTF_RS_RESOURCE_EXTNS — Parent table joined on RESOURCE_ID.
  • FND_SECURITY_GROUPS — Joined on SECURITY_GROUP_ID for tenant isolation.
  • JTF_RS_RESOURCE_EXTNS_TL_PK — Composite primary key index.
  • JTF_RS_EXTNS_U1 — unique business-key index on (RESOURCE_ID, LANGUAGE, CATEGORY).

This object supports CRM Foundation resource-driven features across Oracle Sales, Service, and Territory applications.