Search Results fa_fasaamtd_xmlp_pkg




Overview
Explore in AI Chat

Overview

FA_FASAAMTD_XMLP_PKG is an Oracle EBS Fixed Assets (FA) report package owned by the APPS schema. Its name follows the standard Oracle Reports XML Publisher naming convention, in which the suffix _XMLP_PKG identifies a PL/SQL package that is auto-generated by the XML Publisher (BI Publisher) engine and bound to a specific report definition. The embedded report identity FASAAMTD corresponds to the Fixed Assets "Asset Additions and Adjustments" style report, whose purpose is to present depreciation period activity — additions, adjustments, transfers, and retirements — for a selected company, book, and accounting period.

Functionally, the package serves as the data-access and formatting layer between the Oracle Reports/XML Publisher template and the Fixed Assets base tables. It resolves runtime report parameters (company name, report name, period names, balance prompt labels), performs before-report and after-report initialization, and supplies derived formula columns that convert stored depreciation figures into the period-specific amounts displayed on the report. Where the report must present both book (corporate) and federal (tax) depreciation, the package exposes separate formula columns for each basis.

Key Procedures and Functions

The package exposes 17 documented program units. The report lifecycle units are BEFOREREPORT, which executes parameter and global initialization prior to data retrieval, and AFTERREPORT, which performs post-processing and cleanup. REPORT_NAMEFORMULA returns the report title text for the report header. Parameter resolution is handled by RP_COMPANY_NAME_P, RP_REPORT_NAME_P, and RP_BAL_LPROMPT_P, which supply the company name, report name, and balance-line prompt label respectively to the XML template.

Period logic is covered by a family of *_PCFORMULA and *_P units. PERIOD1_PCFORMULA, FED_START_PERIOD_PCFORMULA, and FED_END_PERIOD_PC_P resolve and format the period identifiers for the corporate and federal ranges, while PERIOD1_POD_P, PERIOD1_PCD_P, and PERIOD1_FY_P supply period-opening date, period-closing date, and fiscal year values. AMT_START_PERIOD_PC_P and AMT_END_PERIOD_PC_P provide the opening and closing accounting period identifiers for the amount columns. Depreciation calculations are performed by DIFF_DEPRNFORMULA (period-to-period difference), AMT_DEPRNFORMULA (corporate depreciation amount), and FED_DEPRNFORMULA (federal depreciation amount).

Tables Accessed

The package references two tables through APPS synonyms. FA_DEPRN_PERIODS is the Fixed Assets depreciation period definition table, and it is the source for all period name, period-opening, and period-closing date values resolved by the PERIOD1_*, AMT_*, and FED_* formula units. This table links each depreciation book and accounting period to its fiscal year and date boundaries.

FND_CONCURRENT_REQUESTS is the Oracle Application Object Library concurrent request table. It is accessed to identify the active concurrent request context — typically to obtain the request ID, requesting user, or submission parameters — so that the report can correctly resolve its runtime arguments when executed through the Standard Report Submission (SRS) concurrent manager framework.

Usage Notes

FA_FASAAMTD_XMLP_PKG is never invoked directly by end users. It is called by the XML Publisher runtime engine when the associated Fixed Assets report is executed, whether that report is submitted as a concurrent program from the Fixed Assets responsibility menu or scheduled through the concurrent manager. Customizations should not modify this package; report-specific logic belongs in the underlying SQL query or in a custom package, because the generated _XMLP_PKG body may be regenerated when the report definition is redeployed. The package is documented as referenced by zero other PL/SQL packages, confirming that it sits at the top of the dependency chain and is consumed only by the report runtime. Any extension of the report output should therefore be implemented through XML Publisher template modifications or by replacing the report with a custom concurrent program, preserving this package as delivered.