Results for “okl_rules_dff”

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

Overview

OKL_RULES_DFF is a table in the OKL (Lease and Finance Management) product schema of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It is described in the ETRM metadata as the "structured data representation of free format text contained in an ARTICLE," and more specifically as a Contracts for Lease copy of OKL_RULES_B created for the purpose of Rule Descriptive Flexfield (DFF) definition. Its role is therefore to hold rule-level descriptive flexfield segments that extend the base leasing rule model without altering the underlying rule tables.

From a Data Vault perspective, the heuristic classification mined from the foreign-key structure is satellite-leaning. OKL_RULES_DFF depends on parent entities through its foreign keys and carries descriptive, non-key attributes, which is consistent with satellite behavior rather than hub or link behavior. Practitioners modeling the schema should treat OKL_RULES_DFF as a descriptive satellite of the rule/rule-group entity.

Key Information Stored

The table contains 59 documented columns in the 12.2.2 physical schema. The columns most relevant to application and reporting work are:

• ID — the surrogate primary key column, constrained by primary key OKL_RULES_DFF_PK. A unique index OKL_RULES_DFF_U1 also exists on ID, making it the documented business-key candidate as well.
• RGP_ID — foreign key referencing OKC_RULE_GROUPS_B, linking each flexfield row to its rule group.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, controlling multi-tenant/security-group access.
• RULE_INFORMATION_CATEGORY and RULE_INFORMATION1 through RULE_INFORMATION15 — the DFF context and segment values that hold the user-defined rule information.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS DFF context/attribute columns.
• OBJECT1_ID1, OBJECT2_ID1, OBJECT3_ID1 and their ID2 counterparts — identification columns for the object(s) the rule applies to.
• JTOT_OBJECT1_CODE, JTOT_OBJECT2_CODE, JTOT_OBJECT3_CODE — object type codes used in join-to-object (JTOT) resolution.
• DNZ_CHR_ID — the associated contract/header identifier.
• STD_TEMPLATE_YN, TEMPLATE_YN, WARN_YN, PRIORITY, DISPLAY_SEQUENCE — flags and sequencing attributes governing template behavior, warnings, evaluation priority, and display order.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS concurrency and audit columns.

Common Use Cases and Queries

Typical usage centers on retrieving rule flexfield data for a given rule group or contract, and reporting on configured rules. A representative join pattern is:

• SELECT d.ID, d.RGP_ID, d.RULE_INFORMATION_CATEGORY, d.RULE_INFORMATION1 FROM OKL_RULES_DFF d WHERE d.RGP_ID = :rgp_id;
• Join to the rule group parent: SELECT d.*, g.* FROM OKL_RULES_DFF d, OKC_RULE_GROUPS_B g WHERE d.RGP_ID = g.ID; A rule-group filter is often applied here: AND g.ID = :p_rule_group.
• Filter by priority or display order for ordered rule rendering: SELECT ID, PRIORITY, DISPLAY_SEQUENCE FROM OKL_RULES_DFF WHERE RGP_ID = :rgp_id ORDER BY PRIORITY, DISPLAY_SEQUENCE;
• Template filtering: SELECT * FROM OKL_RULES_DFF WHERE TEMPLATE_YN = 'Y';
• Security-scoped reporting: SELECT * FROM OKL_RULES_DFF WHERE SECURITY_GROUP_ID = :sg_id;

Because DFF values are stored generically across numbered columns, reporting should resolve the category first (RULE_INFORMATION_CATEGORY) and then select the corresponding segment column, avoiding blind queries across all fifteen segments.

Related Objects

The most significant related objects are those tied by foreign key and the underlying rule tables this table copies:

• OKC_RULE_GROUPS_B — parent rule group; joined via OKL_RULES_DFF.RGP_ID = OKC_RULE_GROUPS_B.ID.
• FND_SECURITY_GROUPS — security group reference; joined via OKL_RULES_DFF.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID.
• OKL_RULES_B — the base rule table of which OKL_RULES_DFF is a Contracts for Lease copy created for Rule DFF definition.
• OKC_RULE_GROUPS_TL — translated rule group names, joined through the same RGP_ID to OKC_RULE_GROUPS_B.
• OKL_RULES_DFF primary key and unique index objects (OKL_RULES_DFF_PK and OKL_RULES_DFF_U1) — index objects supporting joins and lookups on ID.