Search Results hz_credit_usage_rule_sets_b




Overview
Explore in AI Chat

Overview

The HZ_CREDIT_USAGE_RULE_SETS_B table is a core data structure within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Receivables (AR) module. It functions as the master definition table for logical groupings of credit usage rules. These rule sets are central to the application's credit management framework, allowing administrators to define and associate specific business rules that govern how a customer's available credit is consumed during order entry and invoicing. The table stores information in the base installation language, with translations managed through a related descriptive flexfield (DFF) or translatable table.

Key Information Stored

The primary data stored in this table revolves around the identification and control of a rule set. The most critical column is the CREDIT_USAGE_RULE_SET_ID, which serves as the unique primary key identifier for each rule set. While the provided ETRM metadata does not list all columns, typical attributes for such a base table would include a RULE_SET_NAME or code, creation and last update dates (CREATION_DATE, LAST_UPDATE_DATE), and the corresponding user IDs (CREATED_BY, LAST_UPDATED_BY). The table's purpose is to act as a parent container; the specific rules within a set are defined in the related HZ_CREDIT_USAGE_RULES table.

Common Use Cases and Queries

This table is primarily accessed during the configuration and application of credit policies. A common use case involves querying to identify which rule set is assigned to a specific customer's credit profile or to audit the configuration of credit management. Sample SQL patterns include joining to related tables to see the full structure of a rule set.

  • Listing all defined credit usage rule sets: SELECT credit_usage_rule_set_id FROM ar.hz_credit_usage_rule_sets_b;
  • Finding the rule set applied to a specific customer credit profile (joining through HZ_CREDIT_USAGES): SELECT cus.credit_usage_rule_set_id FROM hz_credit_usages cus, hz_cust_accounts cust WHERE cus.cust_account_id = cust.cust_account_id AND cust.account_number = 'CUST123';

Related Objects

The HZ_CREDIT_USAGE_RULE_SETS_B table has defined foreign key relationships with several key objects in the Trading Community Architecture (TCA) and Receivables schema, as documented in the ETRM metadata.

  • HZ_CREDIT_USAGES: This table references HZ_CREDIT_USAGE_RULE_SETS_B via CREDIT_USAGE_RULE_SET_ID. It links a specific customer credit profile to the rule set that governs it.
  • HZ_CREDIT_USAGE_RULES: This child table references HZ_CREDIT_USAGE_RULE_SETS_B via CREDIT_USAGE_RULE_SET_ID. It stores the individual rules (e.g., "Use open invoices," "Use open orders") that constitute the parent rule set.
  • HZ_CREDIT_USAGE_RULE_SETS_TL: This translatable table references HZ_CREDIT_USAGE_RULE_SETS_B via CREDIT_USAGE_RULE_SET_ID. It holds the translated names and descriptions for the rule sets in multiple languages.