Search Results per_ri_config_utilities
Overview
PER_RI_CONFIG_DATAPUMP_ENTITY is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It forms part of the Oracle Human Resources "RI Config" (Reporting Information Configuration / legislative data configuration) infrastructure used to manage the reference data that underpins Oracle HRMS legislative and enterprise configuration. The package is classified as OTHER in the ETRM metadata, indicating that it is not exposed as a public, declaratively documented API but rather functions as an internal technical utility supporting the RI Configuration framework.
The core business function of PER_RI_CONFIG_DATAPUMP_ENTITY is to construct "batch lines" — staged, entity-specific data rows — that represent organizational and legislative structures for consumption by a data pump process. These batch lines are used during the extraction, staging, or migration of configuration information such as business groups, legal entities, operating companies, locations, and enterprises. This aligns it with data-dump and setup-copy scenarios commonly seen in EBS where legislative reference and organizational hierarchy data must be moved between environments or consolidated.
Its dependencies confirm its role as a technical layer: it references PER_RI_CONFIG_FND_HR_ENTITY and PER_RI_CONFIG_TECH_SUMMARY, and is itself invoked by higher-order packages including PER_RI_CONFIG_MAIN and, notably, PER_RI_CONFIG_UTILITIES — the object the user searched for. The reciprocal dependency between PER_RI_CONFIG_DATAPUMP_ENTITY and PER_RI_CONFIG_UTILITIES (listed twice, reflecting both package and body references) demonstrates that the two work in tandem within the RI Configuration execution flow.
Key Procedures and Functions
The package exposes five documented procedures, each responsible for generating batch lines for a specific configuration entity type:
- CREATE_LOCATIONS_BATCH_LINES — Builds batch lines representing location records, staging address and location configuration data for the data dump.
- CREATE_ENTERPRISE_BATCH_LINES — Constructs batch lines for enterprise-level configuration, reflecting the top-level organizational grouping.
- CREATE_OPER_COMP_BATCH_LINES — Produces batch lines for operating company entities, capturing the operating units within the legislative structure.
- CREATE_LE_BATCH_LINES — Generates batch lines for legal entity records, a key component of HRMS legislative configuration.
- CREATE_BG_BATCH_LINES — Creates batch lines for business group entities, the foundational organizational unit in Oracle HRMS.
These procedures follow a consistent naming and design pattern, each addressing a single entity level in the organizational and legislative hierarchy. No parameter lists are documented in the ETRM metadata and none are asserted here.
Tables Accessed
The package references the following tables through APPS synonyms:
- HR_ALL_ORGANIZATION_UNITS — the base organization definition table, used to source business group, legal entity, operating company, and enterprise structures.
- PER_ENT_SECURITY_GROUPS and FND_SECURITY_GROUPS_TL — security group definitions, relevant to segregating configuration data by security context.
- PER_RI_CONFIG_INFORMATION and PER_RI_CONFIG_LOCATIONS — the RI configuration repository tables that store configuration metadata and location configuration, which the batch line procedures read and populate.
Usage Notes
PER_RI_CONFIG_DATAPUMP_ENTITY is an internal technical package and is not intended for direct invocation by end users. It is typically called by PER_RI_CONFIG_MAIN and PER_RI_CONFIG_UTILITIES as part of a coordinated RI Configuration process, which may itself be driven by a concurrent program or a setup-copy routine within Oracle HRMS. Its procedures would execute in a batch context to assemble entity-level staged data before a data pump transfers that data. Custom code should not call these procedures directly; integrators should instead invoke the higher-level RI Configuration entry points, allowing the framework to manage the sequencing and security-group context.
-
PACKAGE: APPS.PER_RI_CONFIG_DATAPUMP_ENTITY
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIG_DATAPUMP_ENTITY, status:VALID,
-
PACKAGE: APPS.PER_RI_CONFIG_DATAPUMP_ENTITY
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIG_DATAPUMP_ENTITY, status:VALID,
-
PACKAGE: APPS.PER_RI_CONFIG_UTILITIES
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIG_UTILITIES, status:VALID,
-
SYNONYM: APPS.FND_REQUEST_GROUPS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_REQUEST_GROUPS, status:VALID,
-
PACKAGE: APPS.PER_RI_CONFIG_UTILITIES
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIG_UTILITIES, status:VALID,
-
PACKAGE: APPS.PER_RI_CONFIG_FND_HR_ENTITY
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIG_FND_HR_ENTITY, status:VALID,
-
PACKAGE: APPS.PER_RI_CONFIG_FND_HR_ENTITY
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIG_FND_HR_ENTITY, status:VALID,
-
PACKAGE: APPS.PER_RI_CONFIG_TECH_SUMMARY
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIG_TECH_SUMMARY, status:VALID,
-
SYNONYM: APPS.PER_RI_CONFIG_INFORMATION
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PER_RI_CONFIG_INFORMATION, status:VALID,
-
SYNONYM: APPS.FND_REQUEST_GROUPS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_REQUEST_GROUPS, status:VALID,
-
SYNONYM: APPS.PER_RI_CONFIG_INFORMATION
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_RI_CONFIG_INFORMATION, status:VALID,
-
PACKAGE: APPS.PER_RI_CONFIG_TECH_SUMMARY
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIG_TECH_SUMMARY, status:VALID,
-
VIEW: APPS.FND_DATA_GROUPS_STANDARD_VIEW
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:FND.FND_DATA_GROUPS_STANDARD_VIEW, object_name:FND_DATA_GROUPS_STANDARD_VIEW, status:VALID,
-
VIEW: APPS.FND_DATA_GROUPS_STANDARD_VIEW
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:FND.FND_DATA_GROUPS_STANDARD_VIEW, object_name:FND_DATA_GROUPS_STANDARD_VIEW, status:VALID,
-
PACKAGE BODY: APPS.PER_RI_CONFIG_UTILITIES
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_RI_CONFIG_UTILITIES, status:VALID,
-
PACKAGE BODY: APPS.PER_RI_CONFIG_UTILITIES
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_RI_CONFIG_UTILITIES, status:VALID,
-
SYNONYM: APPS.FND_RESPONSIBILITY_TL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_RESPONSIBILITY_TL, status:VALID,
-
SYNONYM: APPS.FND_RESPONSIBILITY_TL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_RESPONSIBILITY_TL, status:VALID,
-
SYNONYM: APPS.PER_RI_CONFIG_VSETS_NUMBER_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_RI_CONFIG_VSETS_NUMBER_S, status:VALID,
-
SYNONYM: APPS.PER_RI_CONFIG_VSETS_NUMBER_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PER_RI_CONFIG_VSETS_NUMBER_S, status:VALID,
-
SYNONYM: APPS.PER_RI_CONFIG_RESPONSIBILITY
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_RI_CONFIG_RESPONSIBILITY, status:VALID,
-
SYNONYM: APPS.PER_RI_CONFIG_RESPONSIBILITY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PER_RI_CONFIG_RESPONSIBILITY, status:VALID,
-
PACKAGE: APPS.FND_RESPONSIBILITY_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_RESPONSIBILITY_PKG, status:VALID,
-
SYNONYM: APPS.PAY_LEG_SETUP_DEFAULTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PAY_LEG_SETUP_DEFAULTS, status:VALID,
-
SYNONYM: APPS.PAY_LEG_SETUP_DEFAULTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PAY_LEG_SETUP_DEFAULTS, status:VALID,
-
PACKAGE: APPS.PER_RI_CONFIG_MAIN
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIG_MAIN, status:VALID,
-
PACKAGE: APPS.FND_RESPONSIBILITY_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_RESPONSIBILITY_PKG, status:VALID,
-
SYNONYM: APPS.FND_DATA_GROUPS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_DATA_GROUPS, status:VALID,
-
PACKAGE: APPS.FND_FUNCTION_SECURITY
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_FUNCTION_SECURITY, status:VALID,
-
SYNONYM: APPS.FND_DATA_GROUPS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_DATA_GROUPS, status:VALID,
-
SYNONYM: APPS.FND_DATA_GROUP_UNITS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_DATA_GROUP_UNITS, status:VALID,
-
PACKAGE: APPS.PER_RI_CONFIG_MAIN
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIG_MAIN, status:VALID,
-
PACKAGE BODY: APPS.PER_RI_CONFIG_TECH_SUMMARY
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_RI_CONFIG_TECH_SUMMARY, status:VALID,
-
PACKAGE BODY: APPS.PER_RI_CONFIG_TECH_SUMMARY
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_RI_CONFIG_TECH_SUMMARY, status:VALID,
-
PACKAGE: APPS.PER_RI_CONFIGURATION_API
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIGURATION_API, status:VALID,
-
PACKAGE: APPS.PER_RI_CONFIGURATION_API
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PER_RI_CONFIGURATION_API, status:VALID,
-
PACKAGE BODY: APPS.PER_RI_CONFIG_FND_DEF_ENTITY
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_RI_CONFIG_FND_DEF_ENTITY, status:VALID,
-
SYNONYM: APPS.PER_RI_CONFIG_LOCATIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_RI_CONFIG_LOCATIONS, status:VALID,
-
SYNONYM: APPS.PER_RI_CONFIG_LOCATIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PER_RI_CONFIG_LOCATIONS, status:VALID,
-
SYNONYM: APPS.FND_DATA_GROUP_UNITS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_DATA_GROUP_UNITS, status:VALID,
-
PACKAGE BODY: APPS.PER_RI_CONFIG_FND_DEF_ENTITY
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PER_RI_CONFIG_FND_DEF_ENTITY, status:VALID,
-
SYNONYM: APPS.HR_ORG_INFORMATION_TYPES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:HR_ORG_INFORMATION_TYPES, status:VALID,
-
PACKAGE: APPS.FND_FUNCTION_SECURITY
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_FUNCTION_SECURITY, status:VALID,
-
SYNONYM: APPS.HR_ORG_INFORMATION_TYPES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:HR_ORG_INFORMATION_TYPES, status:VALID,
-
PACKAGE BODY: APPS.PER_RI_CONFIG_MAIN
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PER_RI_CONFIG_MAIN, status:VALID,
-
SYNONYM: APPS.HR_ORG_INFO_TYPES_BY_CLASS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:HR_ORG_INFO_TYPES_BY_CLASS, status:VALID,
-
SYNONYM: APPS.FND_MENUS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_MENUS, status:VALID,
-
SYNONYM: APPS.HR_LEGISLATION_INSTALLATIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:HR_LEGISLATION_INSTALLATIONS, status:VALID,
-
SYNONYM: APPS.HR_LEGISLATION_INSTALLATIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:HR_LEGISLATION_INSTALLATIONS, status:VALID,
-
SYNONYM: APPS.PER_SEC_PROFILE_ASSIGNMENTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_SEC_PROFILE_ASSIGNMENTS, status:VALID,