Search Results fnd_user_desktop_objects_n1

Overview

APPLSYS.FND_USER_DESKTOP_OBJECTS is a transactional table in the Oracle E-Business Suite FND (Foundation) product that stores the documents and functions a user has placed in their Navigator window, scoped on a per-user and per-responsibility basis. Its stated purpose in the ETRM documentation is to persist the personalized layout of the Navigator, allowing each user to retain the shortcuts, documents, and function links they have arranged for a given responsibility.

The object is owned by the APPLSYS schema, resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and carries FND design data reference FND.FND_USER_DESKTOP_OBJECTS. It is classified as VALID and is present in both Oracle EBS 12.1.1 and 12.2.2, with fifteen documented columns.

Under a heuristic Data Vault classification mined from the foreign-key structure, this table behaves as a link entity: it connects a user, an application and responsibility context, and a desktop object definition into a single association row. This classification is a modeling suggestion rather than a physical attribute of the EBS table.

Key Information Stored

The table records a single Navigator placement per row. The most significant columns are:

• DESKTOP_OBJECT_ID — NUMBER, the internal primary key. It is also the column of the unique index FND_USER_DESKTOP_OBJECTS_U1 in the APPS_TS_TX_IDX tablespace, making it the documented business-key candidate and the principal lookup column.
• USER_ID — NUMBER, the user who saved the object on the Navigator; part of the nonunique index FND_USER_DESKTOP_OBJECTS_N1.
• APPLICATION_ID — NUMBER, the application identifier for the context in which the object was saved; also part of the N1 index.
• RESPONSIBILITY_ID — NUMBER, the responsibility the user was operating under when the object was saved; completes the N1 index columns.
• OBJECT_NAME — VARCHAR2(30), the internal key associated with the type of document.
• FUNCTION_NAME — VARCHAR2(30), the function to invoke in order to restore the document.
• OBJECT_LABEL — VARCHAR2(200), the text that identifies the object on the Navigator.
• PARAMETER_STRING — VARCHAR2(2000), additional parameters passed when invoking the restore function.
• SEQUENCE — NUMBER, controlling the order in which objects appear on the Navigator.
• TYPE — VARCHAR2, specifying whether the object is a document or a function.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN, supporting audit and concurrency tracking.

Common Use Cases and Queries

Typical scenarios include auditing which users have personalized a responsibility's Navigator, diagnosing missing or duplicated shortcuts, and reproducing a user's Navigator layout for migration or support purposes. The N1 index supports efficient retrieval of all objects for a user within an application and responsibility context.

To retrieve the Navigator contents for a specific user and responsibility:

• SELECT DESKTOP_OBJECT_ID, OBJECT_NAME, FUNCTION_NAME, OBJECT_LABEL, SEQUENCE, TYPE FROM APPLSYS.FND_USER_DESKTOP_OBJECTS WHERE USER_ID = :user_id AND APPLICATION_ID = :app_id AND RESPONSIBILITY_ID = :resp_id ORDER BY SEQUENCE;
• SELECT COUNT(*) FROM APPLSYS.FND_USER_DESKTOP_OBJECTS GROUP BY USER_ID, RESPONSIBILITY_ID — to report personalization density.
• Join to FND_USER and FND_RESPONSIBILITY to translate numeric identifiers into user names and responsibility names for reporting.

Because the table is per-user and per-responsibility, it is frequently queried during troubleshooting of Navigator rendering issues, particularly where FUNCTION_NAME or PARAMETER_STRING values are stale after a patch.

Related Objects

The foreign-key relationships documented for this table define its principal dependencies:

• FND_USER — referenced through USER_ID; supplies the user identity owning each Navigator row.
• FND_RESPONSIBILITY — referenced through APPLICATION_ID; establishes the responsibility context of the saved object.
• FND_DESKTOP_OBJECTS — referenced through OBJECT_NAME; provides the underlying desktop object definition restored into the Navigator.
• FND_USER_DESKTOP_OBJECTS_U1 — the unique index on DESKTOP_OBJECT_ID.
• FND_USER_DESKTOP_OBJECTS_N1 — the nonunique index on USER_ID, APPLICATION_ID, and RESPONSIBILITY_ID.

These relationships, together with the standard Who columns, make the table a foundational element of Navigator personalization in Oracle EBS.