Results for “set_buckets”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_UNPOSTED_ITEM_UTIL is a PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite Receivables. It belongs to the UTIL classification within the Oracle ETRM object registry, indicating that it provides reusable helper logic rather than a business-facing API. The package supports the processing and reporting of unposted receivable items by centralizing currency-related calculations that would otherwise be duplicated across multiple Receivables programs.

Its principal role is to resolve currency precision and rounding behavior and to compute functional (base) currency amounts for transaction records. These operations are essential when Receivables must present or reconcile unposted transactions in both the entered currency and the ledger currency. The package is documented as VALID in both the 12.1.1 and 12.2.2 releases and depends on APPS.FND_CURRENCIES along with standard SYS constructs.

Key Procedures and Functions

The ETRM metadata documents four callable units within the package:

• GETCURRENCYDETAILS — Retrieves descriptive and precision attributes for a given currency. It provides callers with the currency information required to format, validate, or convert monetary values consistently with Oracle's currency definitions.
• FUNCTIONAL_AMOUNT — Derives the functional currency (ledger base) equivalent of an entered amount. This is the core conversion helper used when unposted item values must be expressed in the functional currency for reporting or posting downstream.
• CURRROUND — Applies currency-appropriate rounding to an amount, honoring the precision defined for the currency so that computed values respect the minimum accountable unit.
• SET_BUCKETS — Establishes or initializes the aging or grouping buckets used when unposted items are categorized. Bucket definitions support the summarized presentation of outstanding items.

These units are intended for internal consumption by Receivables processing logic. Parameter lists are not documented in the ETRM extract and should be confirmed against the package specification in the target instance.

Tables Accessed

The package references two documented tables through APPS synonyms:

• FND_CURRENCIES — The Oracle Application Object Library currency definition table. It supplies currency codes, precision, and related attributes consumed by GETCURRENCYDETAILS and CURRROUND.
• RA_CUSTOMER_TRX — The Receivables transaction header table. It is the source of transaction currency and amount context for FUNCTIONAL_AMOUNT and bucket processing.

No direct writes to these tables are indicated; the package primarily reads reference and transaction data to perform calculations.

Usage Notes

AR_UNPOSTED_ITEM_UTIL is not an end-user interface object. It is invoked programmatically. The ETRM dependency listing shows it is referenced by APPS.ARP_DET_DIST_PKG, the detailed distribution processing package, and by itself through recursive internal calls. This confirms its role as a shared utility within the Receivables distribution and posting flow.

Typical invocation occurs from concurrent programs and internal package logic that assemble unposted item data, where currency conversion and rounding must be applied before amounts are presented or posted. Because the package depends on FND_CURRENCIES, callers must ensure currency definitions are complete and cached appropriately. Custom extensions requiring Receivables-consistent currency rounding or functional amount derivation may call these units directly, but should do so with awareness that the package is classified as a utility and its signature is not guaranteed as a public, supported API across releases. Developers should verify signatures against the specific 12.1.1 or 12.2.2 instance before reuse.