Search Results currency_list

Overview

OE_CREDIT_CHECK_PVT is a private PL/SQL package in the Oracle Order Management (OM) module of Oracle E-Business Suite, owned by the APPS schema. It encapsulates the core credit-checking logic used by Order Management to evaluate a customer's credit standing at the time a sales order or order line is entered, priced, or booked. The package resolves credit limits and current credit exposure for a given customer account or ship-to site, and returns the information required by the order entry flow to decide whether an order may proceed or must be held for credit review. Because the package is classified as PVT (private), it is intended for internal use by other Order Management APIs and forms rather than as a formally supported public integration interface. In 12.1.1 and 12.2.2 the package resides in the APPS schema and operates against the trading community (HZ) credit model introduced with the multiple-organization / multi-org architecture and the successor to the legacy customer credit tables.

Key Procedures and Functions

• GET_LIMIT_INFO — Returns credit limit information for a customer or a specific site. It resolves the limit currency, transaction currency limit, overall limit, and flags indicating whether a default limit applies, whether all usages are included, and whether a credit check is required. It accepts the order header identifier and entity (customer or site) context and returns the assembled limit and usage information.
• GET_USAGES — Returns the credit usages applicable to the entity under evaluation. This proc exposes the current exposure amounts (for example, open order value and receivables balances) that are compared against the applicable limit.
• GET_ITEM_LIMIT — Returns credit limit information at the inventory item level, supporting item-specific credit limits configured for a customer.
• CURRENCY_LIST — Returns the list of currencies relevant to the credit profile, allowing the caller to interpret multi-currency credit limits and exposures.

Tables Accessed

• HZ_CREDIT_PROFILE_AMTS — The Trading Community credit profile amounts table. It holds the credit limit amounts, currency codes, and related credit profile attributes for a customer account or site. OE_CREDIT_CHECK_PVT reads this table to resolve limit currency and limit amounts; the package column reference to HZ_CREDIT_PROFILE_AMTS.currency_code confirms a direct dependency.
• PLITBLM — Referenced via APPS synonym; used in the order/credit checking process to obtain the item master information needed for item-level limit evaluation.

Usage Notes

OE_CREDIT_CHECK_PVT is invoked by Order Management during order entry and order booking, where credit checking is controlled by the OM profile options and the Order Management credit checking setup. It is referenced by one other APPS package, indicating that the order-entry API stack calls this package internally rather than exposing it directly. Typical invocation paths include the Sales Order form credit check, the Order Management concurrent programs that process or re-check orders, and custom PL/SQL that reproduces the standard credit exposure and limit calculation. Because the package is private and its signature is subject to change between releases, customizations should generally call the supported public Order Management APIs (such as the order entry/import APIs) or the credit check wrapper routines, rather than invoking OE_CREDIT_CHECK_PVT procedures directly. Developers extending credit logic should also account for the HZ credit profile model, since limit amounts and currency checks are sourced from HZ_CREDIT_PROFILE_AMTS.