Search Results get_customer_exposure

Overview

The APPS.OE_CREDIT_EXPOSURE_PUB package is a public (PUB-classified) PL/SQL API within the Oracle Order Management (OM) module of Oracle E-Business Suite. Its principal business function is to calculate a customer's total credit exposure and to disaggregate that exposure into its constituent components — Order Management commitments, Accounts Receivable balances, and external amounts — according to the active credit check rule. This calculation underpins the Credit Checking feature in Order Management, allowing the application to determine whether a new or existing order should be placed on credit hold or released, based on the customer's limit and outstanding exposure.

The package is owned by the APPS schema and is documented under the ETRM 12.2.2 metadata with a single documented procedure, reflecting both the original 12.1.1 and later 12.2.2 releases. Its design emphasis is on segregating exposure by source so that credit rules can be applied selectively against OM orders, AR invoices, or external (non-EBS) exposure amounts.

Key Procedures and Functions

The package exposes one documented procedure:

• GET_CUSTOMER_EXPOSURE — Per the embedded source header, this procedure returns the total credit exposure together with the individual balance components for Order Management and Accounts Receivable, driven by the credit check rule. It is described in the source as an overloaded version of the Get_customer_exposure API, and the documentation explicitly states that this overload is intended to replace the original Get_customer_exposure for all new references, while the original method is retained for backward compatibility. The procedure accepts identifiers for the party, customer, and site, along with the limit currency code and the applicable credit check rule ID, and returns the total exposure, order hold amount, order amount, AR amount, external amount, and a return status. The parameter list is not reproduced here beyond the documented signature elements.

Tables Accessed

The ETRM metadata for this package does not enumerate specific underlying tables accessed through APPS synonyms; it only indicates that the API reads and returns exposure figures. Based on its documented purpose, the procedure resolves exposure by querying Order Management order and hold data (for the OM amount and hold amount), Accounts Receivable transaction and balance data (for the AR amount), and stored external amounts configured for the customer or site. The credit check rule ID governs which components are included in the returned totals. Because the metadata lists no explicit table dependencies for this package, direct verification of the underlying views and synonyms should be performed against the deployed 12.1.1 or 12.2.2 environment when building integrations.

Usage Notes

The procedure is typically invoked from Order Management forms during order entry and order save processing, from the credit checking engine, and from custom extensions that need to reproduce or extend the standard exposure calculation. Because the package is classified as PUB, it is supported for customer-facing API integration, unlike private (PVT) packages which are subject to change without notice.

Custom code should call the overloaded GET_CUSTOMER_EXPOSURE within OE_CREDIT_EXPOSURE_PUB rather than the legacy method referenced in the backward-compatibility note. The metadata records that this package is referenced by one other package, indicating reuse within the Credit Management stack. Callers should always inspect the returned x_return_status before using the exposure amounts, and should pass the correct credit check rule ID so that the returned figures reflect the intended rule set.