Results for “hr_org_inf_flx”

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 an Oracle E-Business Suite internal database object owned by the APPS schema. It is registered under the FND Design Data identifier PER.HR_DM_EXP_HR_ORG_INF_FLX_V and carries a status of VALID in both Oracle EBS 12.1.1 and 12.2.2. The object is explicitly annotated within the ETRM repository as "Oracle Internal Use Only," which signals that Oracle Corporation does not support direct access to application data through this view except from standard Oracle Applications programs. Its role is therefore that of a supporting data-migration and data-extraction component rather than a published, customer-facing reporting interface.

Functionally, the view exposes a structured projection of organization-information flexfield (DDF) attribute values held against an import or export staging identifier. The name embeds the tokens "DM" (data migration), "EXP" (export or extraction), "HR_ORG_INF_FLX," indicating that the rows are drawn from the HR organization information flexfield structures used by Oracle HRMS. It presents a narrow, denormalized slice of Organization Information flexfield segments — specifically segments 4, 5, 6, 7, 8, and 14 — together with the owning import context and the source table name.

Underlying Base Objects

According to the documented dependency information, APPS.HR_DM_EXP_HR_ORG_INF_FLX_V references the base object HR_DM_EXP_IMPS, which is present as a synonym. This base table supplies the EXP_IMP_ID column, described in the metadata as a foreign key to hr_dm_exp_imps, and the TABLE_NAME column. The org information flexfield columns (ORG_INFORMATION4 through ORG_INFORMATION8 and ORG_INFORMATION14) are documented as columns originating from the hr_org_inf_flx structures, which store the descriptive flexfield context and attribute values for organization classification.

The view is referenced by two internal APPS programs: HR_DM_AOL_UP and HR_DM_COPY. These dependencies confirm that the view participates in the HR data-migration load and copy operations, where organization flexfield values must be staged, transported, and reapplied consistently across environments or business groups. A PUBLIC synonym, HR_DM_EXP_HR_ORG_INF_FLX_V, is also documented, allowing internal code to reference the object without schema qualification.

Key Columns

• EXP_IMP_ID (NUMBER(15)) — Foreign key linking each row to the corresponding import/export batch record in hr_dm_exp_imps. This is the primary correlation key for a migration run.
• TABLE_NAME (VARCHAR2(30)) — Identifies the source table or entity from which the flexfield values were extracted, enabling generic processing by the consuming migration programs.
• ORG_INFORMATION4 (VARCHAR2(2000)) — Organization Information flexfield segment 4 value.
• ORG_INFORMATION5 (VARCHAR2(2000)) — Organization Information flexfield segment 5 value.
• ORG_INFORMATION6 (VARCHAR2(2000)) — Organization Information flexfield segment 6 value.
• ORG_INFORMATION7 (VARCHAR2(2000)) — Organization Information flexfield segment 7 value.
• ORG_INFORMATION8 (VARCHAR2(2000)) — Organization Information flexfield segment 8 value.
• ORG_INFORMATION14 (VARCHAR2(2000)) — Organization Information flexfield segment 14 value.

Common Use Cases and Queries

Because the object is designated internal, its supported use is within Oracle data-migration and copy utilities. Typical scenarios include auditing which organization flexfield attributes have been staged for a given import batch, verifying segment-level completeness before an upload, and reconciling exported values against the target organization definition. The following query retrieves the staged flexfield values for a specific import identifier:

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 profile the distribution of extracted rows by source table across all batches:

SELECT TABLE_NAME, COUNT(*) AS ROW_COUNT
FROM   APPS.HR_DM_EXP_HR_ORG_INF_FLX_V
GROUP  BY TABLE_NAME
ORDER  BY ROW_COUNT DESC;

Given the internal-use designation, any direct query should be confined to diagnostic or troubleshooting activity, and production integrations should rely on Oracle-supported APIs rather than this view.