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

TABLE: CE.CE_LINE_INTERFACE_ERRORS

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


The CE_LINE_INTERFACE_ERRORS table stores information about errors that occurred while importing bank statement lines. Each row includes statement number, statement line 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_LINE_INTERFACE_ERRORS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSTATEMENT_NUMBER
ColumnBANK_ACCOUNT_NUM
ColumnLINE_NUMBER
Columns
Name Datatype Length Mandatory Comments
STATEMENT_NUMBER VARCHAR2 (50) Yes Statement number
BANK_ACCOUNT_NUM VARCHAR2 (30) Yes Bank account number
LINE_NUMBER NUMBER (15) Yes Statement line 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
,      LINE_NUMBER
,      MESSAGE_NAME
,      CREATION_DATE
,      CREATED_BY
,      APPLICATION_SHORT_NAME
FROM CE.CE_LINE_INTERFACE_ERRORS;

Dependencies

[top of page]

CE.CE_LINE_INTERFACE_ERRORS does not reference any database object

CE.CE_LINE_INTERFACE_ERRORS is referenced by following:

SchemaCE
ViewCE_LINE_INTERFACE_ERRORS#