Results for “copyright_date”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CSF_MD_THEME_METADATA is a configuration metadata table owned by the CSF schema (Field Service module) in Oracle E-Business Suite 12.1.1 and 12.2.2. It defines version information for an entire theme within the CSF metadata framework, which governs the presentation and behavioral characteristics of Field Service user interface themes. Each row represents a distinct theme at a specific version level, allowing the application to track, compare, and apply themed metadata consistently across layered UI definitions.
From a dimensional modeling perspective, the mined Data Vault classification for this object is hub-leaning. This is a heuristic suggestion rather than a documented Oracle designation: the table's structure — a surrogate primary key plus descriptive business attributes — resembles a hub entity that would typically anchor links to related satellite tables. In practice, CSF_MD_THEME_METADATA functions as the parent or master record within the CSF metadata hierarchy, with dependent tables holding finer-grained theme component details.
Key Information Stored
The documented physical schema contains eight columns in ETRM 12.2.2. The most significant are:
- THEME_ID — The surrogate primary key, enforced by constraint CSF_MD_THEME_METADATA_PK. This column uniquely identifies each theme metadata record and is the anchor referenced by dependent tables.
- THEME_NAME — The descriptive, user-facing name of the theme. A strong candidate business key for reporting and lookup purposes.
- THEME_CODE — A short internal identifier used programmatically to resolve themes. Together with THEME_NAME and THEME_VERSION, this forms a likely unique business key on a theme-version combination.
- THEME_VERSION — The version number of the theme definition, enabling multiple revisions of the same logical theme to coexist and be tracked independently.
- CREATION_DATE, COPYRIGHT_DATE, and LAST_EDIT_DATE — Auditing and provenance columns recording when the record was created, the copyright date associated with the theme assets, and when the record was last modified.
- SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, scoping the theme record to a security group. This supports multi-tenant or partitioned metadata visibility in a shared EBS instance and is a common filter predicate in production queries.
Common Use Cases and Queries
The primary use case is resolving the active theme version for a given deployment or subscriber, then joining downward to layer-level metadata. Typical reporting scenarios include auditing theme versions, comparing theme definitions across environments, and tracing which layers reference a given theme.
A common query pattern retrieves theme records filtered by security group and ordered by version:
SELECT theme_id, theme_name, theme_code, theme_version, last_edit_date FROM csf.csf_md_theme_metadata WHERE security_group_id = :p_group ORDER BY theme_name, theme_version DESC;- To find the layers belonging to a theme:
SELECT l.* FROM csf.csf_md_lyr_metadata l JOIN csf.csf_md_theme_metadata t ON l.theme_metadata_id = t.theme_id WHERE t.theme_code = :p_code; - To audit stale definitions:
SELECT * FROM csf.csf_md_theme_metadata WHERE last_edit_date < SYSDATE - 365;
Related Objects
The following objects are documented as related through foreign key and primary key relationships:
- CSF_MD_LYR_METADATA — Child table; its THEME_METADATA_ID column references CSF_MD_THEME_METADATA, storing layered theme component metadata beneath each theme.
- FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID, controlling visibility and partitioning of theme records.
- CSF_MD_THEME_METADATA_PK — The unique index enforcing the primary key on THEME_ID.
Together these objects form the theme-definition backbone of the CSF metadata model, with CSF_MD_THEME_METADATA acting as the central version registry from which layer definitions descend.
-
Defines the version information of an entire theme.
-
Defines map display layer metadata
-
Defines the version information of an entire theme.
-
Defines map display layer metadata
-
eTRM - CSF Tables and Views 12.2.2
Defines the result of spatial index creation (tiling).
-
eTRM - CSF Tables and Views 12.1.1
Defines the result of spatial index creation (tiling).