Search Results dbms_ldap_api_ffi

Overview

SYS.DBMS_LDAP_API_FFI is a valid Oracle-supplied PL/SQL package owned by the SYS schema. Its name indicates a Foreign Function Interface (FFI) layer for the core LDAP PL/SQL toolkit, which is the mechanism Oracle Database uses to expose lightweight directory access protocol (LDAP) operations to PL/SQL through calls into underlying external libraries. Within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 code base, this package underpins directory-based services such as Oracle Internet Directory (OID) integration, single sign-on (SSO), user authentication, and directory synchronization.

The ETRM metadata classifies this object with an API classification of OTHER, and no documented procedures or functions are exposed in the reference material. Its business function is therefore best understood through its dependency relationships rather than through a published API surface. The package is intended for internal use by the Oracle database and by other LDAP toolkit packages, not as a supported customization entry point.

Key Procedures and Functions

The ETRM documentation records zero documented procedures or functions for SYS.DBMS_LDAP_API_FFI. No parameter lists are published, and none should be assumed. This absence is consistent with the object being an internal low-level binding package whose routines are deliberately undocumented and subject to change without notice.

The package body is listed in the metadata, indicating that the implementation exists and compiles as VALID. Functionally, it serves as the bridge layer beneath DBMS_LDAP and DBMS_LDAP_UTL, translating PL/SQL calls into operations handled by the underlying directory access library. Because the callable interface is undocumented, any invocation from custom code carries upgrade and portability risk.

Tables Accessed

The ETRM metadata lists no tables referenced via APPS synonyms for this package. Rather than performing direct SQL against EBS application tables, DBMS_LDAP_API_FFI operates against the database’s external LDAP interface, so its data exchange occurs at the directory protocol level rather than through SQL DML against schema objects.

Its documented dependencies consist entirely of PL/SQL objects: it references DBMS_LDAP, DBMS_LDAP_UTL, and STANDARD. It is in turn referenced by DBMS_LDAP, DBMS_LDAP_UTL, and itself (two dependent packages are recorded). This creates a tightly coupled internal call graph in which the higher-level toolkit packages drive directory operations and DBMS_LDAP_API_FFI services them.

Usage Notes

SYS.DBMS_LDAP_API_FFI is not a supported EBS application programming interface. It is invoked indirectly whenever EBS components perform directory operations, including SSO authentication flows, OID user provisioning and reconciliation, and directory synchronization routines in Oracle Applications Manager. These flows are driven by the EBS technology stack and by Oracle-provided concurrent processes and configuration utilities rather than by form-level or user-facing code.

Because the package is SYS-owned and undocumented, custom development should use the documented DBMS_LDAP and DBMS_LDAP_UTL packages instead. Direct calls to DBMS_LDAP_API_FFI are unsupported, may fail after database or EBS patch application, and should not be introduced into custom concurrent programs, forms, or interfaces. Its presence in a dependency listing is best treated as evidence that LDAP toolkit functionality is installed and functional.

PACKAGE: SYS.DBMS_LDAP_API_FFI 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LDAP_API_FFI, status:VALID,
PACKAGE: SYS.DBMS_LDAP_API_FFI 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LDAP_API_FFI, status:VALID,
PACKAGE BODY: SYS.DBMS_LDAP_API_FFI 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LDAP_API_FFI, status:VALID,
PACKAGE BODY: SYS.DBMS_LDAP_API_FFI 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LDAP_API_FFI, status:VALID,
LIBRARY: SYS.DBMS_LDAP_API_LIB 12.2.2
owner:SYS, object_type:LIBRARY, object_name:DBMS_LDAP_API_LIB, status:VALID,
PACKAGE: SYS.DBMS_LDAP 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LDAP, status:VALID,
PACKAGE: SYS.DBMS_LDAP 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LDAP, status:VALID,
PACKAGE BODY: SYS.DBMS_LDAP 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LDAP, status:VALID,
PACKAGE: SYS.DBMS_LDAP_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LDAP_UTL, status:VALID,
LIBRARY: SYS.DBMS_LDAP_API_LIB 12.1.1
owner:SYS, object_type:LIBRARY, object_name:DBMS_LDAP_API_LIB, status:VALID,
PACKAGE BODY: SYS.DBMS_LDAP_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LDAP_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_LDAP 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LDAP, status:VALID,
PACKAGE: SYS.DBMS_LDAP_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LDAP_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_LDAP_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LDAP_UTL, status:VALID,
PACKAGE: SYS.DBMS_LDAP_API_FFI 12.1.1
PACKAGE: SYS.DBMS_LDAP_API_FFI 12.2.2
PACKAGE BODY: SYS.DBMS_LDAP_API_FFI 12.2.2
PACKAGE BODY: SYS.DBMS_LDAP_API_FFI 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
SYS.DBMS_LDAP dependencies on DBMS_LDAP_API_FFI 12.1.1
SYS.DBMS_LDAP_UTL dependencies on DBMS_LDAP_API_FFI 12.1.1
SYS.DBMS_LDAP dependencies on DBMS_LDAP_API_FFI 12.2.2
SYS.DBMS_LDAP_API_FFI dependencies on DBMS_LDAP_API_FFI 12.1.1
SYS.DBMS_LDAP_API_FFI dependencies on DBMS_LDAP_API_FFI 12.2.2
SYS.DBMS_LDAP_UTL dependencies on DBMS_LDAP_API_FFI 12.2.2
SYS.DBMS_LDAP_API_FFI dependencies on DBMS_LDAP 12.2.2
SYS.DBMS_LDAP_API_FFI dependencies on DBMS_LDAP 12.1.1
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,