Results for “second_discount_date”

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

Overview

CE_AP_FC_DISC_INVOICES_V is a Cash Management (CE) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is documented in ETRM as a "Forecasting source - AP invoices with discounts." Its purpose is to expose Payables invoices together with their payment schedules and the discount information attached to those schedules, so the Cash Management cash forecasting engine can project future cash outflows at the point in time when a discount is still available to be taken.

Unlike transactional views that support data entry, this object is read-only and exists specifically to feed forecasting logic. Each row represents a payment schedule installment whose discount terms are still in effect, and the view derives several business-relevant amounts (payment amount, base-currency amount, and discount dates) from the underlying Payables tables. The view therefore bridges the Payables and Cash Management modules without duplicating the invoice data physically.

Underlying Base Objects

The documented base objects are AP_INVOICES_ALL, AP_PAYMENT_SCHEDULES_ALL, AP_SYSTEM_PARAMETERS_ALL (all accessed via synonyms), the AP_UTILITIES_PKG package, the FND_GLOBAL package, HZ_PARTIES, HZ_PARTY_SITES, and the PO_VENDORS and PO_VENDOR_SITES_ALL views. The central relationship is the join between AP_INVOICES_ALL (invoice header information such as invoice type, amount paid, and exchange rate) and AP_PAYMENT_SCHEDULES_ALL (installment-level detail including amount remaining, due date, and the three tiers of discount amount and discount date). AP_SYSTEM_PARAMETERS_ALL supplies base-currency and rounding context. AP_UTILITIES_PKG.AP_ROUND_CURRENCY is invoked to round monetary values consistently to the base currency. FND_GLOBAL provides the runtime environment (for example, the current user and responsibility). The HZ and PO_VENDORS objects supply supplier and supplier-site descriptions used in forecast reporting.

Key Columns

• INVOICE_ID – Identifier linking the row back to the AP invoice header.
• PAYMENT_NUM – The payment schedule installment number.
• DUE_DATE – The scheduled due date for the installment.
• AMOUNT (first discount tier) – For non-prepayment invoices, AMOUNT_REMAINING less DISCOUNT_AMOUNT_AVAILABLE; prepayments are handled with a DECODE that negates AMOUNT_PAID.
• BASE_CURRENCY_AMOUNT – The discounted amount converted using the invoice exchange rate and rounded to the base currency via AP_UTILITIES_PKG.AP_ROUND_CURRENCY.
• DISCOUNT_DATE (first tier) – NVL(APS.DISCOUNT_DATE, DUE_DATE), i.e. the discount date falls back to the due date when no discount date exists.
• SECOND_DISC_AMT_AVAILABLE / SECOND_DISCOUNT_DATE – The second-tier discount amount and its date, with the same DUE_DATE fallback. This is the column family most relevant to the "second_discount_date" search term.
• THIRD_DISC_AMT_AVAILABLE / THIRD_DISCOUNT_DATE – The third-tier discount amount and date, again defaulting to DUE_DATE.
• EXCHANGE_RATE – The invoice exchange rate applied during currency conversion.
• INVOICE_TYPE_LOOKUP_CODE – Distinguishes PREPAYMENT rows, which are treated with special sign logic.

Common Use Cases and Queries

The primary use case is Cash Management cash forecasting, where the view supplies the discounted invoice amounts and their associated discount dates so payables outflows can be timed accurately. Analysts also query it to identify invoices whose second discount date is approaching, to reconcile forecast figures against general ledger balances, or to audit how discount tiers were applied to specific suppliers.

A typical query selecting the second discount tier is:

• SELECT invoice_id, payment_num, due_date, second_discount_date FROM ce_ap_fc_disc_invoices_v WHERE second_discount_date >= SYSDATE ORDER BY second_discount_date;
• SELECT invoice_id, second_discount_date, base_currency_amount FROM ce_ap_fc_disc_invoices_v WHERE invoice_id = :invoice_id;
• SELECT COUNT(*), TRUNC(second_discount_date) FROM ce_ap_fc_disc_invoices_v GROUP BY TRUNC(second_discount_date);

Because discount dates default to DUE_DATE when unpopulated, consumers must account for that fallback when interpreting results.