Search Results ben_bnft_prvdd_ldgr_f_efc

Overview

The BEN_BNFT_PRVDD_LDGR_F_EFC table is a specialized data object within the Oracle E-Business Suite Advanced Benefits (BEN) module, specifically for versions 12.1.1 and 12.2.2. It functions as a temporary, process-specific copy of the core benefits ledger table, BEN_BNFT_PRVDD_LDGR_F. Its primary role is to support the Euro as Functional Currency (EFC) process, a critical financial conversion mechanism for organizations operating under the Euro currency regime. The table is populated exclusively by the EFC process to hold converted monetary data, ensuring the integrity of the original transactional records while facilitating accurate financial reporting in Euros.

Key Information Stored

The table stores a duplicate of the benefit-provided ledger information with currency conversions applied. Its structure is defined by a composite primary key that uniquely identifies each processed record. The key columns are BNFT_PRVDD_LDGR_ID, which identifies the original ledger entry; EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, which define the validity period of the record; and EFC_ACTION_ID, which links the record to a specific run of the EFC conversion process. While the full column list mirrors the base table, the data within this table specifically represents the Euro-converted values for monetary columns, such as contribution or payment amounts, as calculated during the EFC process execution.

Common Use Cases and Queries

The primary use case is auditing and reporting on the results of the Euro as Functional Currency conversion process. Database administrators and functional consultants query this table to verify conversion accuracy, reconcile amounts, and troubleshoot the EFC process. A typical query involves joining to the base ledger table to compare original and converted values.

• Verifying EFC Process Runs: SELECT DISTINCT EFC_ACTION_ID FROM BEN.BEN_BNFT_PRVDD_LDGR_F_EFC;
• Comparing Original and Converted Amounts: SELECT base.LEDGER_ITEM_UNIT_VAL, efc.LEDGER_ITEM_UNIT_VAL FROM BEN_BNFT_PRVDD_LDGR_F base, BEN_BNFT_PRVDD_LDGR_F_EFC efc WHERE base.BNFT_PRVDD_LDGR_ID = efc.BNFT_PRVDD_LDGR_ID AND efc.EFC_ACTION_ID = &action_id;

Related Objects

This table has a direct and foundational relationship with the core benefits ledger table from which it is derived. The documented primary key relationship defines the join condition.

• BEN_BNFT_PRVDD_LDGR_F (Base Table): This is the source table. Records are joined using the composite key columns: BNFT_PRVDD_LDGR_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. The EFC_ACTION_ID in the EFC table links to the specific conversion action.
• EFC Process (Program): The table is intrinsically linked to the internal EFC conversion engine, which is responsible for its population and management. The EFC_ACTION_ID column is a foreign key to the process's control structures.