Results for “hr_dm_exp_org_info_v”

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

Overview

APPS.HR_DM_EXP_ORG_INFO_V is a data-migration and export view owned by the APPS schema and classified under the PER (Human Resources) product family. Its stated purpose is to export rows from HR_ORGANIZATION_INFORMATION, the flexible key-flex attribute table that stores organization-level information such as legal employer, reporting establishment, tax identifiers, and other descriptive flexfield-driven context values. The view is part of Oracle's Data Migration (DM) export framework, which stages table data into a generic key-value staging structure and then reconstitutes it through a column-mapped projection. Because it surfaces every ORG_INFORMATION1 through ORG_INFORMATION20 column by explicit name, it is particularly relevant to users who search for a specific flexfield column, such as ORG_INFORMATION20, which is exposed here as a first-class column rather than as a raw positional value.

Underlying Base Objects

The view is defined over a single documented base object, HR_DM_EXP_IMPS, referenced through a synonym in the APPS schema. All column values are derived by projecting the generic staging columns PVAL001 through PVAL053 onto named columns, and the view is filtered by the predicate WHERE TABLE_NAME = 'HR_ORGANIZATION_INFORMATION'. This means only rows staged for the HR organization information export are returned. The staging table therefore acts as the single source of truth for the view, and no direct join to HR_ORGANIZATION_INFORMATION is performed within the view text itself. The mapping of PVAL columns to target columns follows a fixed ordinal sequence, so changes to the staging layout would break the positional assignment.

Key Columns

• EXP_IMP_ID and TABLE_NAME — identify the export/import batch and the logical source table; TABLE_NAME is effectively constant (HR_ORGANIZATION_INFORMATION).
• ORG_INFORMATION_ID (PVAL001), ORG_INFORMATION_CONTEXT (PVAL002), and ORGANIZATION_ID (PVAL003) — the primary identifying trio for each organization information row. ORG_INFORMATION_CONTEXT determines which flexfield segments are populated.
• ORG_INFORMATION1 through ORG_INFORMATION20 (PVAL004–PVAL023, in a non-sequential order) — the twenty descriptive flexfield segment values, including ORG_INFORMATION20 at PVAL016.
• Concurrent program audit columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — trace the export job that produced each row.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — standard DFF attribute columns for the base table.
• WHO columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE — lifecycle audit information.

Common Use Cases and Queries

Typical uses include validating that flexfield segment values (notably ORG_INFORMATION20) migrated correctly, reconciling export batches against live data, and extracting organization information for downstream reporting without querying the key-flex table directly.

Locate a specific organization's segment twenty:

SELECT ORGANIZATION_ID, ORG_INFORMATION_CONTEXT, ORG_INFORMATION20
FROM APPS.HR_DM_EXP_ORG_INFO_V
WHERE ORGANIZATION_ID = :p_org_id;

Inventory all staged rows for a given export batch:

SELECT EXP_IMP_ID, ORG_INFORMATION_ID, ORG_INFORMATION_CONTEXT, ORG_INFORMATION1
FROM APPS.HR_DM_EXP_ORG_INFO_V
WHERE EXP_IMP_ID = :p_exp_imp_id;

Compare legacy and target values by context, filtering to rows where segment twenty is populated:

SELECT ORGANIZATION_ID, ORG_INFORMATION_CONTEXT, ORG_INFORMATION20, LAST_UPDATE_DATE
FROM APPS.HR_DM_EXP_ORG_INFO_V
WHERE ORG_INFORMATION20 IS NOT NULL
ORDER BY ORGANIZATION_ID;

Because the view is a thin projection over staging data, its accuracy depends on the completeness of the governing export process; rows absent from HR_DM_EXP_IMPS will not appear, and users requiring live data should query HR_ORGANIZATION_INFORMATION directly.