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

TABLE: CE.CE_SQLLDR_ERRORS

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


The CE_SQLLDR_ERRORS table stores the errors that occurred while loading bank statements. Each row includes the bank account, statement number and record number for retrieving actual error messages. A record is written to this table for each error that occurred while running the Load Bank Statement program. This table is populated and deleted whenever the loading program is executed.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
STATEMENT_NUMBER VARCHAR2 (50)
Bank Statement Number
BANK_ACCOUNT_NUM VARCHAR2 (30)
Bank Account Number
REC_NO NUMBER

Record Number. If it's general message this column contain 0. Otherwise, it's a record specific message.
MESSAGE_TEXT VARCHAR2 (2000) Yes Message Text
STATUS VARCHAR2 (30) Yes Message Severity. 'E' for Error and 'W' or Warning.
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

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


SELECT STATEMENT_NUMBER
,      BANK_ACCOUNT_NUM
,      REC_NO
,      MESSAGE_TEXT
,      STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM CE.CE_SQLLDR_ERRORS;

Dependencies

[top of page]

CE.CE_SQLLDR_ERRORS does not reference any database object

CE.CE_SQLLDR_ERRORS is referenced by following:

SchemaCE
ViewCE_SQLLDR_ERRORS#