Search Results glstfl_vs_col_name

Overview

GL_FLATTEN_SETUP_DATA is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the General Ledger "flattening" process. Flattening is the mechanism through which Oracle General Ledger materializes the hierarchical accounting flexfield and value set structures that define a chart of accounts into denormalized, query-efficient structures. In release 12.1.1 and 12.2.2, this preparation step is essential because accounting flexfield and value set metadata is normally stored across multiple normalized tables (value sets, validation tables, and ledger assignments). By flattening that metadata, the application avoids repeated joins when validating, reporting, and posting journal entries across large volumes of data.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user. Its header, dated 2005, contains package-level state variables that track the chart of accounts identifier, the flex value set identifier and its backing table and column names, the operation mode, debug flag, user/login/request identifiers, and balance and management value set identifiers. Notably, these values mirror the parameters of the underlying FND_STRUCTURE and FND_FLEX flattening interfaces, confirming the package is a wrapper for that setup data preparation.

Key Procedures and Functions

• MAIN — The primary entry point. It accepts a mode of operation, a mode parameter (either a chart of accounts identifier or a flex value set identifier), and an optional debug flag, then initializes the package variables and dispatches to the appropriate routines. An overloaded concurrent-program form of MAIN exists for submission from Oracle Forms, using the standard errbuf and retcode arguments.
• GL_FLATTEN_RULE — Defines or retrieves the flattening rule applied to a given value set or structure, governing which segments and validation sources are flattened.
• GET_VALUE_SET_INFO — Resolves and returns metadata about a flex value set, including its underlying validation table and identifying column, which is required before flattening can proceed.
• REQUEST_LOCK / RELEASE_LOCK — Acquire and release a concurrency lock, preventing simultaneous flattening runs from corrupting shared setup data.
• CLEAN_UP — Releases package-level variables and temporary state at the conclusion of a run.

Tables Accessed

The package reads and refreshes core General Ledger and Application Object Library metadata: FND_FLEX_VALUE_SETS and FND_FLEX_VALIDATION_TABLES (value set definitions and their validation sources), GL_LEDGERS and GL_LEDGER_NORM_SEG_VALS (ledger definitions and normalized segment values), GL_ACCESS_SET_NORM_ASSIGN and GL_LEDGER_SET_NORM_ASSIGN (access set and ledger set assignments), and FND_PROFILE_OPTION_VALUES (profile option settings). Workflow tables WF_EVENT_T and WF_PARAMETER_LIST_T support event signaling on completion. DBMS_LOCK provides locking, DBMS_MVIEW is used to refresh materialized views created during flattening, and PLITBLM supports index-organized temporary tables.

Usage Notes

GL_FLATTEN_SETUP_DATA is invoked as a concurrent program from Oracle General Ledger setup, typically after changes to a chart of accounts, value set, or ledger assignment, and is referenced by four other packages in the application. It is not a public API and should not be called directly from custom code; administrators generally run the associated concurrent request to regenerate flattened setup data. Because it relies on DBMS_LOCK and materialized view refreshes, sufficient privileges and scheduling windows are required, and the concurrent form of MAIN should be used when submitting through Oracle Forms.