View: CE_RX_AGING_BUCKETS_V | Oracle EBS ETRM Search

Table that holds the forecast id's of the new forecasts processed in one run of the concurrent program that populates the fact table. It is truncated before each run.

BIL.BIL_BI_NEW_FST_ID·Explore BIL module →

Table: AS_MRP_FCT_REPORT 12.2.2 standalone

owner OSM·AS - Sales Foundation·25 columns

OSM.AS_MRP_FCT_REPORT·Explore AS module →

View: CEFV_CASH_FORECASTS 12.1.1

CE - Cash Management·26 columns

Business View

APPS.CEFV_CASH_FORECASTS·↳ CE_FORECASTS·↳ CE_FORECAST_HEADERS·↳ CE_LOOKUPS·Explore CE module →

View: AS_SALES_FORECAST_UWQ_V 12.2.2

AS - Sales Foundation·10 columns

This view is used for Universal Work Queue

APPS.AS_SALES_FORECAST_UWQ_V·↳ AS_INTERNAL_FORECASTS·↳ JTF_RS_RESOURCE_EXTNS·Explore AS module →

View: CE_FC_AMTS_DISC_V 12.2.2

CE - Cash Management·29 columns

APPS.CE_FC_AMTS_DISC_V·↳ CE_BANK_ACCOUNTS·↳ CE_FORECASTS·↳ CE_FORECAST_COLUMNS·Explore CE module →

Table: AS_FORECASTS 12.1.1 standalone

owner OSM·AS - Sales Foundation·58 columns

Holds revenue and quota credit forecasts

OSM.AS_FORECASTS·Explore AS module →

View: CE_RX_AGING_BUCKETS_V 12.2.2

CE - Cash Management·5 columns

- Retrofitted

APPS.CE_RX_AGING_BUCKETS_V·↳ CE_FORECASTS·↳ CE_FORECAST_COLUMNS·↳ CE_FORECAST_HEADERS·Explore CE module →

Table: FC_FCST_HDR 12.1.1 hub-leaning

owner GMP·GMP - Process Manufacturing Process Planning·15 columns

Forecast header

GMP.FC_FCST_HDR·Explore GMP module →

Table: OZF_FORECAST_PERIODS 12.2.2 link

owner OZF·OZF - Trade Management·15 columns

Stores the different periods the forecast is spread

OZF.OZF_FORECAST_PERIODS·Explore OZF module →

Table: CE_FORECAST_OPENING_BAL 12.2.2 satellite-leaning

owner CE·CE - Cash Management·14 columns

This table stores the opening bank balance or GL cash account balance for a particular Start Date pertaining to a set of forecast results

CE.CE_FORECAST_OPENING_BAL·Explore CE module →

Table: CE_FORECAST_OPENING_BAL 12.1.1 satellite-leaning

owner CE·CE - Cash Management·14 columns

This table stores the opening bank balance or GL cash account balance for a particular Start Date pertaining to a set of forecast results

CE.CE_FORECAST_OPENING_BAL·Explore CE module →

Table: FC_FCST_DTL 12.2.2 link

owner GMP·GMP - Process Manufacturing Process Planning·14 columns

Forecast detail

GMP.FC_FCST_DTL·Explore GMP module →

View: CE_FORECAST_ERRORS_V 12.1.1

CE - Cash Management·9 columns

- Retrofitted

APPS.CE_FORECAST_ERRORS_V·↳ CE_FORECAST_ERRORS·↳ CE_FORECAST_ROWS·Explore CE module →

Table: AMS_MISC_COST_DIS_ALL_B 12.1.1 satellite-leaning

owner AMS·AMS - Marketing·42 columns

Table for storing various costs for Customer.

AMS.AMS_MISC_COST_DIS_ALL_B·Explore AMS module →

Table: AS_FORECAST_WORKSHEETS 12.2.2 hub-leaning

owner OSM·AS - Sales Foundation·49 columns

This will store header information for the opportunity and product category worksheet.

OSM.AS_FORECAST_WORKSHEETS·Explore AS module →

Table: OZF_FORECAST_PERIODS 12.1.1 link

owner OZF·OZF - Trade Management·15 columns

Stores the different periods the forecast is spread

OZF.OZF_FORECAST_PERIODS·Explore OZF module →

Table: OZF_ACT_FORECASTS_ALL 12.1.1 link

owner OZF·OZF - Trade Management·64 columns

This table stores the Forecasts planned for a Marketing Activity.

OZF.OZF_ACT_FORECASTS_ALL·Explore OZF module →

Table: AMS_ACT_FORECASTS_ALL 12.2.2 satellite-leaning

owner AMS·AMS - Marketing·63 columns

This table stores the Forecasts planned for a Marketing Activity.

AMS.AMS_ACT_FORECASTS_ALL·Explore AMS module →

Table: PS_SCHD_FOR 12.2.2 link

owner GMP·GMP - Process Manufacturing Process Planning·10 columns

Schedule forecast association.

GMP.PS_SCHD_FOR·Explore GMP module →

Table: CE_FORECAST_ERRORS 12.2.2 link

owner CE·CE - Cash Management·10 columns

Forecast run errors

CE.CE_FORECAST_ERRORS·Explore CE module →

Table: CE_FORECAST_ERRORS 12.1.1 link

owner CE·CE - Cash Management·10 columns

Forecast run errors

CE.CE_FORECAST_ERRORS·Explore CE module →

Table: PS_SCHD_FOR 12.1.1 link

owner GMP·GMP - Process Manufacturing Process Planning·10 columns

Schedule forecast association.

GMP.PS_SCHD_FOR·Explore GMP module →

Table: CE_FORECAST_CELLS 12.2.2 link

owner CE·CE - Cash Management·11 columns

Forecast amounts

CE.CE_FORECAST_CELLS·Explore CE module →

View: CEBV_CASH_FORECAST_CELLS 12.2.2

CE - Cash Management·52 columns

Business View

APPS.CEBV_CASH_FORECAST_CELLS·↳ AR_LOOKUPS·↳ AR_RECEIPT_METHODS·↳ CE_BANK_ACCOUNTS·Explore CE module →

Table: CE_FORECAST_TRX_CELLS 12.2.2 link

owner CE·CE - Cash Management·19 columns

This table stores transaction level forecast data

CE.CE_FORECAST_TRX_CELLS·Explore CE module →

Table: CE_FORECAST_TRX_CELLS 12.1.1 link

owner CE·CE - Cash Management·19 columns

This table stores transaction level forecast data

CE.CE_FORECAST_TRX_CELLS·Explore CE module →

Table: OZF_FORECAST_DIMENTIONS 12.1.1 link

owner OZF·OZF - Trade Management·19 columns

Stores all the dimentions defined for an object.

OZF.OZF_FORECAST_DIMENTIONS·Explore OZF module →

View: CEBV_CASH_FORECAST_CELLS 12.1.1

CE - Cash Management·52 columns

Business View

APPS.CEBV_CASH_FORECAST_CELLS·↳ AR_LOOKUPS·↳ AR_RECEIPT_METHODS·↳ CE_BANK_ACCOUNTS·Explore CE module →

Table: EAM_FORECAST_CEBBA 12.2.2

owner EAM·EAM - Enterprise Asset Management·26 columns

This table stores all of the costs associated with a forecasted work order for eAM maintenance budgeting and forecasting. This mirrors the structure of cst_eam_balance_by_accounts.

EAM.EAM_FORECAST_CEBBA·Explore EAM module →

View: CEBV_CASH_FORECASTS 12.1.1

CE - Cash Management·26 columns

Business View

APPS.CEBV_CASH_FORECASTS·↳ CE_FORECASTS·↳ CE_FORECAST_HEADERS·↳ CE_LOOKUPS·Explore CE module →

Table: BIL_BI_PROCESSED_FST_ID 12.1.1 standalone

owner BIL·BIL - Sales Intelligence·21 columns

Table that stores all processed forecasts. It is cummulative for all runs of the concurrent program tat populates the fact table.

BIL.BIL_BI_PROCESSED_FST_ID·Explore BIL module →

Table: AS_PROD_WORKSHEET_LINES 12.2.2 link

owner OSM·AS - Sales Foundation·64 columns

Table to store the forecast information on all possible product categories for individual or sales group