Search Results dep_amount_func

Overview

FII_AR_NET_REC_AGRT_MV_F_V is a reporting view belonging to the FII (Financial Intelligence) product family in Oracle E-Business Suite. It is documented in ETRM as obsolete and is not implemented in the current database, meaning no physical object of this name exists in a standard 12.1.1 or 12.2.2 installation. The view is a wrapper over the materialized view FII_AR_NET_REC_AGRT_MV, exposing the "_F_V" naming convention that typically denotes a "functional currency" view — amounts are therefore expressed in the ledger's functional currency rather than in entered or transaction currency.

The object belongs to the Oracle Daily Business Intelligence / Financial Intelligence Receivables dashboards and is oriented toward net receivables, agreement, and collections analytics. It presents one row per combination of time period, party, customer account, collector, and operating unit, aggregating receivable balances into aging buckets and receipt-based measures. The columns ending in _FUNC carry the functional-currency monetary values, while corresponding non-monetary columns carry counts and duration numbers.

Underlying Base Objects

The view text indicates it is defined over the single materialized view FII_AR_NET_REC_AGRT_MV. No additional base tables are documented as referenced objects in ETRM 12.2.2, which is consistent with the standard DBI pattern in which a lightweight view is layered on top of a pre-aggregated materialized view that is itself populated by a concurrent program during the data warehouse refresh cycle. In practice, the underlying materialized view draws from Receivables transactional tables such as RA_CUSTOMER_TRX_ALL, AR_PAYMENT_SCHEDULES_ALL, AR_CASH_RECEIPTS_ALL, and AR_COLLECTORS; however, those dependencies are not documented in the ETRM metadata provided and should be confirmed against a concrete instance if the object is ever re-created.

Because the object is marked obsolete and not implemented, DBAs should treat any reference to it as either a customization or a legacy artifact carried forward from an earlier FII release.

Key Columns

• Dimensional keys: TIME_ID, PERIOD_TYPE_ID, ORG_ID, PARTY_ID, PARENT_PARTY_ID, CUST_ACCOUNT_ID, and COLLECTOR_ID identify the reporting grain.
• DM_AMOUNT_FUNC: the functional-currency amount of debit memos, the specific column named in the user's search. It is one of a family of transactional-type amount measures (INV_AMOUNT_FUNC for invoices, CB_AMOUNT_FUNC for chargebacks, BR_AMOUNT_FUNC for adjustments, DEP_AMOUNT_FUNC for deposits, REV_AMOUNT_FUNC for reversals).
• Aging buckets: CURRENT_BUCKET_1..3_AMOUNT_FUNC and PAST_DUE_BUCKET_1..7_AMOUNT_FUNC, each paired with a _COUNT column for transaction counts.
• Open balance measures: CURRENT_OPEN_AMOUNT_FUNC, PAST_DUE_OPEN_AMOUNT_FUNC, TOTAL_OPEN_AMOUNT_FUNC with matching counts.
• Receipt measures: TOTAL_RECEIPT_AMOUNT_FUNC, APP_AMOUNT_FUNC, ON_ACCOUNT_CREDIT_AMOUNT_FUNC, PREPAYMENT_AMOUNT_FUNC, and CLAIM_AMOUNT_FUNC.
• Discount measures: EARNED_DISCOUNT_AMOUNT_FUNC and UNEARNED_DISCOUNT_AMOUNT_FUNC.
• Duration metrics: AVG_DD_NUM_FUNC, WTD_DAYS_PAID_NUM_FUNC, WTD_TERMS_PAID_NUM_FUNC, and the DSO-family columns WTD_DDSO_DUE_NUM_FUNC.

Common Use Cases and Queries

The view is intended for receivables aging dashboards, collector performance reporting, and collections KPI extracts. Because the object is obsolete, queries should be validated before deployment. Representative SQL:

• Aging snapshot by customer for a period: SELECT CUST_ACCOUNT_ID, SUM(TOTAL_OPEN_AMOUNT_FUNC), SUM(PAST_DUE_OPEN_AMOUNT_FUNC) FROM FII_AR_NET_REC_AGRT_MV_F_V WHERE TIME_ID = :p_time AND ORG_ID = :p_org GROUP BY CUST_ACCOUNT_ID;
• Debit memo contribution to open receivables: SELECT TIME_ID, SUM(DM_AMOUNT_FUNC) FROM FII_AR_NET_REC_AGRT_MV_F_V GROUP BY TIME_ID;
• Collector efficiency extract: SELECT COLLECTOR_ID, SUM(TOTAL_RECEIPT_AMOUNT_FUNC), SUM(APP_AMOUNT_FUNC) FROM FII_AR_NET_REC_AGRT_MV_F_V GROUP BY COLLECTOR_ID;

Where the view is absent, equivalent reporting is generally achieved through the underlying materialized view FII_AR_NET_REC_AGRT_MV or through Oracle Transactional Business Intelligence (OTBI) subject areas for Receivables.