Results for “ben_seed_person_types”

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

Overview

BEN_SEED_PERSON_TYPES is a seed data maintenance package that belongs to the APPS schema and is classified under the Oracle E-Business Suite Benefits (BEN) product family. Its principal business function is to populate and maintain the Person Type definitions that the Benefits module relies upon during initial implementation and subsequent upgrades. Person Types classify individuals tracked in Oracle HRMS—for example, Employee, Applicant, or External—and Benefits uses these classifications to determine eligibility rules, enrollment opportunities, and plan participation logic. Because Benefits configurations are meaningless without a consistent set of Person Types, this package acts as a controlled seeding utility rather than an end-user facing component. It ensures that the rows required by the Benefits business rules exist in the underlying Human Resources Person Type tables, and that any Benefit-specific extensions to those Person Types are created with the correct system-level attributes. In the ETRM 12.2.2 documentation the package is catalogued with an API classification of OTHER, indicating it is an internal data-loading routine rather than a public multitenant or business API.

Key Procedures and Functions

The documented metadata lists a single procedure, SEED_PERSON_TYPES. This procedure performs the seeding operation: it examines the existing Person Type definitions in the HR Person Types tables and inserts or updates the records that Benefits requires. Its purpose is to guarantee that the Person Types demanded by Benefits setup data—particularly the system Person Types consumed by Benefits eligibility processing—are present and correctly flagged. No parameter list is documented in the ETRM extract, and none should be assumed; the procedure is intended to be run without interactive input, typically during installation or upgrade patching. It is not designed for ad hoc execution by end users or application developers.

Tables Accessed

The package operates against two HRMS tables, referenced through APPS synonyms: PER_PERSON_TYPES and PER_PERSON_TYPES_S. PER_PERSON_TYPES holds the base Person Type definitions, including system names, user names, and the flags that identify system-level versus user-defined types. PER_PERSON_TYPES_S is the translated (language-specific) table that stores the display names for each Person Type in the active session language. The seeding procedure reads current contents to determine which definitions are missing, then writes the required rows into both tables so that a Benefit-specific or system Person Type appears correctly in both the base and translation layers. Keeping these tables synchronized is essential because HRMS forms and Benefits eligibility queries join them when presenting or evaluating Person Type data.

Usage Notes

BEN_SEED_PERSON_TYPES is an internal Oracle-supplied utility. It is not exposed through a standard EBS form or concurrent program and is not part of the documented public API surface; the ETRM metadata records no packages referencing it, which confirms it is invoked only by Oracle's own seeding and upgrade infrastructure. It is typically executed during Benefits setup or patch application, not during normal production operation. Custom developers should not call it directly, because doing so could conflict with Oracle's controlled seeding logic and produce duplicate or incorrectly flagged Person Type rows. When troubleshooting Benefits eligibility problems, administrators should treat the existence and correct flagging of Person Types in PER_PERSON_TYPES as the expected outcome of this package, and should use supported setup paths rather than invoking the procedure manually.