Search Results ar_invoice_utils




Overview
Explore in AI Chat

Overview

AR_INVOICE_DEFAULT_PVT is a private (PVT-classified) PL/SQL package in the APPS schema that supplies defaulting logic for Oracle Receivables invoice and credit memo transactions. Its role is to derive and return the values that populate transaction attributes when a user creates or imports an invoice but does not explicitly supply every field. Rather than exposing a public API, it functions as an internal worker consumed by higher-level Receivables APIs and utilities such as AR_INVOICE_API_PUB, AR_INVOICE_TABLE_HANDLER, and AR_INVOICE_UTILS. In this capacity it centralizes the rules that determine default accounting dates, currency attributes, batch source properties, and other setup-derived values so that those rules remain consistent across the AutoInvoice interface, the Invoice Workbench, and programmatic invoice creation.

Key Procedures and Functions

The documented package exposes three procedures/functions, all oriented toward resolving default values from setup and profile data:

  • GET_SYSTEM_PARAMETERS — Retrieves the Receivables system option values that govern transaction entry, providing the setup context against which other defaults are resolved.
  • GET_PROFILE_VALUES — Reads the relevant Oracle Application Object Library profile option values that influence invoicing behavior, such as date and currency handling.
  • DEFAULT_GL_DATE — Derives the default General Ledger date for a transaction, ensuring accounting dates are valid and consistent with the ledger and conversion setup before an invoice is saved or interfaced.

The package is classified as PVT, indicating that these routines support internal processing and are not intended as a supported public integration interface. No parameter lists are documented in the ETRM metadata, and callers should rely on the public wrappers rather than invoking these routines directly.

Tables Accessed

The package reads from Receivables and general ledger setup tables through APPS synonyms. Documented dependencies include:

  • AR_SYSTEM_PARAMETERS — Provides Receivables system option values used as transaction defaults.
  • FND_CURRENCIES — Supplies currency attributes such as precision and currency code validation.
  • RA_BATCH_SOURCES — Defines batch source properties that determine default transaction type, numbering, and accounting behavior.
  • GL_DAILY_CONVERSION_TYPES — Provides daily conversion rate types referenced when deriving currency and rate defaults.
  • RA_CUST_TRX_TYPES — Defines customer transaction types that map to default receivable and revenue accounting.
  • AR_TRX_DIST_GT and AR_TRX_HEADER_GT — Global temporary tables that stage distribution and header information during invoice processing.

Additional referenced objects include AR_LOOKUPS, GL_SETS_OF_BOOKS, RA_SALESREPS, and FND_CURRENCIES, underscoring the package's dependency on both Receivables and general ledger configuration.

Usage Notes

AR_INVOICE_DEFAULT_PVT is normally invoked indirectly. In the Invoice Workbench, defaults are applied as the form drives the underlying Receivables APIs. During AutoInvoice processing, AR_INVOICE_API_PUB and AR_INVOICE_TABLE_HANDLER call the package to populate staged records in AR_TRX_HEADER_GT and AR_TRX_DIST_GT before validation and import. Custom code that creates invoices programmatically should call the supported public APIs, which in turn invoke this private package, rather than referencing AR_INVOICE_DEFAULT_PVT directly. Because it is a PVT package, its signature may change between releases and is not covered by Oracle's public API compatibility guarantees. Customers upgrading from 12.1.1 to 12.2.2 should re-validate any customizations that reference it.