Search Results ce_ar_fc_invoices_v




Overview
Explore in AI Chat

Overview

CE_AR_FC_INVOICES_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. Its documented description is "Forecasting source - AR invoices," and it serves as a reporting and integration layer that exposes open Accounts Receivable invoice and debit memo balances together with the customer profile class to which each transaction relates. The view is one of the designated data sources consumed by the Cash Management cash forecasting engine when projecting expected cash inflows from receivables.

Functionally, the view presents open transactions on the AR_PAYMENT_SCHEDULES_ALL ledger, filtered so that only transactions with a remaining amount due are surfaced. Because it joins to the customer profile class, forecast results can be segmented or aggregated by profile class, which is a common reporting dimension in EBS. The view therefore acts as a standardization layer: rather than embedding the AR, HZ, and profile-class join logic directly within the forecasting program, the logic is encapsulated in a single validated APPS view.

Underlying Base Objects

Per ETRM 12.2.2 metadata, the view is defined over four referenced base objects:

  • AR_PAYMENT_SCHEDULES_ALL (SYNONYM) — the driving AR transaction and schedule table, supplying transaction number, accounted and entered amounts due remaining, amount in dispute, invoice currency, exchange rate, due date, transaction date, customer identifiers, and organization identifier.
  • HZ_CUSTOMER_PROFILES (SYNONYM) — the customer profile entity, joined either on the customer site use identifier for site-level profiles or on the customer account identifier for account-level profiles (where the site use identifier is null).
  • HZ_CUST_PROFILE_CLASSES (SYNONYM) — the profile class definition table, supplying the profile class identifier and profile class name that are exposed on the view.
  • AR_PUBLIC_UTILS (PACKAGE) — an AR public API package invoked in the view text through the function CHECK_PREPAY_TRANSACTION, which suppresses prepayment transactions from the result set.

The view text is a UNION of two queries. The first resolves profile classes at the site-use level via HZ_CUSTOMER_PROFILES.SITE_USE_ID; the second resolves account-level profile classes where the site use identifier is null. Both branches restrict to payment schedules with STATUS = 'OP' (open), exclude classes of 'PMT' and 'GUAR', and exclude prepayments through the AR_PUBLIC_UTILS call.

Key Columns

Column aliases are derived positionally from the SELECT list. Documented columns include:

Common Use Cases and Queries

Typical scenarios include cash forecast validation, receivables aging by profile class, and reconciliation of expected collections against the Cash Management forecast engine.

Open invoice exposure by profile class:

  • SELECT profile_class, SUM(amount) FROM ce_ar_fc_invoices_v GROUP BY profile_class;

Operating-unit restricted listing:

  • SELECT trx_number, customer_id, amount, currency_code, trx_date FROM ce_ar_fc_invoices_v WHERE org_id = :p_org_id ORDER BY trx_date;

Disputed balances for review:

  • SELECT trx_number, dispute_amount FROM ce_ar_fc_invoices_v WHERE dispute_amount > 0;

Site versus account level profile classes:

  • SELECT reference_id, customer_trx_id, site_use_id, profile_class FROM ce_ar_fc_invoices_v WHERE site_use_id IS NULL;