Results for “hrdpp_create_user_acct”

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

Overview

The APPS.HRDPP_CREATE_USER_ACCT package is a PL/SQL metadata-mapped wrapper generated by hr_pump_meta_mapper (generator revision 115.31, dated 2004/10/27) for the underlying Oracle Human Resources API HR_USER_ACCT_API.CREATE_USER_ACCT. In Oracle EBS 12.1.1 and 12.2.2, this package forms part of the HR Data Pump / Batch Element architecture used by the Data Pump and Batch Element Loader concurrent programs. Its business purpose is to allow bulk creation of Oracle Applications user accounts linked to HR person records — that is, provisioning a system user name and login identity for a newly hired or transferred employee — through the standardized batch-line processing framework rather than through direct interactive entry.

The package is classified as OTHER in the ETRM inventory and sits alongside two referencing packages that also depend on the shared HR batch pump infrastructure. It is owned by APPS and is not a public API in the ordinary sense; it is an internal feeder that stages data lines, then delegates the real account-creation work to the seeded API.

Key Procedures and Functions

The package exposes seven documented program units: five utility functions and two procedures.

• DC — date conversion helper converting an DATE to VARCHAR2; declared with pragma restrict_references(...,WNDS), meaning it performs no database writes and is safe inside SQL.
• D — inverse conversion helper turning a VARCHAR2 string into a DATE, also restricted with WNDS.
• N — numeric conversion helper transforming a VARCHAR2 value into a NUMBER.
• DD — date-with-format conversion, returning a formatted VARCHAR2 from a DATE using a supplied format mask.
• ND — numeric-with-format conversion, returning a formatted VARCHAR2 from a NUMBER.
• INSERT_BATCH_LINES — the core staging procedure. Its signature carries batch identity (p_batch_id, p_data_pump_batch_line_id, p_data_pump_business_grp_name, p_user_sequence, p_link_value), person/assignment effective dating, assignment and hire dates, organization structure context, run type, and the person user key. It writes a new pending row into the HR batch-line tables for later processing. Parameter lists are reproduced here only as documented.
• CALL — the processing procedure that consumes a staged line, receiving p_business_group_id and p_batch_line_id, and invokes the underlying HR_USER_ACCT_API.CREATE_USER_ACCT to create the actual user account.

Tables Accessed

The package operates entirely against the HR pump tables exposed through APPS synonyms:

• HR_PUMP_BATCH_LINES and HR_PUMP_BATCH_LINES_S — the primary staging intersection (and its shadow) holding the incoming account-creation data lines.
• HR_PUMP_BATCH_LINE_USER_KEYS and HR_PUMP_BATCH_LINE_USER_KEYS_S — store the externally supplied user key that establishes the person-to-user mapping required by the account API.
• HR_PUMP_BATCH_EXCEPTIONS — captures any error or rejection rows produced when a staged line fails during the CALL phase, allowing downstream error reporting.

Usage Notes

This package is typically invoked in a two-phase pattern. First, a feeder process (the Data Pump / Batch Element Loader concurrent program, or a custom loader built on the same template) calls INSERT_BATCH_LINES to stage rows. Second, the batch processor calls CALL per row within the business-group context, which delegates to HR_USER_ACCT_API.CREATE_USER_ACCT. Exceptions are logged to HR_PUMP_BATCH_EXCEPTIONS.

Because the package name is not the seeded API — the real API is HR_USER_ACCT_API — custom code should prefer calling the seeded API directly unless it is deliberately integrating with the batch pump framework. The utility functions (DC, D, N, DD, ND) are internal conversion aids and are not intended as general-purpose helpers.

Note: the search term “add account in Zoho WorkDrive” is unrelated to this Oracle EBS package; results for that query concern Zoho’s cloud file-management product, not Oracle HRMS user-account creation.