Search Results validate_structure_tl

Overview

APPS.GL_CHART_OF_ACCOUNTS_API_PKG is a public PL/SQL API in Oracle E-Business Suite that validates Chart of Accounts information loaded through the iSpeed data migration utility. The package specification declares AUTHID CURRENT_USER, indicating it executes with the privileges of the calling session rather than the definer. Its scope is confined to validation and compilation of Accounting Key Flexfield (id-flex) metadata imported in bulk, rather than to transactional general ledger activity.

The package begins with the header comment $Header: gluvcoas.pls 120.0 2003/01/31 23:40:47 djogg ship $, and its history records creation on 10.09.2000 by O Monnier. The specification exposes a large family of predefined exceptions (for example invalid_dml_mode, flexfield_must_exist, gl_value_set_must_exist, invalid_value, invalid_minimum_maximum, and value_meaning_not_unique) that mirror the validation rules applied across structure, segment, value set, and value records. In ETRM 12.2.2 the package is classified as API type OTHER and is listed as referenced by zero other packages, confirming its role as an entry point invoked by external loaders rather than by other server-side code.

Key Procedures and Functions

The package exposes 13 documented procedures and functions, grouped by the metadata object they validate:

• VALIDATE_STRUCTURE and VALIDATE_STRUCTURE_TL — validate key flexfield structure definitions and their translated (TL) attributes prior to insertion.
• VALIDATE_SEGMENT and VALIDATE_SEGMENT_TL — validate segment definitions assigned to a structure, including translated segment names.
• VALIDATE_SEG_ATTRIBUTE_VALUE — validate segment attribute values, such as required, displayed, and security flags.
• VALIDATE_VALUE_SET — validate flexfield value set definitions, including format, size, and security characteristics.
• VALIDATE_VALIDATION_QUALIFIER — validate validation qualifiers used by value sets and values.
• VALIDATE_VALUE and VALIDATE_VALUE_TL — validate individual flexfield values and their translated descriptions, including minimum and maximum boundaries.
• VALIDATE_FINAL_STRUCTURE — performs a final consistency check on a fully populated structure before it is accepted.
• VALIDATE_HIERARCHY and COMPILE_HIERARCHY — validate and compile flexfield value hierarchies.
• COMPILE_KEY_FLEXFIELD — compiles the key flexfield structure after its component records have been validated and inserted.

The procedures address a specific rule from the exception list and raise the corresponding predefined exception when validation fails. A user searching for validate_value is therefore directed to VALIDATE_VALUE and VALIDATE_VALUE_TL, which cover the value records in FND_FLEX_VALUES and FND_FLEX_VALUES_TL.

Tables Accessed

The package reads and writes the following tables through APPS synonyms, and the reasons are evident from their ownership:

• FND_ID_FLEXS, FND_ID_FLEX_STRUCTURES, and FND_ID_FLEX_SEGMENTS — the key flexfield registration and segment definition tables validated by VALIDATE_STRUCTURE, VALIDATE_SEGMENT, and VALIDATE_FINAL_STRUCTURE.
• FND_FLEX_VALUE_SETS, FND_FLEX_VALUES, and FND_FLEX_VALUES_TL — value set and value definition tables validated by VALIDATE_VALUE_SET, VALIDATE_VALUE, and VALIDATE_VALUE_TL.
• FND_FLEX_VALIDATION_QUALIFIERS and FND_FLEX_VALUE_NORM_HIERARCHY — qualifier and hierarchy definitions used by VALIDATE_VALIDATION_QUALIFIER, VALIDATE_HIERARCHY, and COMPILE_HIERARCHY.
• FND_SEGMENT_ATTRIBUTE_TYPES and FND_SEGMENT_ATTRIBUTE_VALUES — validation of segment attribute assignments such as GL segment required and displayed flags.
• FND_APPLICATION, FND_COLUMNS, and FND_TABLES — used to confirm the application, table, and column references supplied for a flexfield definition.
• FND_PRODUCT_INSTALLATIONS — used to verify that the products owning referenced flexfields are installed.
• FND_FLEX_WORKFLOW_PROCESSES — accessed for workflow-related flexfield configuration validation.

Usage Notes

GL_CHART_OF_ACCOUNTS_API_PKG is invoked during the iSpeed chart of accounts import process. The loader calls the VALIDATE_* procedures as each type of record (structure, segment, value set, value, qualifier, hierarchy) is staged, and then calls VALIDATE_FINAL_STRUCTURE followed by COMPILE_KEY_FLEXFIELD and COMPILE_HIERARCHY once the structure is complete. Because the package runs with AUTHID CURRENT_USER, the calling session must hold the appropriate privileges on the FND flexfield tables. In 12.2.2 it is documented as referenced by zero other packages, so custom migration code, concurrent program wrappers, or forms-based loaders are the typical callers. When validation fails, the caller should catch the named exception matching the specific procedure and report the associated condition rather than attempting to parse a generic SQL error.