Search Results hz_credit_profile_amts




Overview
Explore in AI Chat

Overview

The HZ_CREDIT_PROFILE_AMTS table is a core data object within the Oracle E-Business Suite (EBS) Receivables (AR) module, specifically within the Trading Community Architecture (TCA) framework. Its primary function is to store detailed credit limit amounts, defined in specific currencies, for customer credit profiles. This table enables the management of multi-currency credit limits, allowing a single customer to have distinct credit authorizations for different transaction currencies. It is a critical component for enforcing credit control policies during order entry and accounts receivable processes in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table stores the monetary values and associated metadata for customer credit limits. While the full column list is not detailed in the provided metadata, the structure centers on the primary key, CREDIT_PROFILE_AMT_ID, which uniquely identifies each currency-specific limit record. The foreign key column, CREDIT_PROFILE_ID, links each record to its parent credit definition in the HZ_CREDIT_PROFILES table. Essential data points stored include the currency code (e.g., USD, EUR) and the corresponding credit limit amount for that currency. Additional columns likely track creation and update dates, the last updated by user, and the program responsible for the last update.

Common Use Cases and Queries

A primary use case is validating available credit for a sales order in the customer's transaction currency. The system queries this table to find the applicable limit and compare it against the total outstanding balance. It is also central to credit management reporting, where analysts review limits across currencies. Common SQL patterns include joining to customer and profile tables to generate summary reports.

  • Retrieving all currency-specific limits for a customer: SELECT * FROM HZ_CREDIT_PROFILE_AMTS WHERE CREDIT_PROFILE_ID = (SELECT CREDIT_PROFILE_ID FROM HZ_CREDIT_PROFILES WHERE CUST_ACCOUNT_ID = :cust_acct_id);
  • Checking a specific currency limit: SELECT CREDIT_LIMIT_AMOUNT FROM HZ_CREDIT_PROFILE_AMTS WHERE CREDIT_PROFILE_ID = :profile_id AND CURRENCY_CODE = :curr_code;

Related Objects

The table exists within a defined hierarchy of credit management objects, as evidenced by its foreign key relationships.

  • HZ_CREDIT_PROFILES: This is the parent table. The foreign key HZ_CREDIT_PROFILE_AMTS.CREDIT_PROFILE_ID references HZ_CREDIT_PROFILES. Each record in HZ_CREDIT_PROFILE_AMTS must belong to a single, master credit profile.
  • HZ_CREDIT_USAGES: This is a child table. The foreign key HZ_CREDIT_USAGES.CREDIT_PROFILE_AMT_ID references HZ_CREDIT_PROFILE_AMTS.CREDIT_PROFILE_AMT_ID. This relationship tracks the utilization or application of a specific currency limit, potentially linking it to transactions or credit check events.