Search Results acctd_error_amount

Overview

CE_999_INTERFACE_V is an open interface view owned by the APPS schema in Oracle E-Business Suite, belonging to the Cash Management (CE) product family. Its documented purpose is to serve as a reconciliation open interface view, exposing external or staged reconciliation data to the Cash Management reconciliation engine. In Oracle EBS 12.1.1 and 12.2.2, Cash Management uses SQL*Loader-based open interfaces to import bank statement transactions, reconciliation records, and related data into the CE tables prior to the reconciliation and clearing process. This view acts as a staging interface upon which the import program operates.

A defining characteristic of CE_999_INTERFACE_V is that, as delivered, it is an empty, deliberately disabled shell. Its view text selects from SYS.DUAL with the predicate WHERE 1 = 2, guaranteeing that no rows are ever returned. All projected columns are generated from the DUMMY literal using TO_NUMBER, TO_DATE, and plain DUMMY placeholders. This design pattern is standard for Oracle open interface views: the seeded definition is a non-functional template that the implementing organization is expected to replace or customize for its specific source system.

Underlying Base Objects

The only documented referenced base object is the DUAL table (SYS.DUAL). The view is defined over DUAL with the constraint WHERE 1 = 2, which is the canonical Oracle idiom for a query that returns no data while still exposing a fully typed column list. Because DUAL is a single-row, single-column system utility table, the view inherits no business data from any CE transactional table. In its delivered state, therefore, CE_999_INTERFACE_V is logically disconnected from the bank statement, reconciliation, and clearing tables it is meant to feed.

The ROWID of the underlying DUAL row is exposed as the first SELECT item, aliased to ROW_ID in the column list. This is consistent with the standard interface pattern in which ROW_ID normally references a physical row in the source staging table; here it merely reflects the placeholder DUAL row and carries no reconciliation significance.

Key Columns

The column list maps directly onto the fields the reconciliation engine expects:

• ROW_ID – row identifier, projected from T.ROWID of the base object.
• TRX_ID – the bank statement transaction identifier to be reconciled.
• BANK_ACCOUNT_ID – the internal bank account identifier the transaction relates to.
• TRX_TYPE / TRX_TYPE_DSP – transaction type code and its display value.
• TRX_NUMBER – the transaction (statement line) number.
• TRX_DATE – the transaction date, converted from DUMMY with the YYYY/MM/DD format mask.
• CURRENCY_CODE – the currency of the transaction.
• STATUS / STATUS_DSP – reconciliation status code and display value.
• EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE, EXCHANGE_RATE – currency conversion attributes.
• AMOUNT, CLEARED_AMOUNT, CHARGES_AMOUNT, ERROR_AMOUNT – transaction amounts in entered currency.
• ACCTD_AMOUNT, ACCTD_CLEARED_AMOUNT, ACCTD_CHARGES_AMOUNT, ACCTD_ERROR_AMOUNT – corresponding accounted amounts.
• GL_DATE, CLEARED_DATE – general ledger accounting date and the date the item was cleared.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY – standard audit columns.

The uniform DUMMY projections mean every column is typed (number, date, or character) but unpopulated until the view is customized.

Common Use Cases and Queries

Because the delivered view returns no rows, the primary use case is as a customization template. Implementers copy the definition into a custom view that selects from their own staging table, cast the columns to the required datatypes, and point the Cash Management import process at it. A typical inspection query is:

• SELECT COUNT(*) FROM APPS.CE_999_INTERFACE_V; — confirms the view is empty as delivered (always 0).
• SELECT TRX_ID, BANK_ACCOUNT_ID, TRX_NUMBER, TRX_DATE, AMOUNT FROM APPS.CE_999_INTERFACE_V WHERE TRX_DATE >= SYSDATE - 30; — illustrative shape of a reconciliation extraction once the view has been customized to a real source.
• Querying ALL_VIEWS or DBA_VIEWS for TEXT confirms the DUAL-based shell and guides sustainable redefinition.

In short, CE_999_INTERFACE_V is a placeholder reconciliation interface view that must be implemented before it carries any integration value.