Search Results gmf_cmr10usr_xmlp_pkg

Overview

APPS.GMF_CMR10USR_XMLP_PKG is a PL/SQL package that supports the Oracle Process Manufacturing (OPM/GMF) concurrent report CMR10USR, a user-defined cost allocation report. The package is an XML Publisher (XMLP) report packaging shell generated for a report registered against the CMR10USR concurrent program. In Oracle EBS 12.1.1 and 12.2.2, report logic is bound to a package that declares the report parameters, the before/after report triggers, and the "formula" functions that supply computed column values to the XML template. This package follows that pattern: it exposes global variables for report parameters and a set of CF_* functions that resolve internal account identifiers into flexfield-derived display strings.

The package is classified under the APPS schema with API classification OTHER, signifying that it is not a published integration API but internal report-support code. Its header comment ($Header: CMR10USRS.pls 120.0) confirms it was authored as a report specification package for the CMR10USR report rather than as a callable business API.

Key Procedures and Functions

The package declares fourteen documented program units. Their roles are as follows:

• GMF_CMR10USR_XMLP_PKG_HEADER — Package initialization/header routine that sets up the package state for a report run.
• BEFOREREPORT — Standard XML Publisher before-report trigger; initializes parameter values, session context, and any report-level setup before data retrieval.
• AFTERPFORM — Standard XML Publisher after-parameter-form trigger; executes logic immediately after the concurrent program parameter form is submitted, commonly used to validate or derive parameter values.
• AFTERREPORT — Standard XML Publisher after-report trigger; performs post-processing, cleanup, or final derivations once the report has been generated.
• CF_LEGAL_ENTITYFORMULA — Resolves the legal entity identifier (LEGAL_ENTITY_ID) to a displayable legal entity value for the report output; this is the function most directly associated with the user query "cf_legal_entityformula".
• FROM_ACCOUNTFORMULA / TO_ACCOUNTFORMULA — Derive the from-account and to-account display values from the corresponding account identifiers.
• FROM_ACCOUNT_DESCFORMULA / TO_ACCOUNT_DESCFORMULA — Return the descriptive names for the from-account and to-account identifiers.
• BASIS_ACCOUNT_CODEFORMULA / BASIS_ACCOUNT_DESCFORMULA — Return the account code and description of the allocation basis account.
• ALLOCATIONCFFORMULA / ALLOCATIONCPFORMULA — Compute and return the allocation-related display value; the latter accepts an input string and transforms it.
• ALLOCATIONCP_P — Public accessor returning the ALLOCATIONCP global value.

Tables Accessed

The ETRM metadata for this package does not enumerate specific base tables or APPS synonyms. In practice, a CMR10USR report package reads OPM costing and allocation data, and the CF_* formulas resolve account and legal entity identifiers through the Accounting Flexfield (FND_ID_FLEX_STRUCTURES / GL_CODE_COMBINATIONS) and legal entity views. Because no table list is documented, table access should be verified directly against the deployed package body in the target instance.

Usage Notes

The package is invoked exclusively through the CMR10USR concurrent program and its XML Publisher template, not by direct application calls. The BEFOREREPORT, AFTERPFORM, and AFTERREPORT functions are triggered by the concurrent manager report lifecycle, while the CF_* formula functions are evaluated by the XML template to populate report columns. No other packages reference it (referenced by 0 other packages), confirming its role as a terminal report-support unit. Customizations should not modify APPS-owned code; instead, use a custom copy or a custom template where possible. When troubleshooting the "cf_legal_entityformula" output, review the legal entity identifier parameter and the underlying legal entity definition resolution, since the function simply maps the numeric identifier to its display value.