Search Results jtf_brm_expression_lines




Overview
Explore in AI Chat

Overview

The JTF_BRM_EXPRESSION_LINES table resides in the JTF schema and belongs to the CRM Foundation product module (JTF). It stores the individual expression lines that make up simple business rule definitions within the Oracle E-Business Suite Business Rule Management (BRM) framework. Each row represents a single atomic condition fragment — comprising operands, operators, parentheses, and boolean connectors — that, when assembled with other lines under a common rule, forms the complete logical expression evaluated by the BRM engine at runtime.

In Oracle EBS 12.1.1 and 12.2.2, this table functions as the granular detail layer beneath the rule header. Where the parent rule record establishes the rule's identity, name, and scope, JTF_BRM_EXPRESSION_LINES supplies the structured predicate logic that determines whether the rule fires. The table is owned by JTF and is marked VALID in the data dictionary, with 37 documented columns in the 12.2.2 physical schema.

Applying heuristic Data Vault classification, this object is best modeled as a link. It carries a foreign key to JTF_BRM_RULES_B (via RULE_ID) and to FND_SECURITY_GROUPS (via SECURITY_GROUP_ID), positioning it as a relationship-bearing entity that connects rule definitions to their constituent expression components and security context.

Key Information Stored

Common Use Cases and Queries

Typical scenarios include reconstructing a rule's full predicate for review, migrating rule definitions between environments, and auditing rule logic for compliance.

Retrieve all lines for a rule in evaluation order:

  • SELECT expression_line_id, sort_sequence, left_value, brm_operator_code, right_value, brm_boolean_operator_code FROM jtf.jtf_brm_expression_lines WHERE rule_id = :p_rule_id ORDER BY sort_sequence;

Join to the parent rule to report rule names alongside their conditions:

  • SELECT r.rule_id, e.left_value, e.brm_operator_code, e.right_value FROM jtf.jtf_brm_expression_lines e JOIN jtf.jtf_brm_rules_b r ON r.rule_id = e.rule_id WHERE r.rule_id = :p_rule_id;

Count expression lines per rule to identify complex rules, and filter by SECURITY_GROUP_ID to respect data partition boundaries in multi-org deployments.

Related Objects

  • JTF_BRM_RULES_B — Parent rule header; joined on JTF_BRM_EXPRESSION_LINES.RULE_ID = JTF_BRM_RULES_B.RULE_ID.
  • JTF_BRM_RULES_TL — Translatable rule name/description, joining to the base rules table for user-facing labels.
  • FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for access-control partitioning.
  • JTF_BRM_EXPRESSION_LINES (self-referencing patterns) — Adjacent lines in SORT_SEQUENCE order form the complete expression.
  • JTF_BRM_RULES_B / JTF_BRM_* BRM family tables — Supporting rule metadata consumed alongside expression lines.

No public PL/SQL API specific to this table is documented; access occurs primarily through the BRM framework and direct SQL for reporting and migration.