Results for “ce_cp_disc_overdue_v”

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

Overview

CE_CP_DISC_OVERDUE_V is a Cash Management (CE) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is purpose-built as a Oracle Business Intelligence Discoverer (formerly Oracle Discoverer) view that supports Cash Positioning by exposing overdue transaction amounts aggregated by worksheet header and bank account. Within the Cash Positioning workflow, users define worksheets in CE_CP_WORKSHEET_LINES to model expected opening balances, cash inflows, and cash outflows across bank accounts. This view complements that flow by isolating items whose expected settlement dates have already passed but which remain un-cleared, providing a consolidated "overdue" figure per worksheet.

The view is registered as VALID and carries the description "Cash Positioning Discoverer View for Overdue Transactions." It does not store data; it is a UNION ALL of two aggregation branches — one for accounts payable (payments) and one for accounts receivable (receipts) — each summarized by worksheet header and bank account.

Underlying Base Objects

The documented base objects for this view are:

• CE_CP_WORKSHEET_LINES (synonym) — the driving worksheet line definitions, supplying WORKSHEET_HEADER_ID, SOURCE_TYPE, INCLUDE_FLAG, CUT_OFF_DAYS, PAYMENT_METHOD, and RECEIPT_METHOD_ID.
• CE_CP_OPEN_BAL_V (view) — supplies bank account, statement date, and next statement date to determine the current open period.
• CE_AP_FC_PAYMENTS_V (view) — the payable-side source of payment amounts, currency, value dates, and status ('NEGOTIABLE').
• CE_AR_FC_RECEIPTS_V (view) — the receivable-side source of receipt amounts, currency, cash activity date, and status.
• CE_XTR_CASHFLOWS_V (view), ARP_CASHBOOK (package), and FND_GLOBAL (package) — supporting/security and cashflow objects referenced in the wider metadata.

The AP branch joins worksheet lines to open balances and payable transactions, restricting to SOURCE_TYPE = 'APP', INCLUDE_FLAG = 'Y', non-null CUT_OFF_DAYS, and current open statements. Amounts are negated (payments reduce cash) and converted using DECODE on currency versus base amount. The AR branch mirrors this logic with SOURCE_TYPE = 'ARR', including receipts with statuses other than CLEARED or RISK_ELIMINATED. Both branches are summed in the outer query.

Key Columns

• WORKSHEET_HEADER_ID — identifies the Cash Positioning worksheet header to which the overdue amount belongs.
• BANK_ACCOUNT_ID — the internal bank account identifier (from CE_CP_OPEN_BAL_V / transaction sources).
• SUM(AMOUNT) — the aggregated overdue amount, output in the open balance's functional/base currency handling. Payables are returned as negative amounts; receivables as positive amounts, reflecting their cash impact.

The outer SELECT exposes these three columns, so downstream reporting can pivot by worksheet and bank account.

Common Use Cases and Queries

Typical scenarios include reconciling cash positions where expected settlements have slipped past the statement/cut-off window, feeding Discoverer worksheets, and driving cash forecasting exceptions.

• List total overdue amounts per bank account for a worksheet:

SELECT WORKSHEET_HEADER_ID, BANK_ACCOUNT_ID, SUM(AMOUNT)
FROM   APPS.CE_CP_DISC_OVERDUE_V
WHERE  WORKSHEET_HEADER_ID = :p_worksheet_id
GROUP  BY WORKSHEET_HEADER_ID, BANK_ACCOUNT_ID;

• Identify bank accounts with the largest overdue exposure across all worksheets:

SELECT BANK_ACCOUNT_ID, SUM(AMOUNT) OVERDUE
FROM   APPS.CE_CP_DISC_OVERDUE_V
GROUP  BY BANK_ACCOUNT_ID
ORDER  BY OVERDUE;

Because the view embeds SYSDATE and cut-off logic, results are dynamic at query time; no materialization or refresh is required.