Search Results get_account

Overview

APPS.RCV_ACCOUNTHOOK_PUB is a public PL/SQL package in Oracle E-Business Suite Receiving (RCV) that exposes a hook API for overriding standard accounting derivation logic. The package body header carries a version marker of 115.0 dated 2003/09/11, indicating it has shipped substantially unchanged across the 11i and R12 code lines, including 12.1.1 and 12.2.2. Its documented business purpose is to allow customers to substitute a user-defined account for an accounting line that Oracle would otherwise derive automatically. In the shipped version, the only supported substitution is the Retroactive Price Adjustment account generated during retroactive price adjustment processing for a receiving transaction.

Because the package is classified as PUB and owned by APPS, it forms part of the supported extension surface of the Receiving application. Customers implement their own logic inside a copy of the hook or in a wrapper that calls the hook, and the receiving accounting engine invokes it at the point where the retroactive price adjustment distribution account must be resolved.

Key Procedures and Functions

• Get_Account — The single documented entry point. It returns a distribution account identifier that the Receiving accounting engine should use in place of the organization's default retroactive price adjustment account. It accepts API-standard control parameters (API version, initialization message list flag, commit flag, and validation level) along with the receiving transaction identifier and the accounting line type. It returns the standard API outcome triplet of return status, message count, and message data, plus the resolved distribution account identifier. The documented operating contract is specific: the API currently supports only the Retroprice Adjustment line type, the transaction identifier identifies the transaction being adjusted, and a returned account identifier of -1 instructs the caller to fall back to the organization-defined retroactive price adjustment account. Any other returned value causes the caller to use the account supplied by the hook. The internal API name literal within the body references accounting event creation, reflecting the accounting derivation context in which the hook executes.

Tables Accessed

The ETRM metadata for this object does not enumerate any tables referenced through APPS synonyms, and the package body is deliberately thin. Its role is to return a value to the calling accounting engine rather than to persist data itself. Any table access performed during derivation, such as retrieval of transaction, organization, or account information, is normally carried out by the caller or by customer code placed inside a customized implementation of the hook. Implementations that need to resolve an account typically query receiving transaction and account code combination data independently rather than relying on this package to do so.

Usage Notes

RCV_ACCOUNTHOOK_PUB is not invoked from a form or concurrent program by end users. It is called programmatically by Receiving accounting processes, specifically during retroactive price adjustment accounting, when the pricing engine must determine the distribution account for the adjustment line. The metadata indicates the package is referenced by two other packages, confirming that the receiving accounting code path calls into it rather than the reverse.

Customization is performed by modifying the package body logic inside Get_Account to compute and return the desired account identifier, then compiling it into the APPS schema. Because the default behavior returns -1, an unmodified package preserves standard Oracle accounting without any functional change. Developers searching for "get_account" in this context should understand that the routine exists solely to support account substitution for retroactive price adjustments, and that it must be re-validated after upgrades to 12.1.1 or 12.2.2 to ensure custom logic remains compatible with the receiving accounting API contract.