Search Results fa_fas828_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.FA_FAS828_XMLP_PKG package is the PL/SQL package body and specification associated with the Oracle E-Business Suite Fixed Assets report FAS828, a feeder system and cost reconciliation report generated through the Oracle Reports (XML Publisher) concurrent program framework. The package encapsulates the report-level logic that the Reports engine invokes at defined points in the report lifecycle, primarily through the BeforeReport and AfterReport triggers, and through the various formula columns defined in the report layout. It is owned by the APPS schema and is classified as an OTHER API, indicating that it is a supporting/report-internal package rather than a public, supported integration API.

The business purpose of FAS828 is to present asset cost information sourced from the Fixed Assets book controls and related setup data, allowing reconciliation and review of feeder system balances against the corporate book. The package provides the PL/SQL "glue" that supplies company name, report name, feeder system identification, and currency context to the report, along with derived calculations such as the cost formula referenced in the user's search term, d_costformula.

Key Procedures and Functions

Eight documented programmable units are declared in the package specification:

  • REPORT_NAMEFORMULA — A formula function returning the report name, derived from the passed company name. Used to populate the report header/title contextually.
  • BEFOREREPORT — The standard Oracle Reports before-report trigger function. Executes initialization logic prior to report data retrieval, including population of global package variables.
  • AFTERREPORT — The standard Oracle Reports after-report trigger function. Executes cleanup or finalization logic after the report completes.
  • CURRENCY_CODEFORMULA — A formula function returning the currency code for a given book. Supports multi-currency reporting by resolving the book's functional currency.
  • RP_COMPANY_NAME_P — Returns the value of the RP_COMPANY_NAME package variable.
  • RP_REPORT_NAME_P — Returns the value of the RP_REPORT_NAME package variable.
  • RP_FEEDER_SYSTEM_P — Returns the value of the RP_FEEDER_SYSTEM package variable.
  • D_COSTFORMULA — A formula function taking the feeder system as input and returning the derived cost value. Per the header comment, this unit was "Added during DT Fix," indicating it was introduced as a post-release data-transformation or defect correction to the report.

The specification also declares the public package variables P_CONC_REQUEST_ID, P_MIN_PRECISION, RP_COMPANY_NAME, RP_REPORT_NAME, and RP_FEEDER_SYSTEM.

Tables Accessed

Three tables are referenced through APPS synonyms:

  • FA_BOOK_CONTROLS — The Fixed Assets book definition table. Provides the book's functional currency, precision settings, and control parameters that drive the cost and currency formulas.
  • FND_CURRENCIES — The Foundation currencies table. Used to resolve currency descriptions and formatting for the report output, typically in conjunction with CURRENCY_CODEFORMULA.
  • FND_CONCURRENT_REQUESTS — The concurrent request table. Read to correlate the running request (via P_CONC_REQUEST_ID) with report parameters and execution context.

Usage Notes

This package is invoked automatically by the Oracle Reports runtime when the FAS828 concurrent program is executed; it is not intended for direct invocation by application forms or custom code. The report is submitted from the Fixed Assets responsibility via the standard Submit Requests / Run Reports flows. Because it is classified as OTHER and referenced by zero other documented packages, it should be treated as report-internal and subject to change by Oracle without notice. Customizations should avoid calling it directly and should instead be layered through supported report customization or extension mechanisms. The presence of D_COSTFORMULA, added during a defect fix, underscores that this specification may diverge between patch levels of 12.1.1 and 12.2.2, so environment-specific validation is recommended before relying on its output.