Results for “project_raw_cost”

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

Overview

PA_EXP_ITEMS_RECVR_EFC is a legacy table in the PA (Projects) schema of Oracle E-Business Suite. Per the documented description, it is 11i Only and "Maintains a snapshot of the receiver columns not maintained in the Expenditure Items MRC table before conversion to the Euro." In other words, it existed to preserve receiver-side currency and amount attributes of expenditure items during the period when Oracle supported the Euro conversion transition, and it is superseded in 12.1.1 and 12.2.2, where it is expected to remain structurally VALID but functionally dormant.

The table holds just 9 documented columns, all of which are attributes of an expenditure item. Its scope is extremely narrow and its purpose is archival rather than transactional. The heuristic Data Vault classification supplied in the metadata is standalone, meaning that while the table is physically owned by PA and carries a single foreign key to PA_EXPENDITURE_ITEMS_ALL, its narrow attribute set and limited relationship footprint suggest it is best viewed as neither a true hub nor a link — it is effectively a satellite of expenditure items that was never broadened into the standard EBS Data Vault topology.

Key Information Stored

Only the following columns are documented for this object, and no columns beyond these should be assumed to exist in 12.1.x or 12.2.x:

• EXPENDITURE_ITEM_ID — the primary surrogate key on the table. It is also the only unique business-key candidate, enforced by the unique index PA_EXP_ITEMS_RECVR_EFC_U1.
• SET_OF_BOOKS_ID — the ledger against which the expenditure item was recorded when the snapshot was taken.
• LAST_UPDATE_DATE — the standard EBS audit column indicating when the row was last modified, used for high-watermark extractions.
• PROJECT_CURRENCY_CODE — the project's transaction currency for the item.
• PROJECT_RATE_DATE, PROJECT_RATE_TYPE, and PROJECT_EXCHANGE_RATE — the date, rate type, and rate used to convert the project amount into the functional currency.
• PROJECT_RAW_COST — the raw cost amount in the project currency.
• TP_BASE_AMOUNT — the corresponding base (functional) amount after conversion at the stored project exchange rate.

Collectively, these columns describe a single expenditure item's receiver-side currency and amount context — precisely the fields that were not preserved in the Expenditure Items MRC (multi-currency) table prior to the Euro conversion.

Common Use Cases and Queries

The principal legitimate use case in 12.1.x and 12.2.x is Euro-transition audit and historical reconciliation. Typical runtime reporting against the table is minimal because expenditure processing uses PA_EXPENDITURE_ITEMS_ALL; however, the following query shapes are commonly encountered:

• Retrieving the pre-Euro snapshot for a given item. SELECT expenditure_item_id, set_of_books_id, project_currency_code, project_raw_cost, tp_base_amount FROM pa.pa_exp_items_recvr_efc WHERE expenditure_item_id = :item_id;
• Ledger-level reporting of snapshot rows. SELECT set_of_books_id, COUNT(*), SUM(project_raw_cost) FROM pa.pa_exp_items_recvr_efc GROUP BY set_of_books_id;
• Incremental extractions for a data warehouse using LAST_UPDATE_DATE as the watermark.
• Joining to PA_EXPENDITURE_ITEMS_ALL to compare the snapshot's rates and amounts against the current posted values, which is useful for detecting rounding or rate discrepancies introduced during the Euro revaluation.

Related Objects

• PA_EXPENDITURE_ITEMS_ALL — the single, documented parent table referenced by the foreign key PA_EXP_ITEMS_RECVR_EFC.EXPENDITURE_ITEM_ID → PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID. This is the standard join path for any reconciliation query.
• PA_EXPENDITURE_ITEMS_MRC — the multi-currency companion to expenditure items; the EFC table was created precisely to compensate for receiver columns not held there before the Euro conversion, so it is the natural sibling for comparison.
• PA_EXP_ITEMS_EFC — the analogous Euro-conversion snapshot for standard expenditure item columns, providing the wider context for this narrowed receiver-side table.
• PA_PROJECTS_ALL — supplies project-level context (currency and set of books) referenced indirectly through the expenditure item.
• GL_SETS_OF_BOOKS / GL_LEDGERS — the ledger reference behind SET_OF_BOOKS_ID, required for any ledger-aware reporting.
• FND_CURRENCIES — the validation source for PROJECT_CURRENCY_CODE.

Because the table is documented as 11i Only and standalone from a Data Vault perspective, its role in 12.1.1 and 12.2.2 is best regarded as historical reference data rather than an actively maintained integration point.