Search Results g_mail




Overview
Explore in AI Chat

Overview

APPS.FND_OID_BULKLOAD is a public Oracle E-Business Suite 12.1.1 / 12.2.2 database package responsible for bulk import of user accounts from an external Oracle Internet Directory (OID) or LDAP-compliant directory into the EBS FND_USER repository. The package belongs to the Oracle Application Object Library (FND) technology stack and forms part of the broader Oracle Directory Services integration used to synchronize identities between Oracle Fusion Middleware infrastructure components and the EBS application tier.

The package declares a set of global constants that govern its runtime behaviour. These include binary status flags (G_SUCCESS, G_FAILURE, G_TRUE, G_FALSE) and character constants describing the mail and facsimile attributes (G_MAIL, G_FACSIMILETELEPHONENUMBER) used during LDAP attribute mapping. Notably, the constant G_COM_PROD_ORCLECTX is declared as varchar2(4000) with the value 'cn=Common,cn=Products,cn=OracleContext'. This represents the distinguished name (DN) of the Oracle Context subtree in the directory information tree. It is the anchor point from which the package resolves user entries, product-specific principals, and Oracle Application Server / OID configuration objects during bulk load operations. Additional globals (g_dbldapauthlevel, g_dbwalletdir, g_dbwalletpass) support the database-level LDAP authentication and wallet credential configuration required to bind securely to the directory.

Key Procedures and Functions

  • IMPORT_USER — The single documented entry point. It performs a bulk import of one or more user records sourced from the configured LDAP/OID directory into EBS. Behaviour is governed by its parameters: an LDAP message structure describing the source identity, a duplicate-handling indicator controlling how existing accounts are treated, an output return status, and a TCA record flag (defaulting to 'Y') that determines whether a Trading Community Architecture party record is created alongside the FND user.

Tables Accessed

The package interacts with FND_USER, the core EBS user repository, via APPS synonyms. IMPORT_USER writes imported identity records into FND_USER and validates against existing rows when resolving duplicates. The TCA record flag extends the operation to associated party tables maintained by the Trading Community Architecture, ensuring a synchronised user-and-party footprint.

Usage Notes

FND_OID_BULKLOAD is typically invoked as part of the OID/LDAP integration configuration administered from the Oracle EBS System Administrator responsibility. It supports the migration and reconciliation of directory users, for example following an OID registration or during a bulk onboarding cycle. Because the package is classified as OTHER rather than a frozen public API, direct custom invocation is discouraged; integration is instead achieved through the standard directory services setup, concurrent processing, or the Diagnostic/Directory integration flows. Any custom driver code must supply valid LDAP message records and correctly handle the returned status, while ensuring database wallet credentials and authentication level globals are configured before execution.