Search Results get_description_sql

Overview

FII_GL_BIS_MSC_PKG is an APPS-owned PL/SQL package classified under the "OTHER" API category within Oracle E-Business Suite. It is part of the Financial Intelligence/General Ledger business intelligence (BIS) integration layer and exists primarily to resolve descriptive text for General Ledger Accounting Flexfield segment values. The package header carries the source control tag FIIGLBSS.pls 120.1, dated 2005/09/27, authored by SGAUTAM, indicating that this object belongs to an earlier generation of the EBS codebase and remains present in both the 12.1.1 and 12.2.2 releases. Its central purpose is to act as a thin wrapper around the standard Oracle GL flexfield utility package, gl_flexfields_pkg.get_description_sql, so that reporting and analytics views (notably glfv_gl_accounts_descr) can retrieve a human-readable description for a given chart of accounts and segment combination without duplicating flexfield logic.

Key Procedures and Functions

• GET_DESCRIPTION_SQL — The sole documented routine in the package. It is a wrapper function that delegates to gl_flexfields_pkg.get_description_sql to obtain the description associated with a GL Accounting Flexfield segment value. Per the documented usage example, the function accepts a chart of accounts identifier, a segment column name (for example SEGMENT10), and the segment value itself, and returns the resolved segment value description as a VARCHAR2 value. The p_coa_id argument carries the Chart of Accounts identifier, p_column_name identifies which segment is being queried, and p_seg_val supplies the value whose description is required.

Tables Accessed

The documented table reference for this package is FND_ID_FLEX_SEGMENTS, accessed through its APPS synonym. This is the standard Application Object Library table that stores the definition of key flexfield structures and their segments, including the segment column names used by the GL Accounting Flexfield. The wrapper function reads this metadata indirectly through the underlying gl_flexfields_pkg call in order to map the supplied p_column_name to the correct flexfield segment definition before resolving the descriptive value. No direct inserts, updates, or deletes against application tables are documented for this package; it is a read-only utility in practice.

Usage Notes

FII_GL_BIS_MSC_PKG is typically invoked from reporting and BIS data-collection code, custom SQL statements, and views that need a segment description resolved dynamically rather than through a stored denormalized column. It is referenced by one other package within the documented metadata, which confirms its role as a shared helper rather than a standalone business service. Because the function returns a VARCHAR2 description, it is well suited for use inside SELECT lists and view definitions such as glfv_gl_accounts_descr. Developers should note that the routine predates modern EBS coding standards and reflects the 11i-era naming conventions; in 12.1.1 and 12.2.2 environments it is generally retained for backward compatibility, and new development should consider calling gl_flexfields_pkg or the current flexfield APIs directly. Performance considerations are typical of flexfield description lookups, and calls should be limited where large result sets are anticipated.