Search Results hz_credit_profile_amts




Overview
Explore in AI Chat

Overview

HZ_CREDIT_PROFILE_AMTS is a Receivables (AR) transactional table that stores credit limits expressed in specific currencies for a given credit profile. In Oracle EBS 12.1.1 and 12.2.2, the table sits at the intersection of the credit management model managed by the Customer Relationship Management (Trading Community Architecture, "HZ") and the Receivables credit checking engine. Each row associates one credit profile with a single currency and the monetary ceilings that apply when transactions are evaluated against that profile.

Under heuristic Data Vault classification, the metadata suggests a satellite-leaning role. The table is anchored to HZ_CREDIT_PROFILES through CREDIT_PROFILE_ID and carries descriptive, currency-qualified measures (credit limit amounts). This pattern is characteristic of a satellite: the parent profile acts as the hub-like entity, while HZ_CREDIT_PROFILE_AMTS holds the changing, multi-valued attributes keyed by currency.

Key Information Stored

The table is defined in the AR schema with 30 documented columns. The primary key, constrained by HZ_CREDIT_PROFILE_AMTS_PK, is the surrogate identifier CREDIT_PROFILE_AMT_ID. A unique index, HZ_CREDIT_PROFILE_AMTS_U1, also exists on CREDIT_PROFILE_AMT_ID, confirming it as the principal key. CREDIT_PROFILE_ID is the foreign key linking each row back to its owning credit profile in HZ_CREDIT_PROFILES and functions as the business-key candidate for the parent entity.

  • CURRENCY_CODE — the ISO currency in which the credit limits are denominated, allowing a single profile to hold limits in multiple currencies.
  • TRX_CREDIT_LIMIT — the transaction-level credit limit applied per currency, used by the credit checking engine for individual transactions.
  • OVERALL_CREDIT_LIMIT — the aggregate credit ceiling across exposures for the profile in the specified currency, governing the total outstanding balance permitted.
  • CREDIT_PROFILE_ID — the foreign key to the parent credit profile, establishing ownership and join path.
  • CREDIT_PROFILE_AMT_ID — the surrogate primary key and unique business identifier of the amount row.

The remaining columns are standard Oracle EBS who-columns and audit/control fields: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and the concurrent program/integration columns PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID. Fifteen descriptive ATTRIBUTE columns (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15) provide extensibility for customer-specific data.

Common Use Cases and Queries

Typical usage centers on credit exposure analysis, currency-specific limit review, and integration with order and receivables credit checking. Analysts frequently join amounts to profiles to report the effective limits by customer and currency.

  • Retrieving all currency limits for a profile: SELECT currency_code, trx_credit_limit, overall_credit_limit FROM hz_credit_profile_amts WHERE credit_profile_id = :profile_id;
  • Reconciling usage against limits by joining HZ_CREDIT_USAGES on CREDIT_PROFILE_AMT_ID.
  • Reporting total available credit per currency by comparing overall credit limits with exposed balances in OE_CREDIT_BALANCES_ALL.
  • Auditing changes through LAST_UPDATE_DATE and the audit who-columns for compliance reporting.

Related Objects

The table participates in a defined set of relationships:

  • HZ_CREDIT_PROFILES — parent table referenced via HZ_CREDIT_PROFILE_AMTS.CREDIT_PROFILE_ID.
  • HZ_CREDIT_USAGES — references this table through HZ_CREDIT_USAGES.CREDIT_PROFILE_AMT_ID, capturing usage against a specific amount row.
  • OE_CREDIT_BALANCES_ALL — references this table via OE_CREDIT_BALANCES_ALL.CREDIT_PROFILE_AMT_ID, aligning order management credit balances with the profile amount.

Together these relationships place HZ_CREDIT_PROFILE_AMTS as the currency-level detail supporting credit limit enforcement across Receivables and Order Management.