Search Results create_gl_coa_flex_values




Overview
Explore in AI Chat

Overview

GL_COA_SEG_VAL_IMP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the bulk import of chart of accounts segment values into the Oracle General Ledger key flexfield structures. In Release 12.1.1 and 12.2.2, the accounting flexfield remains the foundational structure through which every accounting combination, journal entry, and balance is validated. This package provides the programmatic entry point through which externally sourced or mass-loaded segment values can be pushed into the flexfield value sets that define the chart of accounts, allowing organizations to populate or extend their account hierarchies without manual keying in the Segment Values form.

The package is classified as an OTHER API in the ETRM repository and is marked VALID. Its dependency footprint confirms that it operates as a thin wrapper over the public import interface, APPS.GL_COA_SEG_VAL_IMP_PUB, while itself depending on the FND_API error-handling and message framework. It is referenced by GL_COA_SEGMENT_VAL_PVT, the private package that underpins the segment value maintenance user interface, indicating that the same import machinery can be reached from both batch and online processing paths.

Key Procedures and Functions

Two documented procedures are exposed by the package:

  • CREATE_GL_COA_FLEX_VALUES — The principal import routine responsible for creating flexfield values for the accounting flexfield value sets. It drives the validation and insertion logic against the FND flexfield tables, applying value set rules and hierarchy definitions as the supplied segment values are processed.
  • CREATE_GL_COA_FLEX_VALUES_NH — A companion variant of the primary routine, distinguished by the "NH" suffix, which conventionally denotes no-hierarchy processing. This procedure supports the creation of chart of accounts segment values without engaging the flexfield hierarchy structures, a useful mode when the target value set does not maintain rollup hierarchies.

Both procedures are designed to leverage the shared error-handling conventions of FND_API, so callers can expect standard success, error, and message-list behavior typical of EBS public APIs.

Tables Accessed

The package reads and writes the core flexfield definition tables through APPS synonyms, including FND_FLEX_VALUES, where the segment values themselves are stored, and FND_FLEX_VALUE_SETS, which identifies the value set each segment value belongs to. FND_FLEX_VALIDATION_QUALIFIERS and FND_FLEX_VALUE_NORM_HIERARCHY are consulted to enforce validation qualifiers and normalized hierarchy relationships respectively. FND_FLEX_HIERARCHIES is referenced when hierarchy processing applies, while PLITBLM is the standard PL/SQL table type used for passing arrays of values into the import routines.

Usage Notes

GL_COA_SEG_VAL_IMP_PKG is not typically invoked directly by end users. It is most commonly reached through the segment value import user interface or a related concurrent program, and through GL_COA_SEGMENT_VAL_PVT, which wraps its functionality for the Accounts segment value maintenance forms. Custom integrations loading segment values from external source systems should call either the documented procedures here or the underlying GL_COA_SEG_VAL_IMP_PUB interface, supplying properly constructed PL/SQL tables and honoring the FND_API return conventions. Because the package writes directly into flexfield definition tables, it should be invoked only by privileged accounts, ideally during controlled load windows, with validation performed before values are committed to the chart of accounts.