Search Results hr_process_address_ss




Overview
Explore in AI Chat

Overview

HR_PROCESS_ADDRESS_SS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It is a server-side ("_SS") package associated with the Oracle HRMS person address feature set, and it operates in the address maintenance layer of the Human Resources module. Its role is to provide the procedural logic that creates and updates person address records in the PER_ADDRESSES entity, while coordinating the associated API transaction bookkeeping and workflow context that Oracle HRMS applies to person-level address changes.

In ETRM 12.2.2 the package carries an API classification of OTHER, reflecting that it is not a public, supported business API in the sense of a documented HRMS date-tracked API, but rather an internal processing unit invoked on behalf of higher-level HR flows. The package is dependent on HR_API, the shared HRMS API utility package, and on Workflow item attribute storage, indicating that address processing is executed in the context of a workflow item and relies on standard HR_API error-handling and date-tracked table-handling conventions.

Key Procedures and Functions

The package exposes six documented procedures and functions:

  • CREATE_PERSON_ADDRESS — Creates a new address for a person, performing the insertion into the person address entity and the surrounding HRMS housekeeping required for a valid address record.
  • UPDATE_PERSON_ADDRESS — Modifies an existing person address, applying the date-tracked update semantics expected by HRMS address data.
  • GET_ADDRESS_DATA_FROM_TT — Retrieves address information from a PL/SQL table type (the "TT" naming convention) passed into the package, decoupling the caller's data structure from the package's internal processing.
  • PROCESS_API — The central driver that coordinates the API processing path, routing the request through the appropriate create or update logic and handling the interaction with HR_API and workflow context.

The remaining documented program units follow the same internal-helper pattern. Parameter lists are intentionally not reproduced here, as they are not part of the supplied metadata.

Tables Accessed

The package references the following tables through APPS synonyms:

  • PER_ADDRESSES — The primary HRMS store of person address records; the target of the create and update operations.
  • PER_ALL_PEOPLE_F — The date-tracked people entity, consulted to validate the person for whom the address is being maintained and to honour effective-dating.
  • HR_API_TRANSACTION_STEPS — Records API transaction processing steps, used to track the progress and outcome of the address API call.
  • WF_ITEM_ATTRIBUTES — Oracle Workflow item attribute storage, used when the address operation is executed within a workflow-driven process.
  • PLITBLM — The standard Oracle HRMS PL/SQL table used for character/string collection handling, supporting the table-type based data transfer described above.

Usage Notes

HR_PROCESS_ADDRESS_SS is an internal implementation package rather than a directly invoked public API. It is referenced by the standalone program unit of the same name, HR_PROCESS_ADDRESS_SS, and it in turn depends on HR_API and the Workflow attribute table. In Oracle EBS 12.1.1 and 12.2.2 it is typically reached through person address maintenance forms and HRMS address-related concurrent or workflow processes rather than being called directly.

When extending address handling, developers should prefer supported HRMS person APIs and treat HR_PROCESS_ADDRESS_SS as a subordinate processing layer. The package is marked VALID in both 12.1.1 and 12.2.2, and it is not referenced by any other package, which confirms its position as a leaf-level internal processor within the HRMS address stack.