[Home] [Help] [Dependency Information]
Object Name: | CE_HEADER_INTERFACE_ERRORS |
---|---|
Object Type: | TABLE |
Owner: | CE |
FND Design Data: | CE.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.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CE_HEADER_INTERFACE_ERRORS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
STATEMENT_NUMBER
BANK_ACCOUNT_NUM |
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 |
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;
CE.CE_HEADER_INTERFACE_ERRORS does not reference any database object
CE.CE_HEADER_INTERFACE_ERRORS is referenced by following:
|
|
|