Results for “hr_organization_informatio_efc”

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

Overview

The HR_ORGANIZATION_INFORMATIO_EFC table is an archival mirror table within the Oracle E-Business Suite Human Resources (PER) module, owned by the HR schema. It is a structural copy of the base HR_ORGANIZATION_INFORMATION table and serves as the designated target for the EFC (Euro as Functional Currency) process. During the Euro conversion initiative tied to the introduction of EMU currencies across the European Union, Oracle provided a family of "EFC" shadow tables to preserve the pre-conversion values of organization-related records while the primary base tables, such as HR_ORGANIZATION_INFORMATION, were updated to reflect the new functional currency.

Architecturally, the table is narrow — only six documented columns — which reflects its purpose as a change-capture or snapshot object rather than a full transactional repository. In Data Vault terms, the metadata classifies this table as satellite-leaning. This is a reasonable modeling suggestion: the composite primary key formed from the organization information identifier plus the EFC action identifier means each row records the state of an organization-information attribute at a specific EFC action, which is characteristic of a satellite delivering historical context around a hub or link. The EFC action itself operates as a driving link to the EFC_ACTIONS table.

Key Information Stored

The table carries a deliberately compact column set:

• ORG_INFORMATION_ID — The identifier that ties the row back to the corresponding record in the base HR_ORGANIZATION_INFORMATION table. It is part of the composite primary key.
• EFC_ACTION_ID — The foreign key referencing HR_EFC_ACTIONS, identifying which Euro conversion action generated this preserved row. It is also part of the primary key.
• EFC_BG_CURRENCY — The functional or "background" currency associated with the organization information as captured at the time of the EFC process.
• ORG_INFORMATION5, ORG_INFORMATION6, ORG_INFORMATION10 — These numbered slots correspond to the generic, flexfield-style information columns of the parent table. They are the only attribute columns preserved in this EFC copy, indicating they held the currency-sensitive or otherwise conversion-relevant values that the EFC process needed to archive.

The surrogate identity is the pair (ORG_INFORMATION_ID, EFC_ACTION_ID), which is enforced by the unique index HR_ORGANIZATION_INFORMA_EFC_PK. Because ORG_INFORMATION_ID alone is not unique here, it is properly understood as a business-key component rather than a standalone primary key; the same organization information record can appear multiple times, once per EFC action.

Common Use Cases and Queries

Typical usage centers on auditing, reconciliation, and historical reporting following a Euro conversion or similar functional-currency change.

• Retrieve the preserved values for a given organization information record: SELECT ORG_INFORMATION_ID, EFC_ACTION_ID, EFC_BG_CURRENCY, ORG_INFORMATION5, ORG_INFORMATION6, ORG_INFORMATION10 FROM HR.HR_ORGANIZATION_INFORMATIO_EFC WHERE ORG_INFORMATION_ID = :p_id ORDER BY EFC_ACTION_ID;
• Compare archived EFC values against the current base table using a join on ORG_INFORMATION_ID, useful in reconciliation reports after conversion.
• Join to HR_EFC_ACTIONS on EFC_ACTION_ID to attribute preserved rows to a specific conversion action and its date context.
• Reporting scenarios that must reproduce the functional-currency environment in effect before conversion, for statutory or audit evidence.

Related Objects

The most significant dependencies derive from the documented FK and structural mirroring:

• HR_EFC_ACTIONS — Parent of the EFC_ACTION_ID foreign key; each row in the EFC table references exactly one action.
• HR_ORGANIZATION_INFORMATION — The base table this object mirrors; joined on ORG_INFORMATION_ID.
• HR_ORGANIZATION_INFORMA_EFC_PK — The unique index defining the composite key.
• HR_ORGANIZATIONS — The parent organization entity associated through organization information.
• EFC_ACTIONS / EFC_APPLICATION_PHASES — The broader EFC process driver tables that govern when and how this copy is populated.

Because all writes are controlled by the EFC process, this object is effectively read-only for application and reporting users outside of the conversion routines.