Search Results fnd_object_instance_sets_s

Overview

The APPS.FND_OBJECT_INSTANCE_SETS_PKG package body encapsulates the create, read, update, and delete logic for Oracle EBS object instance sets. Object instance sets define groupings of application object instances that are used by the Oracle E-Business Suite personalization and extensibility framework to scope rules, functional administrator configurations, and other runtime behaviors to a specific set of objects or instances. The package is owned by the APPS schema and is classified as a general utility (OTHER) API rather than a formal public interface. It resides alongside its specification FND_OBJECT_INSTANCE_SETS_PKG and the underlying tables FND_OBJECT_INSTANCE_SETS, FND_OBJECT_INSTANCE_SETS_TL, and the sequence FND_OBJECT_INSTANCE_SETS_S. The package is documented as VALID in ETRM for both 12.1.1 and 12.2.2, and it is referenced by four other packages, indicating it is a shared dependency within the application foundation layer rather than an isolated utility.

Key Procedures and Functions

The documented package exposes nine procedures and functions. Their purposes are:

• INSERT_ROW — Creates a new object instance set record, populating the base table and its translation table entries as required.
• LOCK_ROW — Acquires a row-level lock on an existing instance set so that concurrent updates are serialized.
• UPDATE_ROW — Applies changes to an existing instance set row, preserving audit and language-specific columns.
• LOAD_ROW — Acts as an idempotent loader used primarily by the FNDLOAD utility to insert or update instance set definitions from a data file.
• TRANSLATE_ROW — Handles the translated (TL) columns for a given language, allowing multilingual descriptions to be uploaded or refreshed independently of the base row.
• DELETE_ROW — Removes an instance set definition, including its translated child rows.
• ADD_LANGUAGE — Inserts missing FND_OBJECT_INSTANCE_SETS_TL rows for languages that have been enabled after the instance set was originally created.

Two additional procedures are present in the package body but are not individually enumerated in the excerpt; the above list reflects the seven named routines and their documented roles.

Tables Accessed

The package operates on the following tables, reached through APPS synonyms:

• FND_OBJECT_INSTANCE_SETS — The primary base table storing instance set definitions.
• FND_OBJECT_INSTANCE_SETS_TL — The translation table holding language-specific names and descriptions.
• FND_OBJECT_INSTANCE_SETS_S — The sequence that supplies primary key values for new rows; this is the object most commonly associated with the user search string fnd_object_instance_sets_s.
• FND_LANGUAGES — Consulted when performing language-related operations such as ADD_LANGUAGE and TRANSLATE_ROW.
• FND_OBJECTS — The registry of application objects referenced by instance sets.
• DUAL — Used for singleton selects such as sequence retrieval.

Usage Notes

This package is an internal foundation API. It is most commonly invoked by the FNDLOAD concurrent program during object instance set migrations, by the Functional Administrator and personalization forms when users maintain instance set definitions, and by multilanguage patching routines that call ADD_LANGUAGE to backfill translations. Custom code should call these routines only through the package specification and should not modify the underlying tables directly, because the package enforces locking, audit columns, and translation consistency. Because the package is referenced by four other database objects, any patch that invalidates it can cascade to dependent personalization and administration components. Developers diagnosing invalidations should verify that FND_OBJECT_INSTANCE_SETS_PKG remains VALID after upgrades, and should compile the specification and body together to avoid secondary dependency errors. The presence of LOAD_ROW and TRANSLATE_ROW confirms that instance set metadata is fully supported by the FNDLOAD seed-data mechanism, allowing it to be extracted and re-imported across environments.