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

TABLE: CE.CE_HEADER_INTERFACE_ERRORS

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


The CE_HEADER_INTERFACE_ERRORS table stores information about errors that occurred while importing bank statements. Each row includes the statement number, bank account number, and error message name for retrieving the actual error messages. A record is written to this table for each error while running the Bank Statement Import program.
You can review the errors on the Bank Statement Interface form or on the AutoReconciliation Execution report.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CE_HEADER_INTERFACE_ERRORS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSTATEMENT_NUMBER
ColumnBANK_ACCOUNT_NUM
Columns
Name Datatype Length Mandatory Comments
STATEMENT_NUMBER VARCHAR2 (50) Yes Statement number
BANK_ACCOUNT_NUM VARCHAR2 (30) Yes Bank account number
MESSAGE_NAME VARCHAR2 (30) 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
Query Text

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


SELECT STATEMENT_NUMBER
,      BANK_ACCOUNT_NUM
,      MESSAGE_NAME
,      CREATION_DATE
,      CREATED_BY
,      APPLICATION_SHORT_NAME
FROM CE.CE_HEADER_INTERFACE_ERRORS;

Dependencies

[top of page]

CE.CE_HEADER_INTERFACE_ERRORS does not reference any database object

CE.CE_HEADER_INTERFACE_ERRORS is referenced by following:

SchemaAPPS
SynonymCE_HEADER_INTERFACE_ERRORS