Search Results ce_so_fc_orders_no_terms_v




Overview
Explore in AI Chat

Overview

CE_SO_FC_ORDERS_NO_TERMS_V is a Cash Management (CE) forecasting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a forecasting source for sales orders, presenting open order line commitments that carry no payment terms at either the line or header level. The view is one of the standard feeds used by the Cash Management forecasting engine to project anticipated cash inflows from order bookings that have not yet been invoiced.

Because the view filters out records where PAYMENT_TERM_ID exists on the order line or header, it isolates orders whose collection timing cannot be derived from standard terms and must therefore be resolved by other forecasting logic. The view exposes open, booked sales order activity with an amount, a base amount, order and request dates, conversion data, and commitment identifiers, making it suitable for direct reporting or as a source for Cash Management's forecast generation concurrent programs.

Underlying Base Objects

The view is defined over four referenced base objects, each accessed through APPS synonyms:

Joins link lines to headers on HEADER_ID, resolve the applicable customer profile class from site or account records, and restrict results to open orders with uninvoiced or partially invoiced lines.

Key Columns

  • ORG_ID — operating unit that owns the order.
  • CURRENCY_CODE — transactional currency of the order.
  • AMOUNT and BASE_AMOUNT — the forecasted order value, computed per line as ordered quantity less invoiced quantity, multiplied by unit selling price, plus tax value where remaining quantity is non-zero. The value is multiplied by 1 for ORDER lines, -1 for RETURN lines, and 0 otherwise.
  • DATE_ORDERED — TRUNC of the header ORDERED_DATE, defaulting to SYSDATE.
  • DATE_REQUESTED — TRUNC of the line REQUEST_DATE, falling back to the header REQUEST_DATE, then SYSDATE.
  • BOOKED_FLAG — indicates whether the order is booked.
  • CONVERSION_TYPE_CODE, CONVERSION_DATE, CONVERSION_RATE — currency conversion attributes used for base amount calculation.
  • COMMITMENT_ID, PROJECT_ID — linkage to commitments and projects where applicable.
  • PROFILE_CLASS_ID and the associated profile class name — customer classification for forecasting rules.
  • ORDER_TYPE_ID, ORDER_NUMBER, LINE_NUMBER, LINE_FLOW_ (flow status) — order identification and status attributes.

Common Use Cases and Queries

Typical scenarios include identifying open order exposure without payment terms, validating forecast inputs before running Cash Management forecast generation, and reconciling forecasted sales order inflows by operating unit or currency. A representative query groups forecasted values by organization and currency:

  • SELECT org_id, currency_code, SUM(amount) forecast_amount, SUM(base_amount) base_forecast FROM ce_so_fc_orders_no_terms_v GROUP BY org_id, currency_code;
  • SELECT order_number, line_number, date_ordered, date_requested, amount FROM ce_so_fc_orders_no_terms_v WHERE org_id = :org_id AND date_requested BETWEEN :start_date AND :end_date;
  • SELECT profile_class_id, COUNT(*) line_count, SUM(amount) total_amount FROM ce_so_fc_orders_no_terms_v GROUP BY profile_class_id;

Because the view reads directly from OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL, results reflect the current transactional state and are not materialized.