Search Results trans_qtyformula_005

Overview

GME_GMEMUSBV_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified as an OTHER API. It supports the Oracle Process Manufacturing (OPM/GME) concurrent reporting framework, specifically the XML Publisher report associated with the GMEMUSBV report template. The package encapsulates the PL/SQL logic invoked during XML Publisher report execution, including the report-level trigger functions (BEFOREREPORT and AFTERREPORT) and a large set of formula columns and derived calculations used in the report's data model. The report concerns batch material usage and valuation, correlating batch header information, material detail quantities, routing and recipe references, and accounting costs against transaction quantities. In Oracle EBS 12.1.1 and 12.2.2, these packages are registered as concurrent program report logic and are executed when the report is launched. The package is not referenced by any other database package, indicating it is a self-contained report-support unit whose public functions are invoked only by the XML Publisher data model during report generation.

Key Procedures and Functions

The package exposes twenty-seven documented procedures and functions. The cost-related functions include CF_ACCTG_COST, which retrieves the process item cost for a given inventory item and completion date by calling the GMF_CMCOMMON.GET_PROCESS_ITEM_COST API; CF_ACCTG_COST2FORMULA, which computes accounting cost by multiplying a transaction quantity by the cached item cost; CF_VALUE_VARIANCE, CF_S_VALUE_VARIANCEFORMULA, CF_U_VALUE_VARIANCEFORMULA, and CF_TOTAL_VARIANCEFORMULA, which produce value variance columns; and CF_VARIANCE_PCT, which derives a percentage variance. Quantity-related logic includes CF_QUANTITY_VARIANCE, which subtracts transaction quantity from actual item quantity, and CF_ACTL_QTY_ITEMUMFORMULA.

Several functions handle report grouping and formatting. CF_BATCHRANGEFORMULA, CF_DATERANGEFORMULA, CF_ITEM_RANGE, CF_BATCH_SIZEFORMULA, and CF_ITEMUMFORMULA generate formatted range and unit-of-measure output. The function TRANS_QTYFORMULA_005 is a specific formula column within the report's data model, one of several numbered transformation formulas, including CF_DELETE_TRANSFORMULA. The function CF_WIPCODE derives a work-in-process code, while G_MAINGROUPFILTER is a global filter used to constrain the report's primary group. BEFOREREPORT and AFTERREPORT are standard report trigger points executed before and after the report body, typically used for initialization and cleanup. CF_ACCTG_COST2FORMULA and CF_QUANTITY_VARIANCE are directly visible in the source excerpt, with the latter using NVL to treat null quantities as zero.

Tables Accessed

The package reads from a documented set of tables through APPS synonyms. GME_BATCH_HEADER and GME_MATERIAL_DETAILS supply batch-level and material-detail quantities, which drive the transaction quantity, actual quantity, and batch range formulas. GME_SCALE_DETAIL provides scale-weight information. FM_MATL_DTL and FM_ROUT_HDR support material detail and routing header data referenced by the report's formula columns. GMD_RECIPE_VALIDITY_RULES and GMD_ROUTINGS_B supply recipe validity and routing base definitions. MTL_SYSTEM_ITEMS_B and MTL_PARAMETERS provide inventory item attributes and organization-level parameters used in item ranges and cost lookups. FND_DUAL and PLITBLM are used as utility and lookup sources. These reads populate the report's data model and support cost, quantity, and variance derivation.

Usage Notes

GME_GMEMUSBV_XMLP_PKG is invoked during execution of the associated XML Publisher concurrent report within the OPM cost and material reporting domain. Because the package is registered under APPS and classified as OTHER, it is invoked by the report data model rather than by other packages. The BEFOREREPORT and AFTERREPORT functions execute automatically at report lifecycle boundaries. Formula columns such as TRANS_QTYFORMULA_005 run once per report row, so their logic must remain efficient against the underlying batch and material detail tables. The dependency on GMF_CMCOMMON.GET_PROCESS_ITEM_COST means the report reflects the cost method and analysis codes effective at runtime. Customizations should preserve the documented formula function signatures, since the XML Publisher report references them directly by name.