Search Results fa_fasmret_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.FA_FASMRET_XMLP_PKG package is a generated PL/SQL wrapper that supports the Oracle Assets XML Publisher (BI Publisher) report associated with the FASMRET concurrent program — the Fixed Asset "Retirement" report. The report reproduces the standard "Retirements" listing that asset accountants use to review asset retirements processed during a period, including cost retirements, proceeds of sale, gain or loss on retirement, and the accounting distribution of each retirement transaction. Because the report output is produced through the XML Publisher engine rather than the legacy Oracle Reports runtime, Oracle Assets wraps the report logic in a package of this naming convention: FA_<report>_XMLP_PKG with an accompanying XML/XSL definition. The package is owned by the APPS schema and is catalogued in ETRM with a status of VALID and an API classification of OTHER, indicating it is internal report infrastructure rather than a publicly callable business API. It is validated against both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

ETRM documents nine procedures and functions in the package. They fall into three functional groups. The report-lifecycle routines are BEFOREREPORT, which is the entry point executed when the concurrent request begins, and AFTERREPORT, which runs when report output generation completes; together they initialize and clean up the session state used by the data model. The formula routines are REPORT_NAMEFORMULA and GAIN_LOSSFORMULA. These are XML Publisher placeholder functions that supply derived values to the report layout — the report title text and the caption or computed gain/loss presentation for retired assets, respectively. The remaining routines are the lexical value-set parameters that drive the concurrent program's parameter window: ACCT_BAL_APROMPT_P and ACCT_CC_APROMPT_P provide the balancing and cost center segment prompts against the accounting flexfield, CAT_MAJ_RPROMPT_P supplies the major category range prompt, and RP_COMPANY_NAME_P and RP_REPORT_NAME_P expose the company name and report name as report parameters. Consistent with ETRM conventions, parameter structures are not enumerated here; parameter lists for these procedures are documented in the package body, not in the metadata.

Tables Accessed

The only table documented as referenced through APPS synonyms is FND_CONCURRENT_REQUESTS. This is used for standard concurrent-program housekeeping — retrieving the request identifier, request parameters, and execution context so that report-level filters and defaults can be resolved at run time. The substantive asset data (retirement transactions, cost and depreciation adjustments, and accounting entries) is sourced by the underlying Oracle Reports or SQL definition that this package wrapper drives, rather than by direct DML in the package itself.

Usage Notes

FA_FASMRET_XMLP_PKG is invoked indirectly. Users do not call it from a form; the Oracle Assets "Retirements" report and its request set reference the associated concurrent program, and the XML Publisher runtime calls BEFOREREPORT and the formula and parameter functions automatically. The package is referenced only by itself in the ETRM dependency graph and is not exposed as a public API for other packages; therefore it should not be called from custom code. Customizations to report output should be made through the XML Publisher template and data definition rather than by modifying this package, since patches and upgrades regenerate it and will overwrite manual changes.