Results for “hr_dm_exp_hr_org_inf_flx_v”

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

Overview

The view APPS.HR_DM_EXP_HR_ORG_INF_FLX_V is a reporting and integration object belonging to the PER — Human Resources product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to export the HR_ORG_INF_FLX structure, which stores the descriptive flexfield (DFF) segments associated with organization classification information. The view is marked VALID and is owned by the APPS schema, making it a supported read-only interface for extracting organization flexfield data. Users searching for org_information6 arrive here because the view explicitly renames internal staging columns into the familiar ORG_INFORMATION segment names used throughout Oracle HRMS. The view does not itself hold descriptive flexfield logic; instead it surfaces a subset of columns from a data migration/export staging table, presenting flexfield segment values in a normalized, human-readable column layout suitable for extraction, reconciliation, and downstream loading processes.

Underlying Base Objects

According to the documented ETRM metadata, the view is defined over a single referenced base object: HR_DM_EXP_IMPS (accessed through a SYNONYM). The view text confirms this dependency:

• SELECT EXP_IMP_ID, TABLE_NAME, PVAL001 ORG_INFORMATION4, PVAL002 ORG_INFORMATION5, PVAL003 ORG_INFORMATION6, PVAL004 ORG_INFORMATION7, PVAL005 ORG_INFORMATION8, PVAL006 ORG_INFORMATION14 FROM HR_DM_EXP_IMPS WHERE TABLE_NAME = 'HR_ORG_INF_FLX'

The underlying table HR_DM_EXP_IMPS functions as an export/import staging repository, identified by the EXP_IMP_ID key and a TABLE_NAME discriminator. Because the view applies a fixed predicate of TABLE_NAME = 'HR_ORG_INF_FLX', it returns only those staging rows that pertain to the HR_ORG_INF_FLX export set. The generic PVAL001 through PVAL006 columns are positional placeholders in the staging table that are re-labelled into meaningful flexfield segment names by the view definition. Note that the column naming skips ORG_INFORMATION1 through ORG_INFORMATION3, reflecting the subset of segments captured by this particular export interface.

Key Columns

• EXP_IMP_ID — Identifier for the export/import batch that owns the row; used to isolate a specific migration or extraction run.
• TABLE_NAME — Discriminator column; always evaluates to 'HR_ORG_INF_FLX' for this view, confirming the target export set.
• ORG_INFORMATION4 — Derived from PVAL001; the fourth organization information flexfield segment.
• ORG_INFORMATION5 — Derived from PVAL002.
• ORG_INFORMATION6 — Derived from PVAL003. This is the column requested by users searching for org_information6, and it carries the sixth organization information DFF segment value.
• ORG_INFORMATION7 — Derived from PVAL004.
• ORG_INFORMATION8 — Derived from PVAL005.
• ORG_INFORMATION14 — Derived from PVAL006; maps to the fourteenth organization information flexfield segment.

Each mapped column returns the character value stored in the corresponding positional staging column, with no transformation applied beyond renaming.

Common Use Cases and Queries

Typical scenarios include verifying exported organization flexfield data, reconciling migration batches, and extracting segment values such as ORG_INFORMATION6. A representative query restricting to a specific export run is:

• SELECT EXP_IMP_ID, TABLE_NAME, ORG_INFORMATION4, ORG_INFORMATION5, ORG_INFORMATION6, ORG_INFORMATION7, ORG_INFORMATION8, ORG_INFORMATION14 FROM APPS.HR_DM_EXP_HR_ORG_INF_FLX_V WHERE EXP_IMP_ID = :p_exp_imp_id;
• To audit only the requested segment: SELECT EXP_IMP_ID, ORG_INFORMATION6 FROM APPS.HR_DM_EXP_HR_ORG_INF_FLX_V WHERE ORG_INFORMATION6 IS NOT NULL;

Because the view is read-only and derived from a staging synonym, it is best used for extraction and validation rather than transactional updates.