Search Results get_transfer_price




Overview
Explore in AI Chat

Overview

The APPS.MTL_INTERCOMPANY_INVOICES package is a server-side PL/SQL package in Oracle EBS Release 12.1.1 and 12.2.2 that supports intercompany invoicing and transfer pricing logic within the Inventory and Order Management flows. Its primary business purpose is to resolve the transfer price and associated currency for intercompany transactions, and to service workflow or event callbacks triggered during intercompany invoice generation. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema (typically APPS) rather than the defining schema, which is consistent with standard Oracle EBS seeded package conventions.

The keyword most commonly associated with this package, and the likely reason a user would search for it, is get_transfer_price. This function encapsulates the business rules that determine the price at which goods are transferred between two operating units, and it is the principal documented entry point of the package.

Key Procedures and Functions

  • GET_TRANSFER_PRICE — A function that returns the transfer price (a numeric value) for a given intercompany transaction. Per the source header, it accepts identifying context including the transaction identifier, a price list identifier, the selling operating unit, the shipping operating unit, and an optional order line identifier. It returns the resolved currency code and standard return status, message count, and message data output parameters, which follow the Oracle EBS standard API error-handling pattern. The order line parameter was added under Bug 5118727, indicating that transfer price resolution can vary when order line context is supplied.
  • CALLBACK — A procedure that handles an event, identified by I_event, together with transaction, report header, and customer transaction line identifiers. Its documented role is to respond to events raised during intercompany invoice processing, allowing the package to react to invoicing state transitions or reporting milestones.

No parameter lists should be assumed beyond what is documented; the signatures above reflect the ETRM metadata excerpt.

Tables Accessed

The ETRM metadata does not enumerate specific tables referenced by this package through APPS synonyms. Functionally, transfer price determination requires access to price list and pricing data, intercompany transaction records, and operating unit information, but the documented metadata records no explicit table list for this object. Confirming the exact tables is best accomplished by reviewing the package body in the target environment, since table dependencies may differ between 12.1.1 and 12.2.2 and across patch levels.

Usage Notes

This package is typically invoked indirectly rather than called directly by end users. It is referenced by one other documented package and is engaged by the intercompany invoicing process, including Advanced Pricing and Order Management driven intercompany flows. Customizations that need to retrieve a transfer price for an intercompany transaction should call GET_TRANSFER_PRICE and check x_return_status before consuming the returned price, since the function reports errors through the standard FND message stack. Because the package uses AUTHID CURRENT_USER, callers should ensure the invoker schema has the required object privileges. The CALLBACK procedure is intended to be wired to the relevant event, not invoked ad hoc. Given the limited published metadata, developers should treat the package header as the authoritative interface and avoid relying on undocumented behavior.