Search Results xla_prod_rule_hash_s

Overview

XLA_CMP_HASH_PKG is an Oracle E-Business Suite package body owned by the APPS schema that supports the Subledger Accounting (XLA) engine's product rule comparison and hash-identifier infrastructure. Its role is to compute, store, and retrieve hash identifiers that represent combinations of accounting product rules. These hash values are persisted in the XLA_PROD_RULE_HASH_S table and are used by the Create Accounting and Transfer to General Ledger processes to detect whether the set of applicable product rules has changed since a prior run, thereby enabling efficient re-processing and caching of accounting rule evaluation results.

The object resides in the APPS schema and carries a VALID status in both 12.1.1 and 12.2.2. It is a private implementation package rather than a published API; the ETRM classification is OTHER, indicating it is not part of the public, supported API surface. It references XLA_LOOKUPS_PKG, XLA_EXCEPTIONS_PKG, and FND_LOG for lookup resolution, exception raising, and diagnostic logging respectively, and it depends on the XLA_PRODUCT_RULES_B and XLA_PRODUCT_RULES_TL base and translation tables.

Key Procedures and Functions

• BUILDPACKAGENAME — Internal helper that constructs the fully qualified package name used during dynamic SQL generation and error/exception message construction. This ensures consistent identification of the package in logs and raised exceptions.
• DROPPADPKG — Administrative routine that drops the dynamically generated package (the "PAD" package) associated with product rule processing. It is used during cleanup or regeneration of the cached rule-handling package.
• GETPADHASHID — Core function that returns the hash identifier for a given combination of product rules. It queries XLA_PROD_RULE_HASH_S to retrieve the stored hash, and is the primary entry point used by callers searching for "xla_prod_rule_hash_s" related functionality.
• One additional documented procedure/function — The ETRM metadata notes four documented program units in total; the remaining unit supports the internal hashing/package-build workflow and is not exposed for direct invocation.

Tables Accessed

• XLA_PROD_RULE_HASH_S — The central table for this package. It stores the generated hash identifiers keyed to product rule combinations; GETPADHASHID reads from it, and the build routines insert or maintain its rows.
• XLA_PRODUCT_RULES_B — Supplies the base definition of accounting product rules whose combinations are hashed.
• XLA_PRODUCT_RULES_TL — Provides translated rule names and descriptions, referenced when building the package or generating diagnostic output.
• DUAL — Used for singleton evaluations and PL/SQL expression checks.

Usage Notes

XLA_CMP_HASH_PKG is invoked internally by the Subledger Accounting program stack, notably during Create Accounting, when the engine determines whether cached product rule representations remain valid. It is not a supported public API and should not be called directly from custom code; the ETRM metadata indicates it is referenced by three other packages but does not reference any object outside the XLA and FND families. Because it writes to the XLA_PROD_RULE_HASH_S table, concurrent regeneration should be avoided, and diagnostics are emitted through FND_LOG for troubleshooting. In 12.2.2 the package behavior is functionally consistent with 12.1.1, with the same VALID status and dependency set.