Search Results fnd_user




In Oracle E-Business Suite (EBS), the FND_USER table is a critical system table that stores information about users who have access to the Oracle EBS application. Here's a detailed description:

Table Name: FND_USER

Purpose:
- Stores user account information
- Manages user authentication and access control
- Contains details about individual users within the Oracle EBS system

Key Columns:
1. USER_ID (Primary Key)
- Unique identifier for each user
- Automatically generated sequence number
- Used in many other tables for user references

2. USER_NAME
- Login username for the user
- Must be unique across the system
- Often based on employee email or naming convention

3. EMAIL_ADDRESS
- User's email address
- Used for communication and notifications

4. START_DATE
- Date when user account becomes active

5. END_DATE
- Date when user account expires or becomes inactive

6. LAST_LOGON_DATE
- Timestamp of the most recent user login

7. PASSWORD
- Encrypted user password
- Follows Oracle's password complexity rules

8. CREATED_BY
- User ID of the person who created the account

9. CREATION_DATE
- Timestamp when the user account was created

10. LAST_UPDATED_BY
- User ID of the person who last modified the account

Additional Attributes:
- Tracks user status (active/inactive)
- Supports multiple security profiles
- Integrates with Oracle Identity Management

Common Usage:
- User provisioning
- Security administration
- Auditing user activities

Typical Query Example:
```sql
SELECT user_name, email_address, last_logon_date
FROM fnd_user
WHERE user_name = 'SYSADMIN';
```

This table is fundamental for managing user access and authentication in Oracle E-Business Suite.