Results for “okl_disb_rules_all_b”

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

Overview

OKL_DISB_RULES_ALL_B is a core configuration and transaction-support table within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It stores the disbursement rules used to consolidate disbursement transactions for lease and loan contracts. A disbursement rule defines how payable amounts are grouped and released to vendors, including timing, fee treatment, and stream-type consolidation criteria. Because the table is partitioned by operating unit through ORG_ID, the "_ALL_" naming convention reflects its multi-organization design, allowing each business entity to maintain its own rule set.

Under a heuristic Data Vault classification mined from the foreign-key structure, this object would be modeled as a standalone hub, since it is referenced by dependent child tables rather than acting as a link or satellite itself. This is a modeling suggestion only; in native EBS form the table is a conventional transactional configuration entity with a surrogate primary key and a unique business key.

Key Information Stored

The table contains 36 documented columns. The most significant are listed below.

• DISB_RULE_ID — Surrogate primary key, backed by the OKL_DRA_PK constraint. This is the value propagated to child tables.
• RULE_NAME — Business identifier for the disbursement rule; paired with ORG_ID in unique index OKL_DRA_U01.
• ORG_ID — Operating unit owning the rule; the second column of the unique business key.
• OBJECT_VERSION_NUMBER — Optimistic locking column supporting concurrent update control.
• START_DATE / END_DATE — Effective dating that governs when the rule applies.
• FEE_OPTION, FEE_BASIS, FEE_AMOUNT, FEE_PERCENT — Define how fees are calculated and applied when disbursements are consolidated.
• CONSOLIDATE_BY_DUE_DATE — Flag controlling whether transactions are grouped by due date.
• FREQUENCY, DAY_OF_MONTH, SCHEDULED_MONTH — Scheduling attributes for periodic disbursement runs.
• CONSOLIDATE_STRM_TYPE — Indicates whether consolidation is grouped by stream type.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Flexfield-style descriptive columns for customer extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

Disbursement rules are typically queried to validate configuration prior to running disbursement consolidation for a lease portfolio, and to audit which fees and schedules apply to a given operating unit. Reporting frequently joins rules to their child detail tables to profile vendor sites and stream-type exclusions.

A representative lookup by business key:

• SELECT disb_rule_id, rule_name, fee_option, fee_basis, frequency, day_of_month FROM okl_disb_rules_all_b WHERE rule_name = :rule_name AND org_id = :org_id;

A typical active-rule report respecting effective dates:

• SELECT rule_name, start_date, end_date, consolidate_by_due_date FROM okl_disb_rules_all_b WHERE org_id = :org_id AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE) ORDER BY rule_name;

Related Objects

The following objects reference OKL_DISB_RULES_ALL_B through the DISB_RULE_ID foreign key and are the most significant dependents for query and integration purposes.

• OKL_DISB_RULE_VENDOR_SITES — Joins on DISB_RULE_ID; defines the vendor sites eligible under each disbursement rule.
• OKL_DISB_RULE_STY_TYPES — Joins on DISB_RULE_ID; defines the stream types associated with a rule for consolidation grouping.

Related OKL disbursement and contract tables, plus the Leasing Management APIs that read rule configuration during disbursement processing, complete the dependency chain. When writing extraction or audit queries, join on DISB_RULE_ID and filter by ORG_ID to respect multi-organization security.