Search Results default_application_info

Overview

AR_RECEIPT_LIB_PVT is an internal (PVT-classified) PL/SQL package body in the Oracle Receivables module of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. Its central business purpose is to supply defaulting, derivation, and validation services for the Oracle Receipts workbench and its programmatic interfaces. When a user or a calling program creates or applies a receipt, the receipt form and the underlying Receipts APIs require a large set of derived values: cash receipt identifiers, application identifiers, customer and site information, remittance and bank account data, currency and exchange rate details, receipt method details, descriptive flexfield values, miscellaneous receipt attributes, and unapplied or on-account application information. AR_RECEIPT_LIB_PVT encapsulates the logic that produces these values consistently across every entry point.

The package is heavily performance-oriented. It declares a series of cache size constants (each set to 1000 entries), covering site uses, customer numbers and names, receipt methods, customer and remittance bank accounts, currencies, rate types, exchange rates, activity names, tax codes, and reference payment, batch, receipt, and remittance data. It also defines record types such as Site_Use_Cache_Rec_Type and Exchange_Rate_Cache, which support in-memory caching of frequently accessed reference data during a receipt session. This caching design reduces repetitive queries against high-volume Receivables and Trading Community Architecture tables while a receipt is being defaulted.

The package is classified as PVT, indicating that it is intended for internal use by Oracle Receivables rather than as a publicly supported integration API. It is referenced by eleven other packages, confirming that it functions as a shared service layer beneath the Receipts forms, the Receipts public APIs, and related concurrent processing logic.

Key Procedures and Functions

The documented procedures fall into several functional groups. The user specifically searched for DEFAULT_APPLICATION_INFO, which belongs to the defaulting family and supplies application-related attribute defaults for a receipt.

• DEFAULT_APPLICATION_INFO — populates default application information used when applying a receipt to transactions or other receivables items.
• DEFAULT_APPLN_IDS — derives and returns default application identifier values.
• DEFAULT_CASH_IDS and DEFAULT_CASH_RECEIPT_ID — establish default cash identifier and cash receipt identifier values for a new receipt.
• GET_CASH_DEFAULTS, GET_MISC_DEFAULTS, and GET_DOC_SEQ — retrieve default attributes for cash receipts, miscellaneous receipts, and document sequence assignment respectively.
• DERIVE_UNAPP_IDS, DEFAULT_UNAPP_INFO, and DERIVE_UNAPP_ON_AC_IDS — derive unapplied receipt identifiers and default the corresponding unapplied information.
• DEFAULT_ON_AC_APP_INFO and DEFAULT_UNAPP_ON_AC_ACT_INFO — default on-account application information and the associated activity details.
• DEFAULT_REVERSE_INFO and DERIVE_REVERSE_IDS — support receipt reversal by defaulting reversal information and deriving the identifiers required for reversal processing.
• DERIVE_OTHERACCOUNT_IDS, DERIVE_ACTIVITY_UNAPP_IDS, and DERIVE_CUST_INFO_FROM_TRX — derive other-account identifiers, unapplied activity identifiers, and customer information from a transaction.
• DEFAULT_MISC_IDS — default miscellaneous receipt identifiers.
• VALIDATE_DESC_FLEXFIELD and DEFAULT_DESC_FLEXFIELD — validate and default descriptive flexfield values.

The remaining documented procedures complete the defaulting surface for receipt attributes, bank and remittance account selection, currency and exchange rate information, receipt method information, and reference data such as payment, batch, receipt, and remittance references.

Tables Accessed

The package reads reference and transactional data through APPS synonyms. Cash receipt and application data come from AR_CASH_RECEIPTS, AR_PAYMENT_SCHEDULES, and RA_CUSTOMER_TRX. Receipt configuration is drawn from AR_RECEIPT_CLASSES, AR_RECEIPT_METHODS, and AR_RECEIPT_METHOD_ACCOUNTS_ALL. Banking and remittance data is sourced from CE_BANK_ACCOUNTS, AP_CHECKS, and AP_INVOICES. Currency and rate information is read from FND_CURRENCIES and GL_DAILY_CONVERSION_TYPES. Customer and party data is obtained from HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES, HZ_PARTIES, and HZ_PARTY_SITES. These accesses support the defaulting, derivation, and validation routines described above, with the cache structures minimizing repeat reads during receipt entry.

Usage Notes

AR_RECEIPT_LIB_PVT is typically invoked indirectly. The Oracle Receipts workbench form, the Receipts public APIs, and related concurrent programs call this package to obtain defaulted values and to derive identifiers before invoking the transactional APIs. It is not documented as a customer-facing API, so custom code should prefer the supported Receipts open interfaces and public APIs rather than calling AR_RECEIPT_LIB_PVT directly. Its PVT classification and broad internal dependency base mean that its signature and behavior are subject to change between patch levels in both 12.1.1 and 12.2.2.