Results for “hr_user_acct_api”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.HR_USER_ACCT_API is a public PL/SQL package within the Oracle E-Business Suite Human Resources (PER) product family that manages the lifecycle of user accounts associated with persons and assignments. In the 12.1.1 and 12.2.2 releases, this package provides the programmatic interface for creating and maintaining the FND_USER records that connect an HR person to an application login. Because user accounts in EBS tie together identity, security, and responsibility assignments, this API is the supported entry point for building or altering a user account without directly manipulating the underlying FND tables.

The package is classified as an API in the ETRM repository, is owned by the APPS schema, and is documented as licensed for use with Human Resources. Its primary business purpose is to enforce the validation and referential integrity rules that surround user account creation — ensuring that the person exists as of the effective date, that the assignment context is valid, and that the security profile, responsibility, and menu relationships resolve correctly before any data is written. A second package references HR_USER_ACCT_API, and HR_USER_ACCT_API itself references two other packages, indicating it participates in a layered call stack rather than operating in isolation.

Key Procedures and Functions

• CREATE_USER_ACCT — Creates a new user account for a person. The API requires that the person exists as of the effective date and accepts effective-dating context for both the person record and the assignment. On success the user account is created; on failure the account is not created and an error is raised. The procedure supports a validation-only mode (p_validate) in which all checks are performed but the database remains unchanged, allowing callers to dry-run account creation. Parameters include identifiers and effective dates for the person, the assignment, the business group, and a date range governed by run type.
• UPDATE_USER_ACCT — Modifies an existing user account. Where CREATE_USER_ACCT establishes the account, UPDATE_USER_ACCT maintains it, applying changes to the account and its associated security and responsibility configuration while preserving the same validation discipline applied at creation.

Both procedures are the only documented entry points in the package; internal packaging artifacts (private global variables) are not part of the public contract and should not be referenced.

Tables Accessed

The package reads and writes through APPS synonyms across two functional areas:

• User and security infrastructure: FND_USER (the account record itself), FND_SECURITY_GROUPS, FND_RESPONSIBILITY and FND_RESPONSIBILITY_TL, FND_MENUS, FND_REQUEST_GROUPS, FND_DATA_GROUPS, and FND_PROFILE_OPTION_VALUES. These provide the responsibility, menu, request group, data group, and profile value scaffolding that must resolve for a valid account.
• HR and security profile context: PER_SEC_PROFILE_ASSIGNMENTS links security profiles to the HR person or assignment, and PLITBLM is an internal PL/SQL table used for bulk processing within the package.

The combination reflects the package's role: it is not merely inserting a row into FND_USER, but validating that the surrounding responsibility, menu, and security profile graph is consistent for the person being granted access.

Usage Notes

HR_USER_ACCT_API is typically invoked from forms or concurrent programs that provision or update application access for employees, and it is the recommended interface for custom code that must create or amend a user account in a supported manner. Because it performs its own validation and supports p_validate, callers should invoke it in validation mode first in integration or batch scenarios before committing changes. Direct DML against FND_USER and the related security tables bypasses the checks enforced here and is strongly discouraged. In 12.1.1 and 12.2.2 the package header remains stable, making it a reliable integration point for provisioning workflows that span HR and application security.