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

TABLE: CE.CE_RECONCILIATION_ERRORS

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


The CE_RECONCILIATION_ERRORS table stores information about errors that occurred while reconciling a bank statement. Each row includes the statement line identifier and error message name for retrieving the actual error messages. A record is written to this table for each error while running the AutoReconciliation program.
You can review the errors on the Bank Statements form or on the AutoReconciliation Execution report.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CE_RECONCILIATION_ERRORS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATEMENT_LINE_ID
CE_RECONCILIATION_ERRORS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATEMENT_HEADER_ID
CE_RECONCILIATION_ERRORS_N3 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNVL("STATEMENT_LINE_ID",999999)
Columns
Name Datatype Length Mandatory Comments
STATEMENT_LINE_ID NUMBER (15)
Statement line identifier
MESSAGE_NAME VARCHAR2 (500) Yes Message name
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER (15) Yes Standard WHO column
APPLICATION_SHORT_NAME VARCHAR2 (50)
Application short name, CE
STATEMENT_HEADER_ID NUMBER (15) Yes Statement header identifier
Query Text

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


SELECT STATEMENT_LINE_ID
,      MESSAGE_NAME
,      CREATION_DATE
,      CREATED_BY
,      APPLICATION_SHORT_NAME
,      STATEMENT_HEADER_ID
FROM CE.CE_RECONCILIATION_ERRORS;

Dependencies

[top of page]

CE.CE_RECONCILIATION_ERRORS does not reference any database object

CE.CE_RECONCILIATION_ERRORS is referenced by following:

SchemaAPPS
SynonymCE_RECONCILIATION_ERRORS