Search Results ota_training_plan_costs_efc_pk

Overview

The OTA_TRAINING_PLAN_COSTS_EFC table is a specialized data object within the Oracle E-Business Suite Learning Management (OTA) module. It functions as a temporary, process-specific copy of the core OTA_TRAINING_PLAN_COSTS table. Its sole role is to support the Euro as Functional Currency (EFC) conversion process, a regulatory requirement for organizations operating in the Eurozone. This process involves converting monetary values from a legacy national currency to the Euro. The table is populated by the EFC process to hold converted cost data for training plans during the conversion cycle and is not intended for direct transactional use. As indicated in the metadata, it may not be present in all implementations.

Key Information Stored

The table's structure mirrors its source table, OTA_TRAINING_PLAN_COSTS, and holds the converted cost data for training plan budget lines. The primary key uniquely identifies each record within the context of the EFC process. The key columns are:

• TRAINING_PLAN_COST_ID: The unique identifier for a training plan cost record, serving as the link back to the original source row in the OTA_TRAINING_PLAN_COSTS table.
• EFC_ACTION_ID: A critical column that identifies the specific EFC conversion process run that populated the row. This allows the system to track and manage data across multiple conversion cycles or corrections.

Other columns would include all monetary and descriptive fields from the source table (e.g., cost amounts, currency codes, cost types) but with values updated to reflect the Euro conversion.

Common Use Cases and Queries

Direct interaction with this table is typically limited to audit, reconciliation, and troubleshooting activities related to the EFC process. Common scenarios include verifying the success of a conversion run or comparing pre- and post-conversion values. A typical query would join this table to its source to audit converted amounts for a specific EFC action.

Sample SQL Pattern:
SELECT src.training_plan_cost_id,
src.cost_amount AS original_amount,
efc.cost_amount AS converted_euro_amount,
efc.efc_action_id
FROM ota_training_plan_costs src,
ota_training_plan_costs_efc efc
WHERE src.training_plan_cost_id = efc.training_plan_cost_id
AND efc.efc_action_id = &action_id;

Related Objects

The table has a direct and singular relationship with its source transactional table. The relationship is defined by the primary key constraint OTA_TRAINING_PLAN_COSTS_EFC_PK.

• Primary Source Table: OTA_TRAINING_PLAN_COSTS. The EFC table is populated from and is a child of this core table. The join column is TRAINING_PLAN_COST_ID.
• EFC Process Control: The table is intrinsically linked to the EFC engine and its control mechanisms, as tracked by the EFC_ACTION_ID column. This ID likely references a master process control table within the EFC framework.