Search Results get_arguments




Overview
Explore in AI Chat

Overview

APPS.FA_RX_SHARED_PKG is a shared utility package within the Oracle E-Business Suite Fixed Assets (FA) module. Its central purpose is to consolidate reusable routines that support asset accounting, depreciation processing, and the reconciliation reporting framework often referred to as the RX (Reconciliation/Extract) layer in Oracle Assets. The package serves as a common library that other Fixed Assets packages and concurrent programs call to obtain accounting flexfield segment information, construct concatenated account and key strings, resolve flexfield value meanings, and retrieve request or runtime arguments. Because it is declared with AUTHID CURRENT_USER, it executes with the privileges of the calling schema, which is consistent with shared APPS-level utility packages that must respect the calling user's security context. The header source references version 120.12, a maintenance level current to the 11i/12.1.1 era and still delivered under 12.2.2.

Key Procedures and Functions

The package exposes a set of documented procedures, several of which operate on collection types such as Seg_Array (a 30-character index-by table) and several VARCHAR2/NUMBER index-by tables used for bulk segment handling.

  • GET_ACCT_SEGMENT_NUMBERS / GET_ACCT_SEGMENT_INDEX — Return the segment positions for the balancing, natural account, and cost center segments for a given book, based on the accounting flexfield structure.
  • GET_ACCT_SEGMENTS — Populates a Seg_Array with the individual segment values that constitute a combination ID.
  • FADOLIF — Performs depreciation-related life and rate calculation supporting the FADOLIF logic used when determining depreciation terms.
  • FA_RSVLDG — Drives reserve ledger reporting for a specified book and period.
  • CONCAT_GENERAL, CONCAT_CATEGORY, CONCAT_LOCATION, CONCAT_ASSET_KEY, CONCAT_ACCT — Build concatenated descriptive or account strings for general, category, location, asset key, and accounting contexts, returning both a string and a populated segment array.
  • GET_REQUEST_INFO, GET_ARGUMENTS — Retrieve concurrent request context and parameter information passed into the calling report.
  • ADD_DYNAMIC_COLUMN — Supports dynamic column construction, typically for flexible extract layouts.
  • GET_FLEX_VAL_MEANING — Resolves the descriptive meaning of a key flexfield value.
  • GET_ASSET_INFO — Returns asset-level detail for reporting use.
  • CLEAR_FLEX_VAL_CACHE — Clears the in-package cached flexfield value/meaning data, forcing subsequent lookups to be refreshed.

The user's search term, clear_flex_val_cache, corresponds directly to this last documented procedure. It is invoked to purge cached flexfield value meanings so that stale descriptive flexfield or key flexfield values are not reused within the same session.

Tables Accessed

The package reads and, in limited cases, references the following APPS synonym tables: FND_FLEX_VALUES (flexfield value meanings), AP_INVOICES_ALL (invoice linkage), FA_ASSET_HISTORY, FA_ASSET_INVOICES, FA_BOOKS, FA_BOOK_CONTROLS, FA_CATEGORY_BOOKS, FA_DEPRN_DETAIL, FA_DEPRN_PERIODS, FA_DISTRIBUTION_HISTORY, FA_LOOKUPS, FA_MC_BOOKS, FA_MC_DEPRN_DETAIL, FA_MC_DEPRN_PERIODS, and FA_RESERVE_LEDGER_GT. The FA_* tables supply asset, book, depreciation, and multi-currency (MC) information, while FND_FLEX_VALUES supplies flexfield meaning lookups and the temporary global table FA_RESERVE_LEDGER_GT holds reserve ledger result sets.

Usage Notes

FA_RX_SHARED_PKG is referenced by 34 other packages, confirming its role as a shared dependency rather than a top-level entry point. It is normally invoked indirectly from Oracle Assets reconciliation reports, depreciation and reserve ledger concurrent programs, and Oracle Forms-based asset maintenance screens that need concatenated account strings or segment positions. Customizations and extensions within the Fixed Assets module commonly call its procedures, particularly CLEAR_FLEX_VAL_CACHE when a session changes books or flexfield definitions. Because the package relies on APPS synonyms, it must be called from the APPS schema or an environment where those synonyms are accessible, and its AUTHID CURRENT_USER declaration means the caller's privileges govern access to the underlying tables.