Search Results calc_aging_buckets

Overview

AR_CMGT_AGING is an Oracle EBS Receivables (AR) PL/SQL package owned by the APPS schema. Its business purpose is the calculation and population of aging bucket information used by Oracle Credit Management. The package evaluates customer receivable balances and credit exposure, distributing open items and outstanding transactions into configurable aging periods such as current, 1–30, 31–60, 61–90, and over-90 days. These results support credit reviews, credit limit analysis, and the periodic reassessment that determines whether a customer's creditworthiness warrants an increase, hold, or reduction of their credit line. The package resides in the Oracle Credit Management execution stack and operates closely alongside the credit data-point framework, supplying the quantitative aging metrics that drive scoring and review decisions. In Oracle EBS 12.1.1 and 12.2.2 installations, the object status is VALID under the APPS schema and is classified as an OTHER-type API rather than a public open interface.

Key Procedures and Functions

The ETRM metadata documents a single entry point for this package:

• CACL_AGING_BUCKETS — The documented procedure responsible for computing aging bucket values. It aggregates receivable balances by bucket definitions and writes the resulting credit-usage data for downstream processing. As the sole documented program unit in this package, it encapsulates the core aging logic used by the Credit Management subsystem. The metadata does not expose a parameter list, so invocation details are governed by the surrounding credit management framework rather than a published standalone signature.

Tables Accessed

The package reads and, in places, writes to the following documented tables and views (referenced through APPS synonyms):

• AR_PAYMENT_SCHEDULES_ALL — The primary source of open receivable balances and due dates used to determine item age.
• AR_RECEIVABLE_APPLICATIONS_ALL and AR_ADJUSTMENTS_ALL — Applied receipts and adjustments that reduce outstanding balances before aging is calculated.
• AR_AGING_BUCKETS and AR_AGING_BUCKET_LINES — The bucket and line definitions that establish the aging periods applied to balances.
• AR_TRX_BAL_SUMMARY — Summarized transaction balance data used to accelerate balance retrieval.
• AR_CMGT_CURR_USAGE_GT — A global temporary table that holds current credit usage results during processing.
• HZ_CREDIT_USAGE_RULE_SETS_B, HZ_CUST_ACCOUNTS, and HZ_HIERARCHY_NODES — Trading community credit rules, customer account records, and hierarchy relationships that scope the aging computation to the correct party or account.
• DUAL — Used for single-row arithmetic and control constructs.

The metadata further notes that the package depends on SYS.STANDARD and is referenced by ARP_BF_BILL, AR_CMGT_DATA_POINTS_PKG, and by AR_CMGT_AGING itself, indicating internal recursion or shared internal logic and integration with the credit data-point collection layer.

Usage Notes

AR_CMGT_AGING is typically invoked indirectly rather than called directly by end users. It is exercised during Oracle Credit Management operations — including credit review data collection, credit analysis runs, and data-point computation performed by AR_CMGT_DATA_POINTS_PKG and ARP_BF_BILL. Because the metadata classifies the package as OTHER and exposes only one documented procedure, customizations should treat it as an internal implementation object; callers should rely on supported Oracle Credit Management concurrent programs and the public credit data-point framework rather than invoking the procedure directly. When troubleshooting aging discrepancies in credit reviews, DBAs and developers commonly inspect the package body and the AR_CMGT_CURR_USAGE_GT results to validate bucket assignment. Its behavior is consistent across both 12.1.1 and 12.2.2, with object status VALID in each release.