Search Results fnd_objects_s




Overview
Explore in AI Chat

Overview

The APPS.FND_OBJECTS_PKG package body is a foundational metadata maintenance utility within the Oracle E-Business Suite Application Object Library (FND). Its principal business function is to manage the repository of registered Oracle EBS objects stored in the FND_OBJECTS tables, providing the insert, update, lock, translation, and deletion logic required to keep that repository synchronized across a multi-language, multi-schema installation. In Oracle EBS 12.1.1 and 12.2.2, the FND_OBJECTS entity underpins several dependent features, including object-level security, function and menu configuration, and the loading of seed data during patching and installation. The package body is reported as VALID in the APPS schema and forms part of the standard FND data-management layer that is invoked by concurrent programs, AD utilities, and the FNDLOAD utility framework.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions within this package body, listed here with their purpose:

  • INSERT_ROW — Creates a new object definition row in the FND_OBJECTS base table and its associated translation rows.
  • LOCK_ROW — Obtains a row-level lock on an existing object record, preventing concurrent modification during transactional processing.
  • UPDATE_ROW — Modifies the attributes of an existing object definition, preserving referential consistency with the translation tables.
  • LOAD_ROW — Loads or merges object definitions supplied by the FNDLOAD data-loading utility, supporting seed and patch data delivery.
  • TRANSLATE_ROW — Inserts or updates translated (non-base-language) attribute values in the TL table.
  • DELETE_ROW — Removes an object definition and its dependent translation records.
  • ADD_LANGUAGE — Populates translation rows for a newly installed or activated language.

Two additional documented routines complement this set. The exact parameter signatures are not reproduced in the ETRM excerpt; the descriptions above reflect the standard behavior of FND object-management APIs and should be verified against the deployed package specification.

Tables Accessed

The package body references the following tables through APPS synonyms:

  • FND_OBJECTS — the primary definition table holding object records.
  • FND_OBJECTS_TL — the translation table holding language-specific object names and descriptions.
  • FND_OBJECTS_S — the sequence used to generate primary key values for new object rows.
  • FND_APPLICATION — provides application context for object registration.
  • FND_LANGUAGES — identifies installed and active languages for translation processing.
  • DUAL — used for single-row queries and PL/SQL initialization.

Additional dependencies include the APP_EXCEPTION, FND_LOAD_UTIL, and FND_MESSAGE packages, which supply error handling, loader integration, and message resolution respectively.

Usage Notes

FND_OBJECTS_PKG is not referenced by any other database object, which indicates it is invoked directly rather than nested within higher-level PL/SQL code. Typical invocation paths include FNDLOAD-based object loading during patching, the concurrent programs that manage object registration, and Oracle Forms-based maintenance screens that manipulate object definitions. Custom development teams should treat the package as a controlled repository interface: use it rather than direct DML against FND_OBJECTS to ensure translations, locks, and sequence values remain consistent. Because the package is delivered as a standard FND component, it should not be modified; extensions should be implemented through supported customization layers.