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.
-
Table: FND_USER
12.2.2
owner:APPLSYS, object_type:TABLE, fnd_design_data:FND.FND_USER, object_name:FND_USER, status:VALID, product: FND - Application Object Library , description: Application users , implementation_dba_data: APPLSYS.FND_USER ,
-
Table: FND_USER
12.1.1
owner:APPLSYS, object_type:TABLE, fnd_design_data:FND.FND_USER, object_name:FND_USER, status:VALID, product: FND - Application Object Library , description: Application users , implementation_dba_data: APPLSYS.FND_USER ,
-
APPS.HR_WIP_LCKS dependencies on FND_USER
12.1.1
-
APPS.JAI_AR_TCS_REP_PKG dependencies on FND_USER
12.1.1
-
APPS.CN_INVOICE_CHANGES_PVT dependencies on FND_USER
12.1.1
-
APPS.GMD_QC_ERES_UTILS dependencies on FND_USER
12.1.1
-
APPS.IES_TELESALES_BP_PKG dependencies on FND_USER
12.1.1
-
APPS.QA_SPECS_PUB dependencies on FND_USER
12.1.1
-
APPS.CTO_AUTO_PROCURE_PK dependencies on FND_USER
12.1.1
-
APPS.PV_OPP_MATCH_PUB dependencies on FND_USER
12.1.1
-
APPS.ASO_WORKFLOW_QUOTE_PVT dependencies on FND_USER
12.1.1
-
APPS.IGS_PE_GEN_001 dependencies on FND_USER
12.1.1
-
APPS.AMW_UTILITY_PVT dependencies on FND_USER
12.1.1
-
APPS.HXC_APPROVAL_WF_HELPER dependencies on FND_USER
12.1.1
-
APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on FND_USER
12.1.1
-
APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on FND_USER
12.1.1
-
APPS.PO_DIFF_SUMMARY_PKG dependencies on FND_USER
12.1.1
-
APPS.QPR_WKFL_UTIL dependencies on FND_USER
12.1.1
-
APPS.POS_ACK_SEARCH dependencies on FND_USER
12.1.1
-
APPS.AST_OFL_PIPELINE_BUCKETS_PARAM dependencies on FND_USER
12.1.1
-
APPS.MSC_CL_SCE_COLLECTION dependencies on FND_USER
12.1.1
-
APPS.CSM_PARTY_EVENT_PKG dependencies on FND_USER
12.1.1
-
APPS.HXT_TIME_GEN dependencies on FND_USER
12.1.1
-
APPS.AP_WEB_UTILITIES_PKG dependencies on FND_USER
12.1.1
-
APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on FND_USER
12.1.1
-
APPS.PQH_BDGT_REALLOC_UTILITY dependencies on FND_USER
12.1.1
-
APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on FND_USER
12.1.1
-
APPS.PER_RI_CONFIG_UTILITIES dependencies on FND_USER
12.1.1
-
APPS.EAM_COMMON_UTILITIES_PVT dependencies on FND_USER
12.1.1
-
APPS.POS_REG_WF_PKG dependencies on FND_USER
12.1.1
-
APPS.ORACLEAPPS dependencies on FND_USER
12.1.1
-
APPS.IBE_UTIL dependencies on FND_USER
12.1.1
-
APPS.JTF_UM_PASSWORD_PVT dependencies on FND_USER
12.1.1
-
APPS.FEM_UD_PKG dependencies on FND_USER
12.1.1
-
APPS.PON_RESPONSE_IMPORT_PKG dependencies on FND_USER
12.1.1
-
APPS.JTF_RS_RESOURCE_PVT dependencies on FND_USER
12.1.1
-
APPS.GMF_BURDENDETAILS_PVT dependencies on FND_USER
12.1.1
-
APPS.ZPB_WF_NTF dependencies on FND_USER
12.1.1
-
APPS.WFA_SEC dependencies on FND_USER
12.1.1
-
APPS.IGC_CC_COMMON_UTILS_PVT dependencies on FND_USER
12.1.1
-
APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on FND_USER
12.1.1
-
APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on FND_USER
12.1.1
-
APPS.GMD_QMSED dependencies on FND_USER
12.1.1
-
APPS.ARP_CMREQ_WF dependencies on FND_USER
12.1.1
-
APPS.PO_FORWARD_SV1 dependencies on FND_USER
12.1.1
-
APPS.UMX_REG_REQUESTS_PVT dependencies on FND_USER
12.1.1
-
APPS.GL_GLWACCTR_XMLP_PKG dependencies on FND_USER
12.1.1
-
APPS.AP_WEB_PROJECT_PKG dependencies on FND_USER
12.1.1
-
APPS.GMD_QMDSC dependencies on FND_USER
12.1.1
-
APPS.GMDRVLAP_WF_PKG dependencies on FND_USER
12.1.1