Search Results jg_zz_ta_rule_sets




Overview
Explore in AI Chat

Overview

JG_ZZ_TA_RULE_SETS is a table in the GL schema that stores the header information for each Journal Allocation Rule Set within the JG (Regional Localizations) product family of Oracle E-Business Suite. In Oracle EBS 12.1.1 and 12.2.2, this object serves as the master definition point for allocation rule sets — the top-level container that groups individual journal allocation rules and governs how costs, revenues, or balances are distributed across accounts. The record for a given rule set defines its name, enabled status, chart of accounts context, and the partial allocation behavior applied when an allocation cannot be fully distributed. It is a definitional, setup-oriented table rather than a transactional one, and is most commonly accessed during allocation configuration, rule set maintenance, and diagnostics of allocation execution.

From a data modeling perspective, the mined heuristic classification places this object as a standalone entity. Under a Data Vault interpretation, it would most naturally be modeled as a hub for the rule set business concept, with descriptive attributes forming an attached satellite. The absence of inbound foreign keys in the documented relationship data reinforces its role as a parent or reference anchor rather than a dependent link table.

Key Information Stored

The table contains 27 documented columns. The most significant are listed below, distinguishing the surrogate key from business-key candidates.

  • RULE_SET_ID — The surrogate primary key. It is enforced by unique index JG_ZZ_TA_RULE_SETS_U1 and is the value referenced when linking this header to its child rule and allocation records.
  • CHART_OF_ACCOUNTS_ID and NAME — Together these form the business-key candidate enforced by unique index JG_ZZ_TA_RULE_SETS_U2. The chart of accounts scopes the rule set to a specific accounting structure, while NAME is the user-visible identifier of the rule set.
  • ENABLED_FLAG — Controls whether the rule set is active and therefore eligible for allocation processing.
  • PARTIAL_ALLOCATION — Governs the behavior when an allocation cannot be fully distributed, determining whether partial results are posted or the run is rejected.
  • ACCOUNT_TYPE — Indicates the account classification the rule set targets, guiding which balances are eligible for allocation.
  • CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — The standard Oracle EBS descriptive flexfield (DFF) columns, providing extensible, customer-defined attributes on the rule set header.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns recording creation and last modification metadata.

Common Use Cases and Queries

Typical uses include listing active rule sets for a chart of accounts, auditing setup changes, and joining header data to child allocation rules for reporting.

Retrieving enabled rule sets for a specific chart of accounts:

  • SELECT rule_set_id, name, partial_allocation, account_type FROM gl.jg_zz_ta_rule_sets WHERE chart_of_accounts_id = :coa_id AND enabled_flag = 'Y';

Auditing recently modified configurations using the WHO columns:

  • SELECT rule_set_id, name, last_updated_by, last_update_date FROM gl.jg_zz_ta_rule_sets ORDER BY last_update_date DESC;

Reporting on DFF usage:

  • SELECT rule_set_id, name, context, attribute1, attribute2 FROM gl.jg_zz_ta_rule_sets WHERE context IS NOT NULL;

Related Objects

The documented foreign key relationship indicates that JG_ZZ_TA_RULE_SETS.CHART_OF_ACCOUNTS_ID references GL_MGT_SEG_UPGRADE_H, tying each rule set to a chart of accounts upgrade record. Beyond this documented FK, the following objects are the most significant related and dependent entities:

  • GL_MGT_SEG_UPGRADE_H — Referenced via CHART_OF_ACCOUNTS_ID; supplies chart of accounts context.
  • Child allocation rule tables in the JG_ZZ_TA family — Joined on RULE_SET_ID as the parent header for individual allocation rules and rule lines.
  • FND_FLEX_VALUES / FND_ID_FLEX_STRUCTURES — Provide the valid chart of accounts and flexfield structure definitions referenced by CHART_OF_ACCOUNTS_ID.
  • FND_USER — Resolves the CREATED_BY and LAST_UPDATED_BY audit columns to user names.
  • FND_DESCRIPTIVE_FLEXS — Defines the structure of the CONTEXT and ATTRIBUTE1–15 DFF columns.

Because the object is definitional and standalone, the primary integration path is through RULE_SET_ID as the parent key linking to child rule and allocation detail tables.