Results for “due_bucket3_count”

6 results




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

Overview

The object FII_AP_LIA_B_MV is a table registered in the APPS schema under the FND — Application Object Library product family within Oracle E-Business Suite 12.1.1 and 12.2.2. Despite its _B_MV suffix, the ETRM metadata classifies it as a TABLE object with a documented physical schema of 66 columns. The name pattern indicates it functions as a materialized-view-backed or staging table holding pre-aggregated Accounts Payable liability analytics — commonly aligned with the Oracle Payables "Liability Analysis" or supplier payment-performance reporting. It stores period-keyed supplier obligation metrics across unpaid balances, discount activity, aging buckets, and payment-timeliness categories.

From a Data Vault modeling perspective, the heuristic classification is standalone — no parent hub or link dependencies beyond a single FK reference. This suggests the table behaves as a self-contained analytical satellite keyed by a surrogate and derived business grain rather than participating in a normalized hub-and-link constellation.

Key Information Stored

The 66 documented columns capture overlapping payable liability measures in three parallel currency forms (base, primary, and secondary). The most consequential columns include:

No unique index or explicit primary-key constraint is documented beyond the ROW_ID surrogate, so business keys should be inferred as ORG_ID + SUPPLIER_ID + TIME_ID.

Common Use Cases and Queries

Typical usage centers on Supplier Scorecard, cash-forecasting, discount-capture analytics, and aging dashboards. A representative query returning outstanding liabilities per supplier for a given period:

  • SELECT supplier_id, SUM(unpaid_amt_b), SUM(past_due_amt_b) FROM fii_ap_lia_b_mv WHERE org_id = :org AND time_id = :period GROUP BY supplier_id;
  • Discount leakage detection: SELECT supplier_id, SUM(discount_lost_b)/SUM(discount_offered_b) FROM fii_ap_lia_b_mv GROUP BY supplier_id;
  • Aging-bucket exposure: aggregate DUE_BUCKET1_B through PAST_DUE_BUCKET3_COUNT for CFO-tier reporting.
  • Withholding-tax reconciliations using the WT_OPEN_* columns.

Because the table is consumed by BI Publisher or OBIEE extracts, joins to supplier and org dimensions rather than transactional AP tables are the norm.

Related Objects