Search Results product_categories

Overview

ENI_VALUESET_CATEGORY is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to support the EDW (Enterprise Data Warehouse) category-set population process, specifically for PRODUCT_CATEGORIES structures used by the Material Management/Inventory (VBH) functional area. The package is classified under the API classification of OTHER, meaning it is not a formally published open interface but is used internally to drive a concurrent process that validates the structure of a category set and then populates category data.

The package relies on package-level global variables to manage state and error handling across its internal procedures. Notably, g_error boolean := false is declared as a global flag, along with g_errbuf varchar2(10000), g_warn boolean := false, and g_count number. The search term "g_error" refers directly to this package-level boolean, which signals whether validation has failed and drives the concurrent manager return code logic.

Key Procedures and Functions

• ENI_POPULATE_MAIN — The controlling (main) procedure that manages the flow of the concurrent program and handles concurrent manager variables. It accepts Errbuf and retcode OUT parameters. It sets up log and output files (enivalcat.log / enivalcat.out) using the EDW_LOGFILE_DIR profile, calls the validation function, and depending on the g_error and g_warn flags, assigns the appropriate retcode (0, 1, or 2) and error buffer.
• ENI_VALIDATE_STRUCTURE — A boolean function that validates whether the structure associated with the category set is a PRODUCT_CATEGORIES structure. It retrieves the VBH category set, checks the associated ID flex structure, verifies segment definitions and enabled values, and uses user-defined exceptions (invalid_segment, segment_not_enabled, value_set_null) to report structural problems. It returns TRUE on error (populating g_error) and FALSE on success.
• ENI_POPULATE_CATEGORY — The procedure that performs the actual population of category data once validation succeeds. It is invoked by ENI_POPULATE_MAIN only after validation completes without setting g_error.
• GET_FLEX_VALUE_SET_ID — A function used to obtain the flex value set ID for the category structure, supporting validation and population logic.

Tables Accessed

• MTL_DEFAULT_CATEGORY_SETS — Read to obtain the VBH category set id (functional_area_id = 11), defaulting to 1000000006 when no data is found.
• MTL_CATEGORY_SETS / MTL_CATEGORY_SETS_B — Read to link the category set to its structure.
• FND_ID_FLEX_STRUCTURES — Read to retrieve the ID flex structure number associated with the category set.
• FND_ID_FLEX_SEGMENTS — Read to validate segment definitions and enabled flags.
• MTL_CATEGORIES_B / MTL_CATEGORIES_TL — Read (and potentially used during population) to obtain category base and translated data.

Usage Notes

ENI_VALUESET_CATEGORY is typically invoked from a concurrent program in Oracle EBS, given its use of FND_FILE logging and the Errbuf/retcode concurrent manager variables. Because retcode values of 1 (warning) and 2 (error) are set based on g_warn and g_error, it integrates with the standard concurrent manager completion-status model. The package is referenced by one other package, indicating it belongs to a larger EDW/ENI (Enterprise Intelligence) processing chain. It is not a public API; modifications should be avoided, and callers should rely on the concurrent request output rather than direct invocation. Since the header note shows it as a "noship" internal file, it is not intended for customer-facing extension.