Results for “ce_fc_api_disc_v”

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

Overview

CE_FC_API_DISC_V is a Cash Management (CE) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name designates it as a "Forecast API Discrepancy" view, and within the ETRM (E-Business Suite Technical Reference Manual) repository it is classified as a supporting dictionary object for Cash Management forecasting and reconciliation reporting. The view presents an aggregated, negatively-signed list of payable invoice amounts drawn from two distinct forecast sources: standard payables invoices and project-related invoices. By unioning both sources, the view gives application programmers and integration developers a single queryable interface for identifying invoice-based cash outflow commitments.

The negative sign applied to the amount columns is significant. In a cash forecast context, invoices represent outgoing cash, so amounts are expressed as negative values to align with a convention where positive values denote inflows. This sign convention allows the view to be consumed directly by cash forecasting engines, APIs, and custom reconciliation reports without further transformation. The view also applies organization-level security filtering, ensuring that a user only sees invoice data for operating units to which they have access.

Underlying Base Objects

The documented view text defines CE_FC_API_DISC_V as a UNION ALL between two source views, each joined to HR_OPERATING_UNITS:

• CE_AP_FC_DUE_INVOICES_V — the payables forecast source, contributing open and due invoices from the payables subledger.
• CE_DUE_PROJECT_INV_V — the project invoice source, contributing invoice commitments originating from Oracle Projects.
• HR_OPERATING_UNITS — joined via ORGANIZATION_ID to resolve the operating unit name exposed as the ORGANIZATION column.
• CE_SECURITY_PROFILES_V — referenced in the EXISTS subquery that enforces operating unit security (ORGANIZATION_TYPE = 'OPERATING_UNIT').

The documented metadata also lists package-level dependencies including AP_UTILITIES_PKG, FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, and XTR_USER_ACCESS, reflecting the security and multi-org machinery inherited through the underlying views. These are the standard EBS multi-org and access control APIs used to resolve the current operating unit context and enforce data segregation.

Key Columns

• REFERENCE_ID — the source invoice identifier, cast to character via TO_CHAR.
• INVOICE_NUMBER — the invoice number as displayed in Payables or Projects.
• TRX_AMOUNT — the negatively-signed invoice amount derived from SRC.AMOUNT.
• PAYMENT_PRIORITY — priority value used by payment processing and forecasting to order disbursements.
• VENDOR_TYPE — classification of the vendor associated with the invoice.
• PAYGROUP — the payment group assigned to the invoice, used for payment run selection.
• ON_HOLD — decoded to 'YES' or 'NO' from the underlying ON_HOLD flag, indicating whether payment is blocked.
• ORGANIZATION — the operating unit name from HR_OPERATING_UNITS.

Common Use Cases and Queries

Typical uses include reconciling forecasted outflows, verifying which invoices are held from payment, and reconciling Cash Management forecast figures back to Payables and Projects. A basic query retrieving all forecast discrepancies for the current organization is:

SELECT reference_id,
       invoice_number,
       trx_amount,
       payment_priority,
       vendor_type,
       paygroup,
       on_hold,
       organization
FROM   apps.ce_fc_api_disc_v
WHERE  on_hold = 'YES';

To summarize net forecasted outflow by operating unit:

SELECT organization,
       SUM(trx_amount) forecast_outflow
FROM   apps.ce_fc_api_disc_v
GROUP  BY organization;

Because the view already enforces organization security through CE_SECURITY_PROFILES_V, these queries automatically return only rows for operating units the session user is authorized to access, making the view suitable for use in concurrent programs, OAF pages, and custom forecast dashboards.