Search Results mrc_v




Overview
Explore in AI Chat

Overview

FA_XML_REPORT_PKG is an Oracle E-Business Suite XML reporting utility package owned by the APPS schema and classified as an OTHER API. Its primary business function is to generate XML-based output for Oracle Assets (Fixed Assets) reporting, most notably impairment reporting and asset extraction by cash generating unit. The package combines XML generation (through DBMS_XMLGEN and manual tag construction) with direct file writing to the concurrent manager output stream via FND_FILE. This design allows Oracle Assets concurrent programs to produce structured, machine-readable XML documents as part of standard report submission.

In the context of Oracle EBS 12.1.1 and 12.2.2, the package is a standard component of the Oracle Assets module. The header shows it was last updated in 2012 (120.15.12020000.2), making it consistent across both release levels. The presence of FA_MC_BOOKS, FA_MC_IMPAIRMENTS, and the search term "mrc_v" reflect the package's role in supporting multiple reporting currencies (MRC), where reporting books derived from the primary set of books must be queried and reported alongside primary data.

Key Procedures and Functions

  • CLOB_TO_FILE — Writes a CLOB containing the generated XML to the concurrent program output file. It iterates in fixed-size chunks (3000 characters) using DBMS_LOB.SUBSTR and emits each chunk through FND_FILE.PUT, terminating with FND_FILE.NEW_LINE. This is the low-level streaming routine that materializes the XML document for the user.
  • PUT_ENCODING — Emits the XML encoding declaration at the head of the generated document, ensuring correct interpretation of the output stream by downstream parsers.
  • PUT_STARTTAG — Writes an opening XML element tag, providing the building block for hand-constructed XML structures that are not produced by DBMS_XMLGEN.
  • PUT_ENDTAG — Writes the corresponding closing XML element tag, balancing the output produced by PUT_STARTTAG.
  • ASSET_IMPAIRMENT_REPORT — The principal business procedure. It assembles the asset impairment report in XML form, drawing on impairment records and impairment books, including MRC reporting books, so that both primary and reporting currency impairment figures are represented.
  • LIST_ASSETS_BY_CASH_GEN — Produces an XML listing of assets grouped by cash generating unit, used for impairment testing where assets are evaluated collectively as a CGU.

Tables Accessed

  • FA_ADDITIONS_B — Source of asset identification and descriptive information.
  • FA_BOOKS and FA_MC_BOOKS — Provide asset cost, depreciation, and impairment-relevant balances in both primary and reporting currencies; FA_MC_BOOKS supports the MRC requirement.
  • FA_BOOK_CONTROLS — Supplies book-level setup and period context.
  • FA_CASH_GEN_UNITS — Defines cash generating unit groupings used by LIST_ASSETS_BY_CASH_GEN.
  • FA_DEPRN_PERIODS — Determines period ranges and open/closed status for reporting.
  • FA_IMPAIRMENTS and FA_MC_IMPAIRMENTS — Hold impairment transactions in primary and reporting currencies.
  • FA_LOOKUPS_TL — Translates lookup codes to meaningful, language-specific descriptions.
  • DBMS_LOB and DBMS_XMLGEN — Not tables but referenced PL/SQL packages used for CLOB manipulation and XML result set generation.

Usage Notes

FA_XML_REPORT_PKG is invoked by Oracle Assets concurrent programs that produce impairment-related XML output, rather than being called interactively from a form. It is not referenced by any other documented package, so calls originate directly from concurrent program definitions or custom code layered on top of Oracle Assets. Because output is written through FND_FILE, the package must run inside a concurrent manager request; running it from a client session would not route output to a report file. The MRC-aware procedures expect the reporting currency books to be configured in FA_MC_BOOKS and FA_MC_IMPAIRMENTS, and requires the relevant accounting periods to be set up in FA_DEPRN_PERIODS. Customizations should treat this as a non-public utility, calling the documented procedures for structure rather than the internal tag helpers unless reimplementing the generator.