Search Results get_cost




Overview
Explore in AI Chat

Overview

GMD_LCF_UTIL is an Oracle EBS utility package owned by the APPS schema that forms part of the Landed Cost Factor (LCF) build within the Process Manufacturing (GMD) product family. Its purpose is to supply externally defined cost values to the Landed Cost calculation process. In Process Manufacturing environments, costs associated with sourcing, freight, duty, and similar landed cost elements may be sourced either from internal Oracle costing functions or from user-defined external functions selected by the implementation. GMD_LCF_UTIL is the interface that retrieves such external costs at the time a transaction or cost rollup is evaluated.

The package is classified as a UTIL API and is referenced by one other database package, indicating it is a supporting routine rather than an entry-point application interface. The header comment in the source (GMDLCFUS.pls, version 120.3, dated 15-NOV-2005) records that the object was created by Sriram on 25-JUL-2005 specifically for the LCF Build. The documented functionality is present in both EBS 12.1.1 and 12.2.2, with the ETRM 12.2.2 metadata confirming a single published function, GET_COST.

Key Procedures and Functions

The package exposes one documented function:

  • GET_COST — Retrieves the external cost value for a specified item when the "external cost" option is chosen in the Technical Parameters form. According to the source description, the function is called to fetch the cost for a given item and organization combination, together with the associated lot, quantity, unit of measure, and cost date. It returns a NUMBER representing the resolved cost. The trailing underscore parameters in the documented signature confirm the calling context: an item identifier, inventory organization, separate cost organization, lot number, quantity, UOM, and effective cost date.

No additional procedures or functions are documented for this package. Implementers seeking customization typically wrap or replace GET_COST through their own logic, since the package is a utility layer rather than a public API with multiple overloads.

Tables Accessed

GMD_LCF_UTIL references a single documented table via an APPS synonym: GMD_LCF_EXTERNAL_COST. This table stores the external cost definitions maintained by the implementation. GET_COST reads from it to obtain the cost amount that matches the supplied item, organization, lot, and effective date criteria. No other tables are documented as accessed by this package, and the unit of access is read-only retrieval for the purpose of feeding the landed cost engine.

Usage Notes

The function is primarily invoked from the Technical Parameters form when the external cost sourcing option is selected for a landed cost factor. In that flow, the form passes the runtime context (item, organizations, lot, quantity, UOM, cost date) to GET_COST and receives the numeric cost to apply to the transaction or cost calculation.

Because the object is classified as a UTIL package, it is not intended as a direct call point for end-user concurrent programs. Custom PL/SQL that emulates landed cost behavior, however, can call APPS.GMD_LCF_UTIL.GET_COST when it needs to mirror the standard external cost lookup. As with all APPS-owned utilities, modifications should be avoided; extensions are best implemented in a custom schema that references the packaged function, preserving upgrade safety across 12.1.1 and 12.2.2.