Search Results get_registration

Overview

The APPS.FND_LDAP_WRAPPER package is the integration layer that connects Oracle E-Business Suite with an external Lightweight Directory Access Protocol (LDAP) directory, typically Oracle Internet Directory (OID) or a compatible Oracle Directory Server Enterprise Edition. Its business function is to broker user lifecycle operations—authentication, provisioning, synchronization, and password management—between EBS and the enterprise directory so that identities are maintained in a single authoritative source rather than duplicated manually across both systems. By encapsulating the LDAP calls behind a PL/SQL API, it allows EBS components such as FND_SSO_MANAGER, FND_LDAP_USER, FND_OID_UTIL, FND_USER_PKG, and FND_WEB_SEC to invoke directory operations through standard database packages without embedding direct LDAP client code. ETRM documents the object as VALID and owned by APPS, with an API classification of OTHER, and lists 19 documented procedures and functions.

Key Procedures and Functions

The package exposes a broad set of routines covering directory-aware user management and single sign-on support:

• CHANGE_USER_NAME — Renames a user in the directory to match a changed EBS user name.
• SYNCH_USER_FROM_LDAP — Pulls user attributes from the LDAP directory into the EBS user record.
• CREATE_USER — Provisions a new user entry in the directory.
• DELETE_USER — Removes a user entry from the directory.
• CHANGE_PASSWORD — Updates a user's password in the directory.
• USER_EXISTS — Checks whether a user record exists in the directory.
• GET_LDAP_USER_NAME — Returns the LDAP-side user name associated with an EBS identity.
• GET_ORCLAPPNAME — Retrieves the Oracle application name attribute used for directory mapping.
• LINK_USER — Associates an existing EBS user with an existing directory entry.
• UNLINK_USER — Removes that association without deleting either record.
• UPDATE_USER — Modifies directory attributes for an existing user.
• VALIDATE_LOGIN — Authenticates a user against the directory.
• IS_OPERATION_ALLOWED — Determines whether a requested LDAP operation is permitted under current configuration.
• GET_REGISTRATION — Retrieves registration details for a directory user.
• IS_PRESENT — Indicates whether a given LDAP attribute or entry is present.
• GET_REALM_DN — Returns the distinguished name of the configured realm.
• OID_SYNCHRONIZATION_ENABLED — Reports whether OID synchronization is currently active.
• UNLINK_EBIZ_USER — Removes the link between an EBS user and its directory counterpart.

Tables Accessed

Through APPS synonyms, the package references FND_USER, the core EBS user repository, to read and update user identity data such as user names, passwords, and session-related attributes. It also references ALL_OBJECTS, used to introspect database objects for existence or dependency checks, and DUAL for singleton queries and simple function evaluations. Per ETRM dependency information, FND_LDAP_WRAPPER references APPS.FND_USER and STANDARD, and is itself referenced by FND_LDAP_USER, FND_OID_UTIL, FND_SSO_MANAGER, FND_SSO_REGISTRATION, FND_USER_PKG, and FND_WEB_SEC.

Usage Notes

FND_LDAP_WRAPPER is not typically called by end users directly. It is invoked internally by EBS security and SSO infrastructure—particularly during user provisioning, password change or reset workflows, and login validation against the directory. It supports the Oracle Internet Directory integration mode configured through EBS profile options, and its behavior is gated by OID_SYNCHRONIZATION_ENABLED and IS_OPERATION_ALLOWED. Custom code should invoke these documented routines rather than issuing direct LDAP calls, to preserve compatibility with the EBS security model and with the dependent packages listed above. Any modifications to user names, passwords, or links through this package should be performed with appropriate APPS schema privileges.