Results for “ce_fc_ari_disc_v”

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

Overview

CE_FC_ARI_DISC_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, classified under the Cash Management (CE) product family. The object name indicates its purpose: it is a "Funding Candidate / Accounts Receivable Invoice Discount" view, presenting a consolidated, security-filtered list of open receivable invoices and their associated discount (payment terms) information for use by Cash Management forecasting, funding, and reconciliation processes. The view is validated (Status: VALID) in both 12.1.1 and 12.2.2 and is a UNION ALL of two branches, one drawing from standard Oracle Receivables invoices and the other from Oracle Projects (PA) invoices.

The naming is significant for the user search term pa_ce_invoices_v. CE_FC_ARI_DISC_V does not directly query PA tables — it consumes the pre-built view PA_CE_INVOICES_V, which is the Projects-side extraction of invoice lines destined for Cash Management. This view therefore acts as an aggregator/union layer that presents AR and PA invoice funding data through one consistent, profile-classified interface.

Underlying Base Objects

Per the documented metadata, CE_FC_ARI_DISC_V is defined over the following base objects:

• CE_AR_FC_INVOICES_V (VIEW) — the AR branch source, supplying reference identifier, transaction number, amount, profile class, dispute amount, and org.
• PA_CE_INVOICES_V (VIEW) — the Projects branch source; the view constructs a synthetic reference ID as 'PA' || PROJECT_ID || 'X' || TRX_NUMBER || 'X' || LINE_NUM.
• HR_OPERATING_UNITS (VIEW) — outer-joined to both branches to resolve organization name.
• HZ_CUST_PROFILE_CLASSES (SYNONYM) — joined in the PA branch to translate PROFILE_CLASS_ID into the profile class name.
• CE_SECURITY_PROFILES_V (VIEW) — subquery used to enforce organization-level security by operating unit.
• FND_GLOBAL, FND_PROFILE, FND_ACCESS_CONTROL_UTIL, MO_GLOBAL, AR_PUBLIC_UTILS, XTR_USER_ACCESS (PACKAGES) — supporting API/function calls that enforce multi-org, MOAC, and access-control security within the underlying views.

Key Columns

• REFERENCE_ID — unique per-row identifier; TO_CHAR of the AR reference ID, or the synthetic Projects key for PA rows.
• INVOICE_NUMBER — the transaction/invoice number (TRX_NUMBER).
• TRX_AMOUNT — invoice amount available for funding.
• PROFILE_CLASS — the customer or project profile class used for discount/payment terms classification; sourced directly in AR, resolved via HZ_CUST_PROFILE_CLASSES in PA.
• DISPUTE_AMOUNT — disputed amount on AR invoices; NULL for Projects rows.
• ORGANIZATION — the operating unit name from HR_OPERATING_UNITS.

Common Use Cases and Queries

Typical use cases include: funding-candidate extraction, discount-term analysis across standard and Project invoices, and reconciliation feeds. A representative query is:

• SELECT reference_id, invoice_number, trx_amount, profile_class, dispute_amount, organization FROM apps.ce_fc_ari_disc_v WHERE trx_amount > 0;
• Filtering by profile class: ... WHERE profile_class = :profile_class_name (e.g. 'Standard', 'Project').
• Org-level reporting: join or filter on organization to restrict to a specific operating unit.

The view is read-only for reporting; any update must be performed on the source AR invoices (via AR APIs) or on PA_CE_INVOICES_V's originating Projects transactions. Because security predicates are embedded in the underlying views, users only see organizations their CE Security Profile permits, making the view safe for multi-org deployments.