Search Results inv_date_fk




Overview
Explore in AI Chat

Overview

FII_AP_INV_ON_HOLD_FCV is a collection view owned by the APPS schema within the FII (Financial Intelligence) product family of Oracle E-Business Suite, applicable to releases 12.1.1 and 12.2.2. It serves as the staging and collection layer for the FII_AP_INV_ON_HOLD_F fact table, which is part of the Financial Intelligence extract, transform, and load (ETL) architecture used to populate the Oracle Business Intelligence / Financial Intelligence data warehouse. In this role, the view presents invoice-on-hold transactional data drawn from Payables source tables, denormalized and conformed for downstream fact loading.

The view exposes surrogate foreign keys to conformed dimensions (employee, supplier, geography, inventory organization, payment term, set of books, currency, date, and GL account) alongside degenerate identifiers and additive measures. In practice, FII_AP_INV_ON_HOLD_FCV is read by FII ETL programs to populate the fact, and may be queried directly for diagnostics in custom reports where the pre-aggregated FII tables are not required.

Underlying Base Objects

The documented ETRM metadata records no referenced base objects for this view. Conceptually, the view is defined over the Payables invoice interface, hold, and invoice-line source structures (such as AP_INVOICES_ALL, AP_HOLDS_ALL, and AP_PAYMENT_TERMS) together with FII reference tables used to resolve the dimension surrogate keys exposed in the projection. The presence of columns such as INV_ON_HOLD_PK, INV_FK, SUPPLIER_FK, and PAYMENT_TERM_FK indicates the view is a join of transactional Payables data with FII dimension mappings. Because no definitive base object list is documented in ETRM, the exact join graph should be verified by inspecting ALL_VIEWS.TEXT or DBMS_METADATA.GET_DDL for the specific patch level.

Key Columns

Common Use Cases and Queries

Typical uses include validating the ETL load into FII_AP_INV_ON_HOLD_F, analyzing holds by payment term, and joining to FII dimensions for reporting.

  • List invoices on hold with their payment term key and amount:
    SELECT INV_NUM, SUPPLIER_FK, PAYMENT_TERM_FK, INV_TYPE, INV_AMT_ON_HOLD_B, INV_ON_HOLD_COUNT FROM APPS.FII_AP_INV_ON_HOLD_FCV WHERE INV_ON_HOLD_COUNT > 0;
  • Reconcile totals by set of books and currency:
    SELECT SOB_FK, SET_OF_BOOKS_ID, INV_CURRENCY_FK, SUM(INV_AMT_ON_HOLD_G) FROM APPS.FII_AP_INV_ON_HOLD_FCV GROUP BY SOB_FK, SET_OF_BOOKS_ID, INV_CURRENCY_FK;
  • Identify rows to review for missing dimension mappings (for example, NULL PAYMENT_TERM_FK) prior to fact load.

Because the view is an ETL-facing object, direct updates are not supported; all corrective action should target the underlying Payables or FII reference data.