Search Results csl_fnd_user_acc_pkg




Overview
Explore in AI Chat

Overview

CSL_FND_USER_ACC_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It resides in the Oracle EBS Release 12.1.1 and 12.2.2 environments and is classified under the ETRM metadata as an OTHER type API rather than a standard public interface. The package serves as a controlled access layer for user account records held in the FND_USER table. Its central business function is to provide a compliant mechanism for replicating and maintaining user account information across application contexts, allowing controlled insert, update, delete, and replication operations on user records without directly manipulating the underlying Oracle Applications foundation tables. The package is currently in VALID status, indicating that it compiles successfully and its dependencies are satisfied in the environment where it was documented.

Key Procedures and Functions

The package exposes four documented procedures, each aligned to a distinct data manipulation operation against user account data.

  • REPLICATE_RECORD — Copies or propagates a user account record, typically to synchronize user data between the source and a target context or destination store. This is the distinguishing operation of the package and reflects its role in user account propagation.
  • INSERT_USER — Creates a new user account record. This procedure encapsulates the logic required to add a user entry through the package rather than through a direct insert.
  • UPDATE_USER — Modifies an existing user account record, applying changes to attributes maintained for the user.
  • DELETE_USER — Removes a user account record, providing the package's removal path for user data.

No parameter signatures are documented in the ETRM metadata; the descriptions above reflect the operation implied by each procedure name.

Tables Accessed

The package references the FND_USER table through its APPS synonym. FND_USER is the Oracle Applications foundation table that stores application user accounts, including login credentials, effective dates, and account status. All four procedures operate against this single documented table: INSERT_USER writes new rows, UPDATE_USER modifies existing rows, DELETE_USER removes rows, and REPLICATE_RECORD reads and re-applies user data. Dependencies also include FND_GLOBAL, JTM_HOOK_UTIL_PKG, JTM_MESSAGE_LOG_PKG, and the STANDARD package. FND_GLOBAL supplies session and user context such as the current application user; JTM_HOOK_UTIL_PKG and JTM_MESSAGE_LOG_PKG support hook invocation and message logging for error capture and diagnostics.

Usage Notes

CSL_FND_USER_ACC_PKG is typically invoked from custom Oracle EBS code rather than from seeded forms or concurrent programs, consistent with its OTHER API classification and its absence from the standard FND public API set. The ETRM metadata states that it is referenced by four other packages, so it functions as a lower-level utility called by those dependent packages during user provisioning, replication, or maintenance cycles. Direct calls from custom PL/SQL, wrapper packages, or subscription and synchronization logic are the expected invocation paths. Because the package writes to FND_USER, it should be called with appropriate validation and error handling, using the JTM_MESSAGE_LOG_PKG logging facility for diagnostics. The package does not appear to be referenced by any database object other than its documented callers, and direct table manipulation should be avoided in favor of the procedures it exposes.