Search Results product_rule_code




Overview
Explore in AI Chat

Overview

XLA_ACCTG_METHOD_RULES is a Subledger Accounting (XLA) configuration table in the Oracle E-Business Suite database. It stores the assignment of Application Accounting Definitions (AADs) to Subledger Accounting Methods. An Accounting Method represents a complete accounting policy — for example, a corporate or local statutory method — and each method is composed of one AAD per application (Payables, Receivables, Assets, and so on). This table records those method-to-AAD associations, acting as the glue between a named accounting method and the AADs that generate the actual journal entries for each subledger.

Functionally, the table is a configuration repository rather than a transaction or accounting-entry table. Rows are created when an Accounting Method is defined or updated through the Subledger Accounting Method setup in the EBS user interface. Because the setup can be changed over time, the table includes effective-dating columns so that historical assignments remain intact for audit and re-processing purposes.

From a Data Vault modeling perspective the ETRM metadata classifies this object heuristically as standalone. In practical terms it behaves most like a link or reference table: it relates an accounting method (identified by ACCOUNTING_METHOD_TYPE_CODE and ACCOUNTING_METHOD_CODE) to a product-level accounting definition rule within a given APPLICATION_ID.

Key Information Stored

The documented physical schema contains 15 columns. The most significant are:

  • ACCTG_METHOD_RULE_ID — Surrogate identifier for each method-to-rule association row; part of the unique index XLA_ACCTG_METHOD_RULES_U1.
  • ACCOUNTING_METHOD_TYPE_CODE — Classifies the method (for example, standard versus custom); part of the primary key.
  • ACCOUNTING_METHOD_CODE — The short name of the Subledger Accounting Method to which the definition is assigned; part of the primary key.
  • APPLICATION_ID — Identifies the subledger application (Payables, Receivables, Assets, etc.) whose AAD is being assigned; part of the primary key.
  • AMB_CONTEXT_CODE — The Application Message Board context under which the accounting definition was created, linking the rule to its owning context.
  • PRODUCT_RULE_TYPE_CODE and PRODUCT_RULE_CODE — Identify the product-level rule (the Application Accounting Definition) assigned within the method, at the level of detail appropriate to the application.
  • START_DATE_ACTIVE and END_DATE_ACTIVE — Effective-date range during which the assignment is active, supporting date-tracked change history.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns.
  • ZD_EDITION_NAME — The edition identifier used by the EBS online patching (Editioning) architecture in Release 12.2; it distinguishes rows across editions and appears in the unique index.

The primary key is XLA_ACCTG_METHOD_RULES_PK (ACCOUNTING_METHOD_TYPE_CODE, ACCOUNTING_METHOD_CODE, APPLICATION_ID, ACCTG_METHOD_RULE_ID).

Common Use Cases and Queries

Typical uses include auditing which AAD is assigned to a given accounting method, comparing methods across environments after a clone or patch, and diagnosing why journal entries are generated differently between two methods. A common query lists active assignments for a method:

  • SELECT accounting_method_code, application_id, product_rule_type_code, product_rule_code, start_date_active, end_date_active FROM xla_acctg_method_rules WHERE accounting_method_code = :method AND sysdate BETWEEN start_date_active AND nvl(end_date_active, sysdate);
  • Join to XLA_ACCTG_METHODS on ACCOUNTING_METHOD_TYPE_CODE and ACCOUNTING_METHOD_CODE to retrieve descriptive method attributes.
  • Join to FND_APPLICATION on APPLICATION_ID to resolve application names for reporting.
  • Compare row counts and rule assignments between a production instance and a test instance to validate a configuration migration.

Because the table is effective-dated, date-range predicates should always be applied when determining the currently active configuration.

Related Objects

  • XLA_ACCTG_METHODS — The parent Accounting Methods table; joins on ACCOUNTING_METHOD_TYPE_CODE and ACCOUNTING_METHOD_CODE.
  • XLA_ACCT_DEFINITIONS / XLA_APPLICATION_ACCOUNTING_DEFS — The Application Accounting Definitions referenced by PRODUCT_RULE_CODE and PRODUCT_RULE_TYPE_CODE.
  • FND_APPLICATION — Resolves APPLICATION_ID to the subledger product name.
  • XLA_LEDGER_ACCTG_METHODS — Associates a ledger with its accounting method, forming the chain ledger → method → AAD.
  • XLA_ACCTG_METHOD_RULES_U1 — Unique index enforcing the ACCTG_METHOD_RULE_ID/ZD_EDITION_NAME key.
  • XLA_ACCT_PROG_ASSIGNMENTS — Program assignments that consume the AAD defined by these rules.