DBA Data[Home] [Help] [Dependency Information]

TABLE: CE.CE_FORECAST_ERRORS

Object Details
Object Name: CE_FORECAST_ERRORS
Object Type: TABLE
Owner: CE
FND Design Data: TableCE.CE_FORECAST_ERRORS
Subobject Name:
Status: VALID


The CE_FORECAST_ERRORS table stores information about any errors or warnings that occurred while generating a forecast. Each row contains the forecast template ID, forecast ID, forecast name, error message name, and so forth.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CE_FORECAST_ERRORS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFORECAST_ID
Columns
Name Datatype Length Mandatory Comments
FORECAST_HEADER_ID NUMBER (15) Yes Forecast template header identifier
FORECAST_ID NUMBER (15) Yes Forecast identifier
MESSAGE_NAME VARCHAR2 (30) Yes Error message name used to retrieve message texts
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
FORECAST_ROW_ID NUMBER (15)
Forecast template row identifier
APPLICATION_SHORT_NAME VARCHAR2 (50)
Application short name, CE
FORECAST_RUN_NAME VARCHAR2 (100)
Forecast run name assigned by the user at the time of submission
APPLICATION_ID NUMBER

Application ID, 260
MESSAGE_TEXT VARCHAR2 (2000)
Error message text
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FORECAST_HEADER_ID
,      FORECAST_ID
,      MESSAGE_NAME
,      CREATED_BY
,      CREATION_DATE
,      FORECAST_ROW_ID
,      APPLICATION_SHORT_NAME
,      FORECAST_RUN_NAME
,      APPLICATION_ID
,      MESSAGE_TEXT
FROM CE.CE_FORECAST_ERRORS;

Dependencies

[top of page]

CE.CE_FORECAST_ERRORS does not reference any database object

CE.CE_FORECAST_ERRORS is referenced by following:

SchemaCE
ViewCE_FORECAST_ERRORS#