Search Results glstfl_coa_id

Overview

GL_FLATTEN_SETUP_DATA is an internal Oracle General Ledger package body that supports the flattening of accounting setup data, including chart of accounts value sets, segment value hierarchies, and related ledger and access set assignments. Flattening refers to the process of pre-computing and materializing the hierarchical relationships and validation structures that General Ledger relies upon during journal entry validation, account generation, and reporting. By flattening this setup data, Oracle EBS avoids recursive traversal of parent-child hierarchies at runtime, which would otherwise impose significant performance overhead on high-volume transaction processing.

The user search term glstfl_coa_id relates to the chart of accounts identifier used during flattening operations. Within this package, related global variables such as GLSTFL_VS_ID, GLSTFL_VS_TAB_NAME, and GLSTFL_VS_COL_NAME are populated during value set processing; the package similarly tracks the chart of accounts context (glstfl_coa_id) so that the correct value sets, hierarchies, and ledger normal segment values are flattened for the appropriate accounting configuration. This identifier scopes the flattening work to a single chart of accounts, ensuring that only the relevant setup structures are processed. The package belongs to the APPS schema in Oracle EBS 12.1.1 and 12.2.2 and is classified as an OTHER API, meaning it is an internal utility rather than a public, supported interface for external integration.

Key Procedures and Functions

• MAIN — Entry point of the package. Drives the overall flattening process, coordinating value set verification, locking, hierarchy flattening, and cleanup work.
• CLEAN_UP — Performs post-processing cleanup, removing or reconciling interim data structures and releasing resources once flattening completes.
• GET_VALUE_SET_INFO — Determines whether a given value set is table-validated and returns the underlying table and column names used to validate segment values. A private helper, Check_Seg_val_Hierarchy, invokes this routine before flattening.
• REQUEST_LOCK — Acquires a lock on a value set or similar parameter (for example via a value set ID) using DBMS_LOCK, typically in exclusive mode with retry logic, to prevent concurrent flattening of the same structure.
• RELEASE_LOCK — Releases the lock previously obtained by REQUEST_LOCK once processing completes or aborts.
• GL_FLATTEN_RULE — Applies the flattening logic to the rules governing chart of accounts and ledger setup, driving the derivation of the flattened hierarchy representation.

Tables Accessed

The package reads and writes setup metadata through APPS synonyms. FND_FLEX_VALUE_SETS and FND_FLEX_VALIDATION_TABLES identify value sets and their table-validated columns. GL_LEDGERS, GL_LEDGER_NORM_SEG_VALS, GL_ACCESS_SET_NORM_ASSIGN, and GL_LEDGER_SET_NORM_ASSIGN provide ledger, segment value, and access set assignments. FND_PROFILE_OPTION_VALUES supplies profile-driven configuration. WF_EVENT_T and WF_PARAMETER_LIST_T handle workflow event and parameter persistence. DBMS_LOCK provides locking, DBMS_MVIEW supports materialized view refresh, and PLITBLM is the PL/SQL table/index-by utility.

Usage Notes

GL_FLATTEN_SETUP_DATA is invoked internally by General Ledger setup and maintenance flows rather than directly by end users. It is referenced by four other packages, confirming its role as a dependent utility. Typical invocation occurs during chart of accounts and ledger configuration changes, and when flattening must be re-run after value set or hierarchy modifications. A concurrent program wrapper or form-driven action submits the work; custom code should not call these procedures directly, as they are unsupported internals subject to change between releases.