Results for “get_acct_segments”
9 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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:
- FA_BOOKS, FA_BOOK_CONTROLS, FA_MC_BOOKS — asset book balances and book control information, including the multi-currency book variants.
- FA_DEPRN_DETAIL, FA_DEPRN_PERIODS, FA_MC_DEPRN_DETAIL, FA_MC_DEPRN_PERIODS — depreciation detail and period definitions.
- FA_ASSET_HISTORY, FA_ASSET_INVOICES, FA_DISTRIBUTION_HISTORY, FA_RETIREMENTS — asset transaction history, invoice associations, distribution history, and retirements.
- FA_CATEGORY_BOOKS, FA_LOOKUPS, FA_SYSTEM_CONTROLS, FA_RESERVE_LEDGER_GT — category book defaults, lookup values, system controls, and the reserve ledger global temporary table.
- AP_INVOICES_ALL, PO_VENDORS — payables invoice and supplier information used when reporting asset invoices.
- FND_FLEX_VALUES, FND_ID_FLEX_SEGMENTS, FND_ID_FLEX_STRUCTURES, GL_CODE_COMBINATIONS — flexfield definition and value data, plus the GL code combination table.
- FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_REQUESTS, FND_PROFILE, FND_MESSAGE — concurrent request, profile, and message infrastructure.
- FA_RX_CONC_MESG_PKG, FA_RX_DYNAMIC_COLUMNS, FA_RX_UTIL_PKG, FA_CACHE_PKG, PLITBLM, DBMS_SQL — sibling FA_RX utilities, the dynamic column definition table, the FA cache package, the PL/SQL table type, and dynamic SQL support.
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.