Search Results ce_cp_disc_surplus_v




Overview
Explore in AI Chat

Overview

CE_CP_DISC_SURPLUS_V is a view owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It belongs to the Cash Management (CE) product family and is documented in the ETRM repository with the status VALID. The view is explicitly described in Oracle's documentation as "No Longer Used," which is the single most important fact for any implementer or developer who encounters it. Its historical purpose is evident from its name and definition: it computes the difference between an actual bank account balance and a target balance recorded during a cash positioning or cash forecasting exercise. This is characteristic of the discontinued Cash Positioning functionality in Oracle Cash Management, and the view should be treated as a legacy, read-only artifact retained only to preserve object dependencies within the APPS schema.

Underlying Base Objects

The view text reveals a simple two-source join. It selects from CE_CP_DISC_CLOSE_V, aliased CLOSE, and CE_CP_DISC_TARGET_V, aliased TARGET, joining on BANK_ACCOUNT_ID with an outer join applied to the target side, so that every closed balance row is returned even when no target balance exists.

SELECT CLOSE.WORKSHEET_HEADER_ID,
       CLOSE.BANK_ACCOUNT_ID,
       NVL(CLOSE.BALANCE, 0) - NVL(TARGET.TARGET_BALANCE, 0)
FROM   CE_CP_DISC_CLOSE_V CLOSE,
       CE_CP_DISC_TARGET_V TARGET
WHERE  CLOSE.BANK_ACCOUNT_ID = TARGET.BANK_ACCOUNT_ID(+)

Both parent views belong to the same discontinued cash positioning group. The documented metadata also lists ARP_CASHBOOK, FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, and XTR_USER_ACCESS as referenced objects. These are almost certainly inherited through the two child views, which apply Multi-Org and security predicates for bank account access. The dependency on these packages means the view remains sensitive to security profile and MO initialization state in any session that queries it.

Key Columns

  • WORKSHEET_HEADER_ID — Identifier of the cash positioning worksheet to which the closed balance belongs. Sourced from CE_CP_DISC_CLOSE_V.
  • BANK_ACCOUNT_ID — The internal bank account identifier used to join closed balances to target balances.
  • BALANCE — Although the column heading matches the CLOSE.BALANCE column, the projected value is the arithmetic difference NVL(CLOSE.BALANCE,0) - NVL(TARGET.TARGET_BALANCE,0), i.e., the surplus or deficit against target.

Note that the column name OVERLOADs the source column name; the value exposed is not the raw balance. Both NVL guards treat a missing balance as zero, so a row is never returned with a NULL in the BALANCE column.

Common Use Cases and Queries

Because Oracle states the view is no longer used, no supported application code or standard report should depend on it. Practical uses are limited to historical research, migration audits, and identification of orphaned customizations. A representative query is:

SELECT w.WORKSHEET_HEADER_ID,
       w.BANK_ACCOUNT_ID,
       w.BALANCE AS SURPLUS_OR_DEFICIT
FROM   APPS.CE_CP_DISC_SURPLUS_V w
ORDER  BY w.WORKSHEET_HEADER_ID, w.BANK_ACCOUNT_ID;

To isolate accounts where the surplus is positive, apply a WHERE clause on the BALANCE alias. Before running any query, confirm whether worksheet header data still exists, since the child views may return no rows once cash positioning tables have been purged. Organizations upgrading from 12.1.1 to 12.2.2 should inventory references to this view in custom reports, OAF pages, and concurrent programs, and replace them with supported Cash Management balance inquiries. Retaining queries against a view marked "No Longer Used" risks incorrect outputs and unsupported behavior, particularly where the underlying Multi-Org and access-control packages have changed.