Search Results xla_seg_rules_b_pk

Overview

XLA_SEG_RULES_B is the base (non-translated) table in the Oracle Subledger Accounting (XLA) schema that stores account derivation rules. Account derivation is the mechanism by which Subledger Accounting determines the individual Accounting Flexfield segment values that populate the accounts generated for subledger journal entries. Each row in XLA_SEG_RULES_B defines a named segment rule that resolves one or more segments of the accounting flexfield, based on the transaction's chart of accounts, mapping rules, or fixed values. These derivation rules are subsequently attached to an accounting line type, so that when an accounting program creates a journal line, the appropriate rule is invoked to derive the account.

The table resides in the XLA schema and is identified in the ETRM documentation at the 12.2.2 release with 18 documented columns. Its heuristic Data Vault classification, mined from the foreign-key structure, is standalone: no outbound links to other hubs were detected, so the object is best modeled as an independent reference/business-rule entity rather than as a dependent satellite of another key. This classification should be treated as a modeling suggestion only, since the derivation rules are logically referenced by accounting line type configurations that are not captured as physical foreign keys in the documented metadata.

Key Information Stored

The surrogate primary key, XLA_SEG_RULES_B_PK, is a composite of four columns: APPLICATION_ID, AMB_CONTEXT_CODE, SEGMENT_RULE_TYPE_CODE, and SEGMENT_RULE_CODE. A parallel unique index, XLA_SEG_RULES_B_U1, extends this set with ZD_EDITION_NAME, which is the business-key candidate in a multi-edition (ZD) environment where edition-enabled objects may hold more than one active definition.

• APPLICATION_ID — identifies the owning application, scoping the rule to a subledger product area.
• AMB_CONTEXT_CODE — the Application Accounting Definition context, tying the rule to a specific subledger application accounting definition.
• SEGMENT_RULE_TYPE_CODE — the category of segment derivation rule (for example, mapping-based or full account derivation).
• SEGMENT_RULE_CODE — the user-defined identifier of the segment rule, completing the key.
• TRANSACTION_COA_ID and ACCOUNTING_COA_ID — the source chart of accounts and the target accounting chart of accounts the rule maps between.
• FLEXFIELD_ASSIGN_MODE_CODE — indicates how the flexfield segment is assigned (for instance, to the segment itself or to a source reference).
• FLEXFIELD_SEGMENT_CODE — the specific accounting flexfield segment to which the rule applies.
• FLEX_VALUE_SET_ID — the value set that constrains or supplies valid segment values.
• ENABLED_FLAG — indicates whether the rule is active.
• VERSION_NUM and UPDATED_FLAG — support versioning and propagation of rule changes.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

A frequent requirement is to audit which segment derivation rules are enabled for a given application and context, or to trace why a particular account was derived. Typical patterns include:

• Locating rules by application and context: SELECT segment_rule_code, segment_rule_type_code, flexfield_segment_code, enabled_flag FROM xla_seg_rules_b WHERE application_id = :app AND amb_context_code = :ctx;
• Checking derivation rules mapped between two charts of accounts using TRANSACTION_COA_ID and ACCOUNTING_COA_ID.
• Verifying the value set bound to a segment via FLEX_VALUE_SET_ID when troubleshooting invalid accounting combinations.
• Reviewing disabled or versioned rules through ENABLED_FLAG, VERSION_NUM, and UPDATED_FLAG for change-management reporting.

Reporting on these rows supports subledger accounting configuration reviews, upgrade impact analysis, and account-derivation troubleshooting.

Related Objects

• XLA_SEG_RULES_TL — the translated table holding language-specific rule descriptions, joined on the primary-key columns APPLICATION_ID, AMB_CONTEXT_CODE, SEGMENT_RULE_TYPE_CODE, and SEGMENT_RULE_CODE.
• XLA_ACCT_LINE_TYPES_B / _TL — accounting line types to which the derivation rules are attached.
• XLA_AMB_HEADERS — the Application Accounting Definition header referenced by AMB_CONTEXT_CODE.
• FND_FLEX_VALUE_SETS — source of the value set referenced by FLEX_VALUE_SET_ID.
• FND_ID_FLEX_STRUCTURES / FND_ID_FLEX_SEGMENTS — define the accounting flexfields referenced by TRANSACTION_COA_ID and ACCOUNTING_COA_ID.
• XLA_ACCOUNTING_ERRORS — records derivation failures that trace back to missing or invalid segment rules.