Search Results pay_num

Overview

FII_AP_SCH_PAYMTS_FCV is a database view belonging to the FII (Financial Intelligence) product family within Oracle E-Business Suite. In the 12.1.1 and 12.2.2 releases, FII is designated as obsolete; it was a legacy extraction and reporting layer that predated the modern Business Intelligence Applications and Enterprise Command Centers. The view name suffix "FCV" denotes a fact-cum-view construct, indicating that it was designed to feed a dimensional warehouse model rather than serve as a normalized transactional view. Its subject matter is scheduled payments against AP invoices, combining invoice, payment schedule, discount, and currency attributes into a single denormalized projection.

The metadata classifies this object as an internal table with no functional description and records that it was not implemented in every database in which FII was deployed. Its presence therefore depends on whether the FII federated or extracted schema was installed for a given environment, commonly under a dedicated FII or APPS schema. Because the referenced base objects are undocumented in the ETRM metadata, the exact source tables cannot be stated with certainty from the documentation alone; the column list is the authoritative artifact available.

Underlying Base Objects

The ETRM metadata lists no documented base tables or objects for FII_AP_SCH_PAYMTS_FCV. The view text is a flat projection of schedule-payment facts and dimension foreign keys. The naming conventions used across its columns strongly parallel the AP payment schedules and invoice distributions model, with surrogate keys such as INV_FK, SUPPLIER_FK, PAYMENT_TERM_FK, SET_OF_BOOKS_ID, and CHART_OF_ACCOUNTS_ID representing conformed dimensions. The column names INV_EXCHANGE_RATE, INV_EXCHANGE_RATE_TYPE, INV_EXCHANGE_DATE, PAYMENT_EXCHANGE_RATE, and PAYMENT_EXCHANGE_RATE_TYPE derive from the invoice and payment exchange-rate semantics documented in the Oracle Payables data model.

The view text also includes a GL_ACCT1_FK expression built from a GL_SEG column using DECODE and SUBSTR logic, including a special "NA_EDW" marker. This construct is characteristic of FII's GL account derivation for the North American Enterprise Data Warehouse target, and it indicates a supporting GL segment staging source rather than a direct concatenation of the AP accounting flexfield.

Key Columns

The significant columns exposed by this view include:

• INV_EXCHANGE_RATE, INV_EXCHANGE_RATE_TYPE, INV_EXCHANGE_DATE — the invoice-level currency conversion rate, its rate type, and effective date at invoice time.
• PAYMENT_EXCHANGE_RATE, PAYMENT_EXCHANGE_RATE_TYPE, PAYMENT_EXCHANGE_DATE — the corresponding conversion values at payment time.
• GLOBAL_CURRENCY_RATE — the reporting or "global" currency rate applied within the FII model.
• DISC_AMT_LOST_B/G/T, DISC_AMT_TAKEN_B/G/T, POTENTIAL_DISC_AMT_B/G/T — discount amounts in base, global, and transaction currency, covering lost, taken, and potential discounts.
• REMAINING_INV_AMT_B/G/T and REMAINING_INV_AMT_AT_RISK_B/G/T — outstanding invoice amounts and the portion at risk if discount terms lapse.
• SCH_PAYMENT_PK, CASH_RECEIPT_ID — surrogate keys identifying the scheduled payment record within the FII model.
• PAYMENT_STATUS_FLAG, PAYMENT_METHOD, PAYMENT_PRIORITY, HOLD_FLAG — payment processing attributes influencing timing and eligibility.

Common Use Cases and Queries

Because the view was constructed for extraction into a financial warehouse, it supports analytical reporting rather than real-time payables processing. Typical uses include discount-capture analysis, payment-timing and due-date reporting, and currency revaluation trending. Queries should be restricted to columns that exist in the specific FII installation, since the object is not universally implemented.

• Analyzing discount opportunity: selecting INV_FK, DUE_DATE, POTENTIAL_DISC_AMT_G, and DISC_AMT_TAKEN_G to compare available versus realized discounts.
• Currency exposure reporting: comparing INV_EXCHANGE_RATE and PAYMENT_EXCHANGE_RATE for payments executed across different rate regimes.
• Payment obligation trending: aggregating REMAINING_INV_AMT_G by SET_OF_BOOKS_ID and payment terms/status flags.

A representative query is: SELECT sch_payment_pk, inv_fk, inv_exchange_rate, inv_exchange_rate_type, payment_exchange_rate, payment_exchange_rate_type, payment_amt_g, remaining_inv_amt_g, outstanding_disc_amt FROM fii_ap_sch_paymts_fcv WHERE sob_fk = :sob_id ORDER BY due_date; Such queries must be issued against the FII schema where the view is implemented and are not supported in standard Oracle Payables reporting.