Results for “fnd_users”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.HR_DM_FND_USERS_V1 is a database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes a minimal, denormalized projection of Oracle EBS user identity data derived from the FND_USER foundation table. The view was created primarily in support of Oracle Human Resources Data Migration (HR_DM) functionality, which handles the extraction, transformation, and loading of HR and application user data during implementations, upgrades, and data conversion projects.

The view carries a documented Status of VALID and is registered in FND Design Data under the product short name PER (Human Resources) as PER.HR_DM_FND_USERS_V1. Its view type is listed as Internal, and the ETRM metadata includes an explicit Oracle Internal Use Only warning stating that Oracle Corporation does not support access to Oracle Applications data using this object except from standard Oracle Applications programs. Consequently, customers should treat it as a private, internal component rather than a published integration interface. Any direct querying of the view is at the customer's own risk, and its definition may change without notice between releases or patches.

Underlying Base Objects

The view is defined over a single documented base object: FND_USER, referenced through the APPS synonym of the same name. FND_USER is the central Oracle EBS repository of application user accounts; every Oracle EBS user, whether an employee, a supplier contact, or a self-service customer, is represented by a row in FND_USER. The view does not join to any additional tables, and the ETRM dependency metadata explicitly records that HR_DM_FND_USERS_V1 is not referenced by any other database object. It is therefore a terminal, read-only projection: nothing in the Oracle EBS data dictionary depends on it, so dropping or altering it would have no cascading dependency effects—though such changes are unsupported.

Key Columns

The view exposes only two columns, each mapped directly from FND_USER as documented in the view source listing:

  • USER_NAME_ID (NUMBER, length 15): The identifier carried from FND_USER. Despite the column name's resemblance to a user name, the metadata describes it as a numeric column sourced from FND_USER and it is not marked mandatory. Functionally it corresponds to the numeric user identifier (USER_ID) used throughout EBS tables such as FND_USER_RESP_GROUPS, FND_USER_PREFERENCES, and workflow tables, making it the join key for reconciling a user to other application data.
  • CREATED_NAME (VARCHAR2, length 100): The user name string from FND_USER (the login name, for example "JSMITH"). This is the human-readable identifier presented on the EBS login page and in the Users form.

Because FND_USER itself contains many additional attributes—such as encrypted password, start and end dates, email address, employee ID, and last logon date—practitioners seeking those fields must query FND_USER directly or use other, supported views.

Common Use Cases and Queries

The principal legitimate use case is internal HR data migration and the extraction of user identity pairs (numeric ID plus login name) to populate staging tables during conversion activities. A minimal query is:

SELECT USER_NAME_ID, CREATED_NAME FROM APPS.HR_DM_FND_USERS_V1;

A typical migration scenario joins the view to FND_USER to enrich the extraction with additional attributes:

SELECT v.USER_NAME_ID, v.CREATED_NAME, u.EMAIL_ADDRESS, u.START_DATE, u.END_DATE FROM APPS.HR_DM_FND_USERS_V1 v, APPS.FND_USER u WHERE v.USER_NAME_ID = u.USER_ID;

Because the view is not supported for direct access, any custom report, interface, or data conversion script should instead select from APPS.FND_USER, which is the documented and supported base table. The view should be regarded strictly as an Oracle-internal artifact: useful for understanding how HR_DM packages read user data, but not a foundation for customer-built integrations in either release 12.1.1 or 12.2.2.