Results for “days_in_dispute”

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

Overview

FII_AR_CURR_REC_WH_V is an internal database view delivered as part of the Oracle Financial Intelligence (FII) product family within Oracle E-Business Suite. Based on the documented ETRM metadata, this view belongs to the FII module, which Oracle has classified as Obsolete. Its documented purpose is to support Risk Indicator Portlets, which are dashboard components used in financial intelligence reporting to surface accounts receivable exposure and aging information to collections and credit management users.

The view presents a filtered, denormalized snapshot of open receivables installments. The suffix "_WH" in the view name is consistent with the warehouse-oriented naming conventions used across FII objects, and the "_CURR_REC" segment indicates that the view returns current receivables records. The view exposes one curated row per qualifying open installment, making it suitable for direct consumption by portlet queries rather than by transactional processing. As noted in the metadata, the view is documented as "Not implemented in this database," which indicates that the object is defined in the ETRM registry but was not created in the specific instance catalogued. Administrators should confirm that the FII schema has been fully installed before attempting to reference the view in custom code.

Underlying Base Objects

The documented base object for this view is FII_AR_OPEN_INSTALLMENT_F, a fact-style table in the FII schema that stores open installment-level receivables data used by the Financial Intelligence warehouse. The view text performs a simple projection and filter against that single table, selecting eleven columns and applying three predicates:

• RECEIVABLE_G <> 0 — excludes installments with a zero receivable balance.
• AGE_BUCKET = 1 — restricts output to the first aging bucket, corresponding to current (not-yet-aged) receivables.
• TYPE = 'I' — limits rows to invoice-type records, excluding other transaction types stored in the same table.

Because there are no joins or subqueries in the view definition, performance characteristics are inherited directly from FII_AR_OPEN_INSTALLMENT_F, and any index on the combination of AGE_BUCKET, TYPE, and RECEIVABLE_G is likely to be leveraged by the optimizer.

Key Columns

The view exposes the following columns, most of which are carried through with their original names and one of which is aliased at projection time:

• SOB_ID (source: SET_OF_BOOKS_FK_KEY) — identifies the accounting set of books or ledger associated with the installment.
• ORG_ID (source: OPERATING_UNIT_FK_KEY) — the operating unit owning the receivable, relevant for multi-org security.
• CUSTOMER_ID and CUSTOMER_NAME — the customer identifier and its display name.
• INVOICE_NUMBER and INSTALLMENT_NUMBER — identify the originating transaction and the specific installment line.
• INVOICE_DATE and DUE_DATE — transaction and due dates used for aging analysis.
• DAYS_IN_DISPUTE (source: literal 0) — hard-coded to zero in the view text, since disputed records are not represented in this current-receivables population.
• DISPUTE_FLAG (source: literal 'Y') — hard-coded to 'Y' in the view text; consumers should not rely on this column as a true dispute indicator given the literal assignment.
• DATE_OF_SNAPSHOT — the effective date of the FII snapshot from which the underlying fact row was captured. This column is central for point-in-time reporting and is the field users most commonly search for when investigating this view.
• FUNCTIONAL_CURRENCY and INVOICE_CURRENCY — the ledger functional currency and the transaction currency, enabling currency-aware aggregation.
• TOTAL (source: RECEIVABLE_G) — the outstanding receivable amount for the installment.

Common Use Cases and Queries

The principal use case is supplying current receivables data to Risk Indicator Portlets, which display first-bucket aging exposure by customer, operating unit, or currency. A typical portlet query retrieves the latest snapshot for the current bucket:

SELECT customer_name,
       invoice_number,
       installment_number,
       due_date,
       total,
       invoice_currency,
       date_of_snapshot
  FROM fii_ar_curr_rec_wh_v
 WHERE sob_id = :sob_id
   AND org_id = :org_id
 ORDER BY due_date;

A common analytical variant aggregates the outstanding balance by currency for a given snapshot, which supports exposure monitoring and cash forecasting:

SELECT invoice_currency,
       functional_currency,
       COUNT(*) AS invoice_count,
       SUM(total) AS total_receivable
  FROM fii_ar_curr_rec_wh_v
 WHERE date_of_snapshot = :snapshot_date
 GROUP BY invoice_currency, functional_currency;

Because the view is restricted to AGE_BUCKET = 1 and TYPE = 'I', consumers requiring aged or non-invoice receivables must query FII_AR_OPEN_INSTALLMENT_F directly. Given the Obsolete classification of the FII module, new development should avoid depending on this view, and existing reports should be reviewed for migration to supported Oracle receivables reporting objects.