Search Results hold_date_fk

Overview

FII_AP_HOLD_DATA_FCV is a collection view associated with the Financial Intelligence (FII) product family in Oracle E-Business Suite, specifically the FII_AP_HOLD_DATA_F fact. The naming convention — the "FCV" suffix and the reference to a "_F" fact object — identifies it as a fact collection view, the abstraction layer through which the Financial Intelligence extract, transform, and load (ETL) process and downstream reporting tools retrieve the hold-related fact records for Accounts Payable. It surfaces supplier payment hold information for use in financial analytics, including holds placed on invoices and payments, the hold reason, and the responsible party.

The view is classified as obsolete within the FII module. It is documented in the ETRM metadata as "Not implemented in this database," meaning it is a legacy object that may not exist on current 12.1.1 or 12.2.2 instances. Customers still querying or integrating with it should verify its presence in their environment, as reliance on a non-implemented object can cause failures in custom reports and interfaces. Its primary relevance today is for historical reference, upgrade assessment, and understanding legacy FII data models.

Underlying Base Objects

The metadata documents no referenced base objects for this view, which is typical for FII fact collection views built over fact tables during the extract phase. Based on the view text, it is derived from the FII_AP_HOLD_DATA_F fact, exposing that fact's identifier columns and foreign keys. The columns SEQ_ID and HOLD_DATA_PK represent the surrogate and primary keys of the fact record, while the remaining columns are foreign keys intended to join to dimension tables within the FII star schema, including INSTANCE_FK, DUNS_FK, GEOGRAPHY_FK, HOLD_BY_EMPLOYEE_FK, HOLD_DATE_FK, HOLD_FK, INV_CURRENCY_FK, INV_FK, and the truncated INV_SO column.

Key Columns

• SEQ_ID and HOLD_DATA_PK — Surrogate sequence identifier and primary key for the hold data record.
• INSTANCE_FK, DUNS_FK, GEOGRAPHY_FK — Foreign keys to instance, supplier (DUNS), and geography dimensions.
• GL_ACCT1_FK through GL_ACCT10_FK — Ten accounting flexfield segments derived by decoding GL_SEG. Each segment is extracted in 25-character blocks, with RTRIM applied and a special-case mapping where 'NA_EDW' values are passed through unchanged. The trailing SUBSTRB(GL_SEG, 251) portion is concatenated to each segment.
• HOLD_BY_EMPLOYEE_FK — Foreign key to the employee who placed the hold.
• HOLD_DATE_FK — Foreign key to the date dimension for the hold event.
• HOLD_FK — Foreign key to the hold reason or hold definition dimension.
• INV_CURRENCY_FK and INV_FK — Foreign keys to the invoice currency and invoice dimensions, respectively.
• INV_SO — A secondary invoice-related attribute, truncated in the excerpt.

Common Use Cases and Queries

The view supports reporting on the volume and cause of holds across suppliers, invoices, and time periods. A key characteristic is that foreign keys such as INV_FK link to the invoice dimension, meaning the "inv_fk" pattern a user might search on resolves to the invoice dimension in the FII star schema. A representative query joins the collection view to a supplier or invoice dimension to summarize holds:

SELECT h.HOLD_DATE_FK, h.HOLD_FK, COUNT(*) FROM FII_AP_HOLD_DATA_FCV h GROUP BY h.HOLD_DATE_FK, h.HOLD_FK;

A second use joins INV_FK to the invoice dimension to list holds by invoice and currency. Because this view is flagged obsolete and not implemented, any production query should be preceded by a check of ALL_VIEWS for its existence, and long-term migrations should target the current FII or Oracle Fusion data model instead.