Search Results fa_fadi_shared_pkg




Overview
Explore in AI Chat

Overview

FA_FADI_SHARED_PKG is a shared utility package in the Oracle E-Business Suite Fixed Assets (FA) module, owned by the APPS schema. The package body carries the version header farfadib.pls 120.3, dated 2009/03/26. Its documented scope comprises a single public procedure, GET_ACCT_SEGMENT_NUMBERS, which resolves the segment positions of the balancing, natural account, and cost center qualifiers within the Accounting Flexfield structure assigned to a given asset book. The package is classified as OTHER in the ETRM API registry, meaning it is an internal support routine rather than a formally published public API, and it is not referenced by any other documented package.

The business purpose of the package is to insulate Fixed Assets subledger logic from the physical ordering of segments in the chart of accounts. Because the GL Accounting Flexfield can be configured with an arbitrary segment sequence, downstream FA programs frequently need to know which segment number corresponds to which GL qualifier before they can build or parse account combinations. FA_FADI_SHARED_PKG centralizes that lookup so that callers do not embed structure-specific assumptions in their own code.

Key Procedures and Functions

  • GET_ACCT_SEGMENT_NUMBERS — Accepts a book identifier (BOOK) and returns three OUT NOCOPY numeric values: the balancing segment number, the account segment number, and the cost center segment number. It also accepts a CALLING_FN parameter for error-context tracing and an FA_API_TYPES.log_level_rec_type logging record. The procedure first queries FA_BOOK_CONTROLS to obtain the accounting_flex_structure for the specified book, then makes three successive calls to fnd_flex_apis.get_qualifier_segnum, requesting the qualifiers GL_BALANCING, GL_ACCOUNT, and FA_COST_CTR respectively against application 101 (General Ledger) and key flexfield code GL#. Each call returns a boolean success flag; a FALSE result raises the private exception get_qualifier_segnum_failed, which is handled by a NULL handler. Any other exception is propagated through FA_STANDARD_PKG.RAISE_ERROR with the procedure name and the caller's identity recorded.

Tables Accessed

  • FA_BOOK_CONTROLS — Read-only access via the APPS synonym. The procedure selects the accounting_flex_structure column, filtered by book_type_code, to determine which key flexfield structure number governs the book. This structure number is then passed to all three qualifier lookups. No rows are inserted, updated, or deleted by this package.

Usage Notes

Because only one procedure is documented and no other package references it, invocation is expected from within Fixed Assets internal code paths or from customer extensions that need qualifier-to-segment mapping in a book-specific context. Typical callers include asset accounting routines, depreciation and transfer programs, and any custom concurrent program or form personalization that must construct a full account combination for a book whose chart of accounts is not fixed by convention. The CALLING_FN parameter should always be supplied with a meaningful caller identifier, since it is passed verbatim into the standard FA error handler and appears in the resulting error message, aiding diagnosis when a book is configured without the expected qualifiers. Callers should be prepared for the OUT parameters to remain unset if the qualifier lookup fails, because the internal exception handler suppresses that condition silently. The package is consistent across EBS 12.1.1 and 12.2.2, as the underlying FND_FLEX_APIS and FA_BOOK_CONTROLS interfaces are unchanged between those releases.