Search Results fa_rx_shared_pkg




Overview
Explore in AI Chat

Overview

FA_RX_SHARED_PKG is a shared utility package body in the APPS schema that supports Oracle E-Business Suite Fixed Assets reporting and transaction extraction. Contrary to what its name might suggest, this package is not a public API for external integration; it is an internal helper package that centralizes common logic used by the various FA_RX_* programs that generate asset books, depreciation, and reserve ledger reports. It is validated and present in both Oracle EBS 12.1.1 and 12.2.2.

The package encapsulates several recurring reporting concerns: resolving accounting flexfield segment values, building concatenated key strings for asset and account identifiers, retrieving concurrent request parameters, and managing a cached set of flexfield value meanings. By concentrating these operations in one package, Oracle avoids duplicating the same SQL across the numerous extract programs that read Fixed Assets data. The metadata indicates that FA_RX_SHARED_PKG is referenced by 34 other packages, confirming its role as a foundational dependency within the FA reporting subsystem.

Key Procedures and Functions

The package exposes 17 documented procedures and functions:

  • GET_ACCT_SEGMENT_NUMBERS, GET_ACCT_SEGMENT_INDEX, GET_ACCT_SEGMENTS — resolve the accounting flexfield segment structure and return the individual segment values that make up a code combination. These are used when reports must present account components separately rather than as a single concatenated string.
  • FADOLIF and FA_RSVLDG — internal helpers named after the Fixed Assets reserve ledger and depreciation conventions; they support the reserve ledger extract logic.
  • CONCAT_GENERAL, CONCAT_CATEGORY, CONCAT_LOCATION, CONCAT_ASSET_KEY, CONCAT_ACCT — build concatenated key strings for general information, asset category, location, asset key, and accounting flexfield combinations respectively.
  • GET_REQUEST_INFO and GET_ARGUMENTS — retrieve concurrent request metadata and the arguments passed to the running request, allowing extract programs to respond to user-supplied parameters.
  • ADD_DYNAMIC_COLUMN — registers a dynamically defined column, supporting the flexible-column reporting model used by FA_RX reports.
  • GET_FLEX_VAL_MEANING and CLEAR_FLEX_VAL_CACHE — return the descriptive meaning of a flexfield value and flush the package's cached flexfield value set.

Tables Accessed

The package reads from a broad set of Fixed Assets and supporting tables via APPS synonyms:

Usage Notes

FA_RX_SHARED_PKG is not intended to be called directly by end users or by custom application code. It is invoked internally by the FA_RX_* report and extract programs, which execute as concurrent programs submitted from the Fixed Assets responsibility. The procedures GET_ARGUMENTS and GET_REQUEST_INFO are typically called at the start of a concurrent program to read the user's parameter selections, while the CONCAT_* functions are called during report layout to assemble asset and account identifiers. ADD_DYNAMIC_COLUMN supports the FA_RX flexible-column model, and GET_FLEX_VAL_MEANING with CLEAR_FLEX_VAL_CACHE provide cached flexfield value descriptions to reduce repeated queries. Because the package is referenced by 34 other packages, any modification or recompilation should be coordinated carefully; invalidation of this package body can cascade to its dependents. Custom developers building Fixed Assets extracts should treat this package as read-only and use the supported public FA APIs instead.