Results for “ce_cp_disc_arr_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CE_CP_DISC_ARR_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, residing in the Cash Management (CE) product. Its ETRM description identifies it as the Cash Positioning Discoverer View for AR Receipts. It exists to support the Cash Positioning workflow, where treasury users build daily cash positions by grouping bank account activity into worksheet headers and lines. The view presents the subset of Oracle Receivables receipt activity that is eligible for inclusion on a cash positioning worksheet line, joining receipt data to the worksheet line definition and to the bank account. Because it is a Discoverer-oriented view, it is intended primarily for ad hoc reporting and workbook integration rather than for transactional data entry; no DML is permitted against it. In 12.1.1 and 12.2.2 the object is reported as VALID in the APPS schema, and its definition is delivered as Oracle proprietary, confidential information under the standard Oracle legal notices.

Underlying Base Objects

The view is defined over three principal sources, with one additional package referenced in the metadata. CE_AR_FC_RECEIPTS_V supplies the receivable receipt rows, including receipt number, currency, amounts, cash activity date, receipt method, bank account, and clearing status. CE_CP_WORKSHEET_LINES, accessed via a synonym, provides the worksheet line context — WORKSHEET_LINE_ID, WORKSHEET_HEADER_ID, DESCRIPTION, SOURCE_TYPE, INCLUDE_FLAG, CLEARED_TRX_FLAG, and RECEIPT_METHOD_ID. CE_CP_XTR_BANK_ACCOUNTS_V supplies the bank account currency code used in the balance calculation. The Receivables cashbook package, ARP_CASHBOOK, is documented as a referenced base object, reflecting the dependency of the underlying Receivables receipt view on cashbook logic such as receipt status and cash activity date derivation.

Key Columns

• WORKSHEET_HEADER_ID — Identifier of the cash positioning worksheet header to which the line belongs.
• WORKSHEET_LINE_ID — Identifier of the individual worksheet line; the primary linkage between the position worksheet and the receipt row.
• BANK_ACCOUNT_ID — Internal identifier of the bank account associated with the receipt, matched to the extraction bank account view.
• DESCRIPTION — Descriptive text carried on the worksheet line.
• RECEIPT_NUMBER — The Oracle Receivables receipt number, used for drill-down and reconciliation.
• BALANCE — The receipt amount used in the position. It is derived with a DECODE: when the receipt currency equals the bank account currency, AR.AMOUNT is returned; otherwise AR.BASE_AMOUNT is used, providing functional-currency comparison across accounts.
• REFERENCE_ID — Reference identifier from the receipt, typically the Receivables customer or transaction reference.
• DETAIL — Detail attribute listed in the documented column set.

Common Use Cases and Queries

The view is most commonly used to validate which receipts will appear on a cash positioning worksheet and why others are excluded. The definition enforces several filters: the receipt cash activity date must equal TRUNC(SYSDATE); the line SOURCE_TYPE must be 'ARR' with INCLUDE_FLAG = 'Y'; the receipt must either be flagged as cleared on the line or not have a status of 'CLEARED' or 'RISK_ELIMINATED'; the receipt method must either be unspecified on the line or match exactly; and the receipt bank account must exist in the extraction bank account view.

A typical query lists today's included receipts by worksheet:

• SELECT worksheet_header_id, worksheet_line_id, receipt_number, bank_account_id, balance FROM ce_cp_disc_arr_v WHERE worksheet_header_id = :p_header_id;
• SELECT bank_account_id, SUM(balance) FROM ce_cp_disc_arr_v GROUP BY bank_account_id;
• SELECT receipt_number, balance, description FROM ce_cp_disc_arr_v WHERE reference_id = :p_reference_id;

Typical reports include daily cash position extracts by bank account, reconciliation of worksheet balances to Receivables receipts, and drill-down from a Discoverer workbook line to the originating receipt number.