Results for “flm_seq_rule_constraints”

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

Overview

FLM_SEQ_RULE_CONSTRAINTS is a Flow Manufacturing (FLM) table that stores the sequencing constraint definitions used by Oracle EBS to govern how production lines order and align assemblies during flow and mixed-model manufacturing. A sequencing rule, defined in FLM_SEQ_RULES, dictates the criteria by which units are introduced to (or removed from) a line. FLM_SEQ_RULE_CONSTRAINTS provides the granular constraint records that translate an abstract rule into concrete, prioritized, attribute-level conditions. Each row defines a single constraint belonging to a sequencing rule, qualified by the organization and optionally bound to a sequencing attribute.

The object is owned by the FLM schema and is documented as VALID in both 12.1.1 and 12.2.2. In 12.2.2 the physical schema exposes 22 columns. The heuristic Data Vault classification mined from the foreign-key structure is link: the table records relationships between a sequencing rule (FLM_SEQ_RULES), an operating unit/inventory organization context (MTL_PARAMETERS), and a sequencing attribute definition (FLM_SEQ_ATTRIBUTES). This classification is offered as a modeling suggestion rather than a documented fact.

Key Information Stored

The primary key is FLM_SEQ_RULE_CONSTRAINTS_PK, a composite surrogate key over CONSTRAINT_NUMBER and RULE_ID. The unique index FLM_SEQ_RULE_CONSTRAINTS_U1 (RULE_ID, CONSTRAINT_NUMBER) is the documented business-key candidate, meaning a constraint is uniquely identified within its parent rule by constraint number. The most significant columns are:

• RULE_ID — foreign key to FLM_SEQ_RULES; identifies the sequencing rule to which the constraint belongs.
• CONSTRAINT_NUMBER — sequence/identifier of the constraint within the rule; part of both the primary key and the unique business key.
• PARENT_CONSTRAINT_NUMBER — supports hierarchical or nested constraints under a parent constraint.
• ORGANIZATION_ID — foreign key to MTL_PARAMETERS; scopes the constraint to an inventory organization.
• PRIORITY — evaluation or application order among constraints on the same rule.
• CONSTRAINT_TYPE — classification of the constraint (for example, attribute-based or relationship-based logic).
• CONSTRAINT_TYPE_VALUE1/2/3 — type-specific parameters that qualify the constraint logic.
• ATTRIBUTE_ID — foreign key to FLM_SEQ_ATTRIBUTES; the sequencing attribute the constraint evaluates.
• ATTRIBUTE_VALUE1_NAME / ATTRIBUTE_VALUE2_NAME — character (name) values for the bounded attribute.
• ATTRIBUTE_VALUE1_NUM / ATTRIBUTE_VALUE2_NUM — numeric ranges or thresholds for the attribute.
• ATTRIBUTE_VALUE1_DATE / ATTRIBUTE_VALUE2_DATE — date ranges for attribute-based constraints.

Standard EBS WHO columns complete the structure: OBJECT_VERSION_NUMBER (optimistic locking), CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical reporting and diagnostics include listing all constraints for a rule in priority order, auditing attribute bindings to confirm which sequencing attributes drive line behavior, and troubleshooting why the sequencing engine applies or ignores a constraint. A representative query joins the constraint table to its parent rule and the attribute definition:

SELECT c.CONSTRAINT_NUMBER, c.PRIORITY, c.CONSTRAINT_TYPE,
      c.ATTRIBUTE_ID, a.ATTRIBUTE_NAME,
      c.ATTRIBUTE_VALUE1_NAME, c.ATTRIBUTE_VALUE1_NUM, c.ATTRIBUTE_VALUE1_DATE
FROM  FLM.FLM_SEQ_RULE_CONSTRAINTS c,
      FLM.FLM_SEQ_RULES r,
      FLM.FLM_SEQ_ATTRIBUTES a
WHERE  c.RULE_ID = r.RULE_ID
AND    c.ATTRIBUTE_ID = a.ATTRIBUTE_ID
AND    c.ORGANIZATION_ID = :org_id
ORDER BY c.PRIORITY, c.CONSTRAINT_NUMBER;

Other uses include validating that every rule in a given organization has at least one constraint, comparing constraint configurations between organizations for consistency, exporting hierarchies via PARENT_CONSTRAINT_NUMBER, and feeding sequencing rules into test or migration scripts. Because the objects are maintained by Flow Manufacturing configuration, direct DML is discouraged; changes are normally driven through the FLM sequencing rule setup UI.

Related Objects

• FLM_SEQ_RULES — parent rule table; join on FLM_SEQ_RULE_CONSTRAINTS.RULE_ID = FLM_SEQ_RULES.RULE_ID.
• FLM_SEQ_ATTRIBUTES — attribute definitions; join on ATTRIBUTE_ID.
• MTL_PARAMETERS — organization definition; join on ORGANIZATION_ID.
• FLM_SEQ_RULE_CONSTRAINTS_PK / FLM_SEQ_RULE_CONSTRAINTS_U1 — primary and unique indexes enforcing identity and business keys.
• AHL/FLM scheduling and line-sequencing programs that read constraint rows when computing sequence order for a flow line.