Results for “gmf_utilities_grp”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMF_UTILITIES_GRP is a common utility package belonging to the Oracle Process Manufacturing (OPM) product family, owned by the APPS schema and classified as a GRP (group) object in the ETRM repository for Oracle EBS 12.1.1 and 12.2.2. As stated in its own header comments, the package "contains the common utility functions" used across OPM modules, centralizing reusable lookup and descriptive logic so that individual programs do not duplicate it. The header history shows the package was created by Jahnavi Boppana on 8-Sep-2005 and extended by Prasad Marada on 1-Oct-2005 with the organization and item retrieval methods, positioning it as the utility layer introduced during the OPM invoice conversion (INVCONV) work.

A defining characteristic of this package is that several of its functions carry a legal entity context. The primary disclosed function, GET_ACCOUNT_DESC, accepts an account identifier along with a legal entity identifier, and the account conversion logic is scoped by legal entity. This is the reason a search for cp_legal_entity surfaces the object: the package is one of the low-level utilities that resolve accounting information within a specific legal entity, which is a prerequisite for correct multi-organization and multi-entity accounting in OPM.

Key Procedures and Functions

The ETRM metadata documents ten callable units. Their purposes are:

• GET_ACCOUNT_DESC — Returns the account description for a supplied account reference combined with a legal entity identifier. The source shows an overloading pattern: one form accepts an account value with a flag indicating whether the input is an internal account identifier or a concatenated account string, resolves it to an account key, and delegates to a second form that performs the actual description lookup.
• GET_ACCOUNT_CODE — Resolves an account identifier and legal entity into the corresponding account code (key), used by GET_ACCOUNT_DESC when the caller passes an internal identifier.
• GET_LEGAL_ENTITY — Retrieves legal entity information for use in the account and reporting functions above.
• GET_ORGANIZATION_NAME — Returns the descriptive name of an inventory organization.
• GET_ORGANIZATION_CODE — Returns the short code of an inventory organization.
• GET_ITEM_NUMBER — Returns the item number for a given item reference, used wherever an internal item identifier must be presented to users.
• GET_COST_CATEGORY — Returns cost category information, supporting OPM costing and valuation display.
• BEFOREREPORT — A report trigger function, typically invoked from an Oracle Reports layout to initialize session context, output parameters, or report-level state before the main query executes.

Tables Accessed

The documented table references, resolved through APPS synonyms, are consistent with the functions above.

• FND_ID_FLEX_SEGMENTS — Provides key flexfield segment definitions; it underpins account code and description resolution, including the legal entity scoping used by GET_ACCOUNT_CODE and GET_ACCOUNT_DESC.
• MTL_PARAMETERS — Supplies inventory organization attributes used by the organization name and code functions.
• MTL_CATEGORIES_KFV — The key flexfield view over categories, supporting GET_COST_CATEGORY.
• DBMS_OUTPUT and PLITBLM — Utility references used for debug output and PL/SQL table manipulation rather than business data.

Usage Notes

GMF_UTILITIES_GRP is a passive utility library with no autonomous business transaction of its own; it is invoked by other code. The ETRM metadata records that it is referenced by nine other packages, and the presence of BEFOREREPORT indicates it is also called directly from Oracle Reports before-report triggers to populate legal entity, organization, item, and account descriptions displayed on the report. Typical consumers include OPM conversion programs, costing and inventory reports, and custom extensions that need consistent resolution of account descriptions under a specified legal entity rather than re-implementing flexfield queries. Because the package is APPS-owned and unflagged as public API, customizations should call it defensively: signatures are stable in 12.1.1 and 12.2.2, but direct dependencies on internal helper behavior are not supported.