Search Results ce_po_fc_orders_temp_v




Overview
Explore in AI Chat

Overview

CE_PO_FC_ORDERS_TEMP_V is a Cash Management (CE) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Cash Forecasting (CE_PO_FC) feature family, which supplies cash flow forecasting with committed and anticipated outflows derived from procurement activity. Specifically, this view exposes the temp labor purchase order forecast source: open purchase order commitments for temporary labor engagements, which the Cash Management forecasting engine uses to project near-term cash disbursements.

The view operates as a reporting and integration layer rather than a transactional entity. It contains no data of its own; rather, it joins and reshapes existing purchasing and financials tables from AP (Payables), PO (Purchasing), and GL (General Ledger) into a normalized forecast line format. Because it is a view and not a concurrent program output, values reflect the current state of the underlying purchase orders at query time, making it suitable for ad hoc analysis, custom reports, and feeds into external forecasting or treasury systems.

Underlying Base Objects

The view's definition joins the following documented base objects:

Most joins are outer joins (using the Oracle (+) operator) between header, line, location, distribution, vendor, and vendor site records, with mandatory joins on set of books identifiers linking distributions to both GL_SETS_OF_BOOKS and FINANCIALS_SYSTEM_PARAMS_ALL. This structure ensures that forecast amounts always reconcile to a valid ledger and operating unit.

Key Columns

  • SEGMENT1 — the purchase order number (document reference).
  • Amount (column 2) — the outstanding commitment multiplied by the exchange rate: GREATEST(amount_ordered − amount_delivered − amount_cancelled + nonrecoverable_tax, 0) × NVL(line rate, NVL(header rate, 1)) .
  • Unconverted amount (column 3) — the same open commitment in document currency, floored at zero.
  • START_DATE / EXPIRATION_DATE — PO line dates driving the forecast time bucket.
  • Currency code (column 6) — resolves as header currency, then invoice currency, then ledger currency.
  • AUTHORIZATION_STATUS — PO approval state, defaulting to 'INCOMPLETE'.
  • Payment priority / vendor type / pay group (columns 8–10) — derived from the vendor site if present, else from the vendor, with sentinel defaults ('-1', '99').
  • ORG_ID, PROJECT_ID, LINE_NUM, PO_DISTRIBUTION_ID — organizational, project, and document identifiers for drill-down.
  • VALUE_BASIS, PURCHASE_BASIS, MATCHING_BASIS — purchasing control attributes from line locations.

Common Use Cases and Queries

The primary use is supplying temp labor PO commitments to cash forecasting models and to custom cash outflow reporting. A typical query surfaced by a user searching for this object is:

  • Listing open temp labor commitments by PO for a given operating unit.
  • Aggregating forecast amounts by currency or project for treasury planning.
  • Reconciling CE forecast lines back to PO distributions for audit.

For example: SELECT segment1, amount, currency_code, start_date, expiration_date, org_id FROM apps.ce_po_fc_orders_temp_v WHERE org_id = :p_org_id ORDER BY start_date;

Because the view performs the greatest-of-zero calculation on open amounts, records fully delivered or cancelled naturally return zero and are effectively neutral to the forecast. Analysts should note that the view reflects PO distributions across all suppliers selected by the join criteria, so filtering by org_id and authorization_status is advisable to avoid incomplete or unauthorized documents distorting projected cash flows.