Search Results ce_cp_disc_v




Overview
Explore in AI Chat

Overview

CE_CP_DISC_V is an APPS-owned database view within the Cash Management (CE) product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It is documented as the Cash Positioning Discoverer View, meaning its principal purpose is to serve as a flattened, denormalized data source for Oracle Discoverer worksheets and related reporting tools that present cash positioning information. The view consolidates bank account cash positions by combining worksheet header data, worksheet line transactions, and pre-aggregated balance components such as opening, prior-day, net, target, surplus, and closing balances.

Because it joins multiple subordinate Discoverer views and lookup-driven descriptions, CE_CP_DISC_V delivers a single result set suitable for drill-down cash positioning reports. Users querying the view typically search for descriptive attributes such as SOURCE_DESCRIPTION and TRX_DESCRIPTION, which translate internal lookup codes and worksheet line attributes into human-readable labels for reporting.

Underlying Base Objects

The documented referenced objects include a mix of views, synonyms, and packages. The principal data-bearing objects are CE_CP_DISC_OPEN_V, CE_CP_DISC_PRIOR_V, CE_CP_DISC_NET_V, CE_CP_DISC_TARGET_V, CE_CP_DISC_SURPLUS_V, CE_CP_DISC_CLOSE_V, and CE_CP_DISC_TRX_V, each supplying a distinct cash positioning component via UNION ALL. Worksheet metadata comes from CE_CP_WORKSHEET_HEADERS and CE_CP_WORKSHEET_LINES (accessed through synonyms), and bank account context is sourced from CE_CP_WS_BA_DISC_V. Lookup meanings are resolved through CE_LOOKUPS using the lookup type POSITION_SRC_TYPE.

Supporting packages include ARP_CASHBOOK, FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, and XTR_USER_ACCESS. These provide cashbook validation, multi-org and profile-based security context, and user access filtering, ensuring the view returns only data the querying responsibility is permitted to see.

Key Columns

  • WORKSHEET_HEADER_ID — Identifier of the cash positioning worksheet header; links the row back to CE_CP_WORKSHEET_HEADERS.
  • BANK_ACCOUNT_ID — Bank account associated with the worksheet and position line.
  • WORKSHEET_LINE_ID — Line identifier for transaction-level rows; synthetic values such as -1 are used for aggregate rows (OPEN, PRIOR, NET, CLOSE, TARGET, SURPLUS).
  • SOURCE_TYPE — Classifies the row, for example OPEN, PRIOR, NET, CLOSE, TARGET, SURPLUS, TRX, or IDA, driven by the POSITION_SRC_TYPE lookup.
  • SOURCE_DESCRIPTION — The lookup meaning corresponding to SOURCE_TYPE; for IDA rows the IDA meaning is used, otherwise the TRX meaning. This is the column most commonly searched by report authors.
  • TRX_DESCRIPTION — Descriptive text for transaction lines from CE_CP_WORKSHEET_LINES.DESCRIPTION.
  • BALANCE — Monetary balance for the row, originating from the various CE_CP_DISC_* balance views.
  • DETAIL — Additional transaction detail supplied from the TRX component view.

Common Use Cases and Queries

Typical use cases include cash positioning dashboards, Discoverer workbook data sources, bank account balance reconciliation, and drill-down analysis from summary balance rows to underlying transaction lines.

SELECT worksheet_header_id,
       bank_account_id,
       worksheet_line_id,
       source_type,
       source_description,
       trx_description,
       balance
FROM   apps.ce_cp_disc_v
WHERE  source_description LIKE '%OPEN%';

To isolate transaction-level detail for a specific worksheet:

SELECT worksheet_line_id, source_type, source_description, balance, detail
FROM   apps.ce_cp_disc_v
WHERE  worksheet_header_id = :p_header_id
AND    worksheet_line_id > 0
ORDER BY worksheet_line_id;

Because the view draws on worksheet, lookup, and access-control objects, queries should respect the responsibility and MO security context established by FND_GLOBAL, MO_GLOBAL, and XTR_USER_ACCESS; results outside the user's cashbook and organizational access are filtered accordingly.