Search Results ce_cp_disc_close_v




Overview
Explore in AI Chat

Overview

CE_CP_DISC_CLOSE_V is a view owned by the APPS schema within the Cash Management (CE) module of Oracle E-Business Suite, and it is documented as VALID in both release 12.1.1 and 12.2.2. The ETRM metadata explicitly classifies this object with the description "No longer Used." This designation is significant: the view remains present and valid in the data dictionary, but Oracle no longer supports it as part of the functional Cash Management reconciliation workflow. It exists largely as a legacy artifact retained for backward compatibility of dependent objects rather than as an actively maintained reporting interface.

Functionally, the view consolidates cash reconciliation discount-related balances at the granularity of a worksheet header and a bank account. It was originally intended to present a computed closing balance by combining opening, prior-period, and net discount components into a single aggregated figure. Because the object is marked as obsolete, its role in current reporting and integration is limited, and Oracle EBS implementations should treat it as deprecated rather than as a supported source for new custom reporting.

Underlying Base Objects

The view text defines CE_CP_DISC_CLOSE_V as a join across three sibling views, each of which is itself part of the Cash Management discount reconciliation family:

The three component balances are summed through NVL-wrapped expressions so that missing outer-joined rows contribute zero rather than null. The documented referenced base objects for CE_CP_DISC_CLOSE_V include these three views together with several APPS packages: ARP_CASHBOOK, FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, and XTR_USER_ACCESS. The presence of the FND and MO packages indicates that security, multi-org, and profile-option logic is inherited from the underlying component views rather than defined directly in this outer join. ARP_CASHBOOK, the Receivables cashbook package, and XTR_USER_ACCESS reflect the cashbook and treasury user-access dimensions that govern which bank accounts a user may reconcile.

Key Columns

The view exposes three documented columns. Each corresponds directly to the projection in the defining query.

  • WORKSHEET_HEADER_ID — Identifier of the Cash Management reconciliation worksheet header. It is the primary join key linking the three component views and determines the reconciliation context for the computed balance.
  • BANK_ACCOUNT_ID — Identifier of the bank account associated with the worksheet. Combined with WORKSHEET_HEADER_ID, it forms the composite key across which the opening, prior, and net balances are correlated.
  • BALANCE — The aggregate discount balance, computed as NVL(OPEN.BALANCE,0) + NVL(PD.BALANCE,0) + NVL(NET.BALANCE,0). It represents the closing discount figure for the given worksheet header and bank account pairing.

Common Use Cases and Queries

Because the view is documented as no longer used, practical adoption is discouraged. Historical or diagnostic scenarios nevertheless include verifying legacy reconciliation outputs, auditing the continued presence of obsolete Cash Management objects, and assessing impact before removal in a custom cleanup. A representative query retrieves closing discount balances for a specific worksheet:

  • SELECT worksheet_header_id, bank_account_id, balance FROM ce_cp_disc_close_v WHERE worksheet_header_id = :p_worksheet_header_id;
  • SELECT bank_account_id, SUM(balance) FROM ce_cp_disc_close_v GROUP BY bank_account_id;

Users searching for "ce_cp_disc_close_v" should note that Oracle recommends the supported Cash Management reconciliation views and APIs for current development. Custom reports should not rely on this deprecated object, and any existing dependency should be reviewed for migration to a supported alternative.