Results for “tp_txn_currency_code”

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

Overview

PA_FI_AMOUNT_DETAILS is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the amount details information for a forecast item. It is a child of PA_FORECAST_ITEMS and holds the cost, revenue, and transfer price amounts associated with forecast line items, expressed across multiple currency and rate perspectives. In an Oracle Projects implementation, this table underpins forecast cost and revenue reporting, transfer price calculations, and the multi-currency rollups that feed project forecasting and budgeting analytics.

From a dimensional modelling perspective, the foreign key structure — anchored to PA_FORECAST_ITEMS through FORECAST_ITEM_ID — suggests a satellite-leaning classification. The table extends the forecast item entity with descriptive and measured attributes rather than acting as an independent hub or as a link between two business entities, so it is best treated as a dependent detail satellite of the forecast item.

Key Information Stored

The documented schema contains 62 columns. The surrogate business-key candidate is defined by the unique index PA_FI_AMOUNT_DETAILS_U1 on (FORECAST_ITEM_ID, LINE_NUM). The most significant columns include:

• FORECAST_ITEM_ID — foreign key to PA_FORECAST_ITEMS; identifies the parent forecast item.
• LINE_NUM — detail line sequence within the forecast item; together with FORECAST_ITEM_ID forms the unique key.
• ITEM_DATE — date associated with the forecast amount detail line.
• ITEM_UOM and ITEM_QUANTITY — unit of measure and quantity for the forecast detail.
• REVERSED_FLAG, NET_ZERO_FLAG, LINE_NUM_REVERSED — indicate reversal and net-zero handling of forecast amounts.
• TXN_RAW_COST, TXN_BURDENED_COST, TXN_REVENUE, TXN_TRANSFER_PRICE — transaction-currency cost, burdened cost, revenue, and transfer price amounts.
• PROJECT_RAW_COST, PROJECT_BURDENED_COST, PROJECT_REVENUE, PROJECT_TRANSFER_PRICE — amounts converted to project currency.
• PROJFUNC_RAW_COST, PROJFUNC_BURDENED_COST, PROJFUNC_REVENUE, PROJFUNC_TRANSFER_PRICE — amounts in project functional currency.
• EXPFUNC_RAW_COST, EXPFUNC_BURDENED_COST, EXPFUNC_TRANSFER_PRICE — amounts in expenditure functional currency.
• Rate metadata such as PROJECT_COST_RATE_TYPE, PROJECT_COST_EXCHANGE_RATE, PROJFUNC_TP_RATE_TYPE, and related rate date columns.
• Standard WHO/audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, plus REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical reporting scenarios include reconciliation of forecast cost and revenue by currency, transfer price analysis, and audit of reversal or net-zero adjustments. A representative query joins the detail table to its parent:

• SELECT d.FORECAST_ITEM_ID, d.LINE_NUM, d.ITEM_DATE, d.PROJFUNC_RAW_COST, d.PROJFUNC_REVENUE FROM PA_FI_AMOUNT_DETAILS d WHERE d.FORECAST_ITEM_ID = :item_id ORDER BY d.LINE_NUM;
• Aggregation by project currency for forecasting dashboards: GROUP BY d.PROJECT_CURRENCY_CODE using SUM(d.PROJECT_BURDENED_COST) and SUM(d.PROJECT_REVENUE).
• Exception reporting on d.REVERSED_FLAG = 'Y' or d.NET_ZERO_FLAG = 'Y' to trace adjustments back to PA_FORECAST_ITEMS.

Related Objects

• PA_FORECAST_ITEMS — parent table; join on PA_FI_AMOUNT_DETAILS.FORECAST_ITEM_ID = PA_FORECAST_ITEMS.FORECAST_ITEM_ID.
• PA_FORECASTS — header-level forecast context for the items.
• PA_PROJECTS — identifies the owning project for amount rollups.
• PA_PROJECT_TYPES and PA_COST_RATE_SCHEDULES — support rate type and rate date processing.
• GL_DAILY_RATES — source of exchange rates used for currency conversions stored on this table.
• PA_FCST_AMOUNT_DETAILS_V and related Projects views — presentation layers over the base detail table.