Search Results fnd_desktop_objects_u1

Overview

APPLSYS.FND_DESKTOP_OBJECTS is a foundational Oracle E-Business Suite configuration table that stores the icon association for each object used to place documents on the EBS Navigator (the main application menu). Within the APPLSYS schema, the table acts as the authoritative registry linking a developer-defined object name to the icon that represents it in the user interface. The object carries FND Design Data reference FND.FND_DESKTOP_OBJECTS, is documented with status VALID in ETRM 12.1.1 / 12.2.2, and resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10.

From a dimensional modeling perspective, the mined relationship data classifies FND_DESKTOP_OBJECTS as hub-leaning. The table holds one distinct row per object with no transitive dependencies on other entities, and it is referenced by dependent tables — the classic signature of a hub in a Data Vault model. This classification is a suggested analytical lens rather than a physical EBS construct; the table itself is a conventional transactional configuration table.

Key Information Stored

The table contains seven documented columns. The most significant are:

• OBJECT_NAME (VARCHAR2(30), mandatory) — the developer name of the object. This is the business-key candidate and the single column of the unique index FND_DESKTOP_OBJECTS_U1 in tablespace APPS_TS_TX_IDX. The relationship metadata also documents a primary key, FND_DESKTOP_OBJECTS_UK1, on the same column, confirming OBJECT_NAME as the natural identifier.
• ICON_NAME (VARCHAR2(30)) — the name of the icon associated with the object, which drives the visual representation presented to the user on the Navigator.
• LAST_UPDATE_DATE (DATE) and CREATION_DATE (DATE) — standard Who columns capturing the audit timestamps of the last modification and initial creation.
• LAST_UPDATED_BY (NUMBER(15)) and CREATED_BY (NUMBER(15)) — standard Who columns identifying the EBS user IDs responsible for the last update and for creation.
• LAST_UPDATE_LOGIN (NUMBER(15)) — standard Who column recording the login context of the last update.

Unlike many EBS transactional tables, no surrogate numeric primary key is documented; OBJECT_NAME serves as the de facto surrogate and business key simultaneously.

Common Use Cases and Queries

Administrators and developers query this table to audit or troubleshoot Navigator icon assignments, to verify that a custom object has an icon defined, and to reconcile icon configuration across environments during cloning or migration. A typical lookup resolves an object to its icon:

• SELECT object_name, icon_name FROM applsys.fnd_desktop_objects WHERE object_name = :object_name;
• Reporting on objects lacking a defined icon: SELECT object_name FROM applsys.fnd_desktop_objects WHERE icon_name IS NULL;
• Auditing recent configuration changes using the Who columns: SELECT object_name, icon_name, last_updated_by, last_update_date FROM applsys.fnd_desktop_objects ORDER BY last_update_date DESC;

Because the table is small and static by nature, it is frequently used as a reference in joins with user-level personalization data to report which icons a given user has customized.

Related Objects

The documented dependency data identifies FND_USER_DESKTOP_OBJECTS as referencing this table through the OBJECT_NAME column, allowing queries that join user-level desktop customizations back to the master icon registry. The ETRM entry records FND_DESKTOP_OBJECTS# as the internal referenced object. Beyond these, the table is commonly associated with the FND Navigator menu configuration and the FND_APPLICATION and FND_MENUS family of objects that define the navigable function hierarchy, since desktop object icons are surfaced through those menus. Joins typically proceed on OBJECT_NAME to FND_USER_DESKTOP_OBJECTS.OBJECT_NAME, and indirectly through application or menu identifiers to present a complete Navigator picture. No foreign keys originating from FND_DESKTOP_OBJECTS are documented, confirming its position as a referenced (hub) entity rather than a dependent one.