Search Results jg_zz_ta_rule_sets_v




Overview
Explore in AI Chat

Overview

JG_ZZ_TA_RULE_SETS_V is a read-only view owned by the APPS schema in Oracle E-Business Suite. It resides in the JG product family, which delivers Regional Localizations functionality, and is classified in the E-Business Tables and Views Reference (ETRM) as a VALID object in both release 12.1.1 and 12.2.2. The view presents the header-level definition of transaction allocation rule sets, exposing core setup attributes alongside descriptive flexfield context and attribute columns. Because the JG localization layer sits beneath country-specific statutory features, this view supplies the rule set definition that drives how amounts are apportioned across accounting distributions during transaction processing.

For reporting and integration purposes, the view serves as a denormalized presentation layer. Rather than requiring report authors or interface programs to resolve chart of accounts names and lookup descriptions manually, the view performs those joins internally and returns human-readable values for the chart of accounts structure and the account type. This simplifies custom extracts, concurrent program queries, and inbound or outbound interface logic that needs to enumerate allocation rule sets.

Underlying Base Objects

The view is defined over three documented base objects. The driving object is JG_ZZ_TA_RULE_SETS, accessed in the APPS schema, which supplies the rule set identifier, name, partial allocation indicator, enabled flag, account type code, chart of accounts identifier, the standard WHO audit columns, and the fifteen descriptive flexfield attribute columns plus the CONTEXT column. The synonym reference confirms that the view is a thin projection intended to expose that table in a display-ready form.

The second object is FND_ID_FLEX_STRUCTURES_VL, the application object library view of key flexfield structures. The join condition equates RS.CHART_OF_ACCOUNTS_ID to FL.ID_FLEX_NUM and restricts FL.ID_FLEX_CODE to 'GL#', which ensures that only General Ledger chart of accounts structures are returned and that the ID_FLEX_STRUCTURE_NAME column resolves to the correct accounting structure name. The third object is GL_LOOKUPS, the General Ledger lookup view. It is joined with an outer join (indicated by the (+) operator) on RS.ACCOUNT_TYPE = LK.LOOKUP_CODE, with the lookup type defaulted through NVL(LK.LOOKUP_TYPE, 'ACCOUNT TYPE') = 'ACCOUNT TYPE'. This outer join guarantees that a rule set row is still returned even when no matching lookup description exists for its account type code.

Key Columns

  • ROW_ID — the ROWID of the base rule set row, providing a physical row locator.
  • RULE_SET_ID — the unique identifier of the allocation rule set; the primary join key to detail-level rule and allocation tables.
  • NAME — the user-defined name of the rule set.
  • ID_FLEX_STRUCTURE_NAME — the chart of accounts structure name, resolved from FND_ID_FLEX_STRUCTURES_VL.
  • PARTIAL_ALLOCATION — the flag or indicator controlling whether allocation is performed on a partial basis; this is the column most frequently referenced in searches for "partial_allocation".
  • ENABLED_FLAG — indicates whether the rule set is active and therefore eligible for use in allocation processing.
  • ACCOUNT_TYPE — the account type code associated with the rule set.
  • ACCOUNT_TYPE_DISP — the descriptive lookup value corresponding to ACCOUNT_TYPE, supplied by GL_LOOKUPS.
  • CHART_OF_ACCOUNTS_ID — the identifier of the chart of accounts used by the rule set.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN track creation and maintenance history.
  • CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield context and segment values, enabling localization-specific extensions.

Common Use Cases and Queries

The view is typically queried to audit rule set definitions, to report which rule sets permit partial allocation, and to feed integration programs that must resolve structure and lookup descriptions. The most direct query addressing the partial allocation attribute is:

SELECT rule_set_id, name, id_flex_structure_name, partial_allocation, enabled_flag, account_type_disp FROM apps.jg_zz_ta_rule_sets_v WHERE partial_allocation = 'Y' AND enabled_flag = 'Y' ORDER BY name;

To list all enabled rule sets for a specific chart of accounts, restrict on CHART_OF_ACCOUNTS_ID, which reflects the accounting structure identifier. When building extracts, include CONTEXT and the ATTRIBUTE columns only if the deployment uses the flexfield, since these columns may otherwise be null. Because the view applies an outer join to GL_LOOKUPS, ACCOUNT_TYPE_DISP may be null for account type codes that lack a lookup entry; reports should use NVL or an equivalent default. All queries should be issued against the APPS schema or through a synonym visible to the reporting user, and access should be governed by the standard EBS security model.