Search Results hz_credit_usages_u1

Overview

The AR.HZ_CREDIT_USAGES table is a core component of the Oracle E-Business Suite (EBS) Credit Management and Customer Relationship Management (CRM) foundation schema. It records the association between a specific credit limit and a credit usage rule set, thereby defining the coverage scope of any given credit limit. A credit limit's usage may extend to one or more pre-defined credit usage rule sets and their member credit usage rules, allowing organizations to model complex credit exposure scenarios across multiple dimensions of the customer relationship.

In Oracle EBS 12.1.1 and 12.2.2, this table resides in the AR schema under the APPS_TS_TX_DATA tablespace with a PCT_FREE of 10. It is registered under FND Design Data as AR.HZ_CREDIT_USAGES and holds a VALID status. Based on its foreign key structure — a surrogate primary key with four dependent foreign keys referencing profile amount and rule set dimension tables — the heuristic Data Vault classification for this object is a link, suggesting it functions as a transactional association table connecting multiple business entities rather than a standalone hub or satellite.

Key Information Stored

The table contains 30 documented columns. The most significant are:

• CREDIT_USAGE_ID (NUMBER 15) — The surrogate primary key and sole unique identifier for each credit usage record. It is the single column of unique index HZ_CREDIT_USAGES_U1, which serves as the documented business-key candidate.
• CREDIT_PROFILE_AMT_ID (NUMBER 15) — Foreign key to HZ_CREDIT_PROFILE_AMTS. Identifies the credit profile amount that this usage record extends coverage to.
• CUST_ACCT_PROFILE_AMT_ID (NUMBER 15) — Foreign key to HZ_CUST_PROFILE_AMTS. Links the usage to a customer account profile amount.
• PROFILE_CLASS_AMOUNT_ID (NUMBER 15) — Foreign key to HZ_CUST_PROF_CLASS_AMTS. Associates the usage with a customer profile class amount.
• CREDIT_USAGE_RULE_SET_ID (NUMBER 15) — Foreign key to HZ_CREDIT_USAGE_RULE_SETS_B. Identifies the rule set whose member rules define how the associated credit is consumed or applied.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking row creation and modification.
• PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — Concurrent program context columns that identify the process responsible for the row's last update, useful for data lineage audits.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard Oracle EBS flexible attribute (DFF) columns available for customer-specific extensions.

Common Use Cases and Queries

Typical usage centers on resolving how a credit limit maps to its applicable rule sets, and on reproducing credit exposure for reporting. A common query joins the table to its rule set definition:

• Coverage resolution: SELECT cu.credit_usage_id, cu.credit_usage_rule_set_id, rs.rule_set_name FROM hz_credit_usages cu, hz_credit_usage_rule_sets_b rs WHERE cu.credit_usage_rule_set_id = rs.credit_usage_rule_set_id;
• Credit exposure by customer account: joining CUST_ACCT_PROFILE_AMT_ID to HZ_CUST_PROFILE_AMTS to trace which account-level credit limits carry extended usage coverage.
• Audit and reconciliation: filtering on CREATED_BY, CREATION_DATE, or REQUEST_ID to identify which concurrent program inserted or modified usage associations.
• Index-aware access: queries filtering on CREDIT_PROFILE_AMT_ID, CUST_ACCT_PROFILE_AMT_ID, CREDIT_USAGE_RULE_SET_ID, or PROFILE_CLASS_AMOUNT_ID benefit from non-unique indexes HZ_CREDIT_USAGES_N1 through N4.

Related Objects

• HZ_CREDIT_PROFILE_AMTS — Referenced via CREDIT_PROFILE_AMT_ID; defines the credit profile amount.
• HZ_CUST_PROFILE_AMTS — Referenced via CUST_ACCT_PROFILE_AMT_ID; customer account level amounts.
• HZ_CUST_PROF_CLASS_AMTS — Referenced via PROFILE_CLASS_AMOUNT_ID; profile class level amounts.
• HZ_CREDIT_USAGE_RULE_SETS_B — Referenced via CREDIT_USAGE_RULE_SET_ID; defines the rule set governing usage.
• HZ_CREDIT_USAGE_RULES — Member rules belonging to the rule sets referenced by this table.
• FND_USER — Referenced indirectly by CREATED_BY and LAST_UPDATED_BY for audit resolution.