Search Results xdo_dgf_tpl_rules




Overview
Explore in AI Chat

Overview

XDO_DGF_TPL_RULES is a table in the XDO schema (XML Publisher / BI Publisher) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores rule definitions associated with templates used in the Data Generator Framework (DGF), the internal EBS component responsible for producing formatted output from XML data sources in concurrent programs such as "XML Publisher Report" and related publishing flows. Each row identifies a template rule, ties it to a template context, and associates it with a rule catalog entry, allowing the publishing engine to determine which conditional formatting, filtering, or transformation should be applied when rendering a template.

From a data modeling perspective, the ETRM metadata classifies this object heuristically as standalone rather than a hub, link, or satellite in a Data Vault sense. That classification is a modeling suggestion only: the table has no foreign keys emitted from it in the documented relationship data, but it does carry one FK relationship noted as TEMPLATE_RULE_ID → OKC_XPRT_TEMPLATE_RULES, meaning the business identity of a rule row is fundamentally derived from the OKC export template rule definition. In practice, the table behaves like a satellite of the template rule structure owned by OKC, extended with XML Publisher-specific formatting controls.

Key Information Stored

The table contains 27 documented columns, with XDO_DGF_TPL_RULES_U1 defined as a unique index on TEMPLATE_RULE_ID, making that column the business-key candidate. The most significant columns are:

  • TEMPLATE_RULE_ID — surrogate/business key for the rule, uniquely indexed and linked back to OKC_XPRT_TEMPLATE_RULES.
  • TEMPLATE_CONTEXT_ID — identifies the template context (the template/definition grouping) to which the rule belongs.
  • RULE_CATALOG_ID — references the rule catalog that classifies the rule's behavior.
  • TPL_RULE_DESCRIPTION — free-text description of the rule's purpose, useful for reporting and troubleshooting.
  • FORMAT_FILTER_TYPE — indicates the filter/formatting behavior applied, such as conditional suppression or selection of output formats.
  • OBJECT_VERSION_NUMBER — optimistic locking column used by the framework to detect concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns tracking who created and last modified the rule and when.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — DFF-style descriptive flexfield columns allowing extensibility without schema change (note ATTRIUBTE8 appears with a documented spelling inconsistency).

Common Use Cases and Queries

Typical uses involve diagnosing why a template rendered a particular output, auditing which rules are active for a template context, or extending reporting on template rule metadata. Common SQL patterns include joining to OKC_XPRT_TEMPLATE_RULES on TEMPLATE_RULE_ID to resolve the owning template rule context:

  • Rule lookup by template: SELECT r.TEMPLATE_RULE_ID, r.TEMPLATE_CONTEXT_ID, r.TPL_RULE_DESCRIPTION, r.FORMAT_FILTER_TYPE FROM XDO.XDO_DGF_TPL_RULES r WHERE r.TEMPLATE_CONTEXT_ID = :ctx_id;
  • Cross-reference to OKC: join XDO_DGF_TPL_RULES to OKC_XPRT_TEMPLATE_RULES on TEMPLATE_RULE_ID to correlate XML Publisher rules with their OKC template definitions.
  • Recent changes: filter on LAST_UPDATE_DATE to identify rules modified in a given period.
  • Extensibility reporting: query ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 to surface any DFF values configured for the rule.

Related Objects

The most significant related objects, based on documented relationships and functional context, include:

  • OKC_XPRT_TEMPLATE_RULES — parent rule definition; joined via TEMPLATE_RULE_ID.
  • XDO_DGF_TPL_CONTEXTS (implied by TEMPLATE_CONTEXT_ID) — the template context grouping the rule belongs to.
  • XDO_DGF_RULE_CATALOGS (implied by RULE_CATALOG_ID) — catalogs classifying rule behavior.
  • XDO_LOBS / XDO_TEMPLATES_TL — templates whose rendering consumes these rule definitions.
  • XDO_TEMPLATE_DEFINITIONS — template definition metadata referenced through the context.
  • OKC_XPRT_TEMPLATES_B / _TL — owning export template structures in the OKC module.
  • FND_CONCURRENT_PROGRAMS — programs that invoke XML Publisher processing and thus exercise these rules at runtime.