Search Results get_limit_currency_usages

Overview

The APPS.HZ_CREDIT_USAGES_PKG package is a foundational PL/SQL component within the Oracle EBS Trading Community Architecture (TCA) credit management subsystem. Its primary business function is to record, retrieve, and validate the consumption of credit exposure against a customer's approved credit limits and usage rules. In essence, it maintains the relationship between a customer's credit profile, the amounts authorized through credit rules, and the actual credit usage accumulated through order and receivables activity.

Within EBS 12.1.1 and 12.2.2, this package supports Advanced Credit Management functionality by providing the data access layer for credit usage records. It enables downstream credit check processes to determine whether a customer has available credit before orders are booked or transactions are committed, and it supplies the usage detail consumed by credit management utilities such as AR_CMGT_UTIL and AR_CMGT_AGING. The package is classified as an internal data management API (API classification: OTHER) rather than a formally published public API.

Key Procedures and Functions

The documented package exposes six procedures and functions that form its operational surface:

• CHECK_RELEASE — Evaluates and releases credit usage that is no longer required, ensuring that consumed exposure is properly returned to the customer's available credit pool when the underlying obligation is satisfied or reversed.
• INSERT_ROW — Creates a new credit usage record, capturing the incremental usage applied against a customer's credit profile.
• DELETE_ROW — Removes a credit usage record, typically invoked during reversal or correction processing.
• LOCK_ROW — Acquires a lock on a credit usage record to preserve concurrency integrity when multiple credit management processes act simultaneously.
• GET_LIMIT_CURRENCY_USAGES — Returns credit usage aggregated and expressed in the currency of the applicable credit limit, supporting multi-currency credit exposure evaluation.
• GET_USAGE_RULES — Retrieves the usage rules that govern how credit consumption is calculated and applied for a given credit profile.

These routines collectively provide the create, read, delete, and concurrency-control operations required by credit management consumers.

Tables Accessed

The package reads from and writes to the core TCA credit tables, resolved through APPS synonyms:

• HZ_CREDIT_PROFILE_AMTS and HZ_CUST_PROFILE_AMTS — Store the credit limit and profile amount definitions against which usage is measured.
• HZ_CREDIT_USAGES — The primary transaction table recording consumed credit amounts.
• HZ_CREDIT_USAGE_RULES and HZ_CREDIT_USAGE_RULE_SETS_B — Provide the rule definitions and rule sets that determine how usage is derived and applied.
• HZ_CUSTOMER_PROFILES — Links usage to the customer profile context.
• PLITBLM — The standard Oracle PL/SQL integer table type used for bulk collection handling within the package logic.

Usage Notes

HZ_CREDIT_USAGES_PKG is an internal package and is referenced by the credit management utility and aging packages AR_CMGT_UTIL, AR_CMGT_DATA_POINTS_PKG, and AR_CMGT_AGING, as well as recursively by itself. Users searching on ar_cmgt_util will find this package because the credit management utility depends upon it.

Invocation typically occurs indirectly through credit management concurrent programs, credit check logic, and the Credit Management workbench, rather than through direct form-level calls. Custom code should exercise caution: because the package is not a formally published API and is subject to change across releases, direct calls should be limited to read-only operations such as GET_LIMIT_CURRENCY_USAGES and GET_USAGE_RULES, with write operations left to standard Oracle credit management flows.