Search Results ap_chrg_allocations_all_efc

Overview

AP_CHRG_ALLOCATIONS_ALL_EFC is a Payables (AP) module table in the Oracle E-Business Suite, owned by the AP schema and marked VALID in the ETRM 12.2.2 reference. In Oracle EBS naming conventions, the "_EFC" suffix denotes an "Error and Functionality Correction" table. These objects are populated during the upgrade or installation process and are used exclusively by Oracle's internal pre-installation, post-installation, and data-migration scripts. The table functions as a staging or correction workspace that carries forward values from earlier releases and reconciles them with the current data model before the corresponding production table is finalized.

Within the single-source-of-truth application model, AP_CHRG_ALLOCATIONS_ALL_EFC is not referenced by standard Payables forms, concurrent programs, or public APIs at runtime. It sits alongside the base table AP_CHRG_ALLOCATIONS_ALL, which stores the definitive charge allocation records. The EFC table preserves the migrated or pre-processed version of the data. The heuristic Data Vault classification mined from the FK structure is "standalone," suggesting the table can be modeled as an isolated structure rather than participating in a hub or link relationship. A modeling suggestion would be to treat it as an operational staging satellite whose lifecycle is bounded by the upgrade or installation run, independent of the durable business entities.

Key Information Stored

The documented physical schema exposes three columns in ETRM 12.2.2. The table is deliberately narrow, and the metadata does not document any unique index beyond the primary key. The most significant columns are:

• CHARGE_ALLOCATION_ID — The surrogate primary key inherited from the base table AP_CHRG_ALLOCATIONS_ALL, carried into the EFC table to preserve row identity and support the foreign key.
• SET_OF_BOOKS_ID — The ledger (set of books) identifier that segments the allocation record. This is the primary business-key candidate that would typically appear in a composite unique index.
• ALLOCATED_BASE_AMOUNT — The monetary amount allocated to the base, held in the functional (ledger) currency. This is the principal financial datum preserved for migration comparison.

The foreign key relationship AP_CHRG_ALLOCATIONS_ALL_EFC.CHARGE_ALLOCATION_ID references AP_CHRG_ALLOCATIONS_ALL, confirming the parent-child lineage from the EFC table to the production table. No additional columns such as creation date, created-by, or last-update fields are documented in the ETRM extract.

Common Use Cases and Queries

The practical value of this table is concentrated in troubleshooting and verification during upgrade or patch operations. A DBA investigating a failed upgrade that stalled on charge allocation data can compare the EFC rows against the production table to identify records that did not migrate cleanly. A representative query lists the EFC contents for reconciliation:

• SELECT charge_allocation_id, set_of_books_id, allocated_base_amount FROM ap.ap_chrg_allocations_all_efc ORDER BY charge_allocation_id;
• To detect orphaned rows, join against the base table: SELECT e.charge_allocation_id FROM ap.ap_chrg_allocations_all_efc e LEFT JOIN ap.ap_chrg_allocations_all a ON a.charge_allocation_id = e.charge_allocation_id WHERE a.charge_allocation_id IS NULL;
• To verify amount preservation across the migration, compare the sum of allocated_base_amount in both tables grouped by set_of_books_id.

These patterns are diagnostic rather than reporting-oriented. Standard Payables reporting should read from AP_CHRG_ALLOCATIONS_ALL, not from the EFC table.

Related Objects

The following objects are the most significant in the lineage and support the EFC table:

• AP_CHRG_ALLOCATIONS_ALL — The base production table and the referenced key holder for charge_allocation_id.
• AP_CHRG_ALLOCATIONS_ALL_EFC (related EFC) — Sibling correction tables when present in other sub-modules.
• AP_INVOICES_ALL — The invoice header that generates charge allocation lines.
• AP_INVOICE_LINES_ALL — The invoice distribution lines tied to allocations.
• GL_SETS_OF_BOOKS / FND_SET_OF_BOOKS — Source of the set_of_books_id ledger reference.
• AP_UPGRADE schema scripts — Oracle-supplied upgrade programs that populate and consume the EFC table.

Because the table is standalone in the Data Vault sense, no further hub or link relationships are implied by the metadata.