Results for “payment_amt_b”
36 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:
- ROW_ID — the surrogate identifier. The documented FK from
FII_AP_LIA_B_MV.ROW_IDtoCS_SYSTEMS_ALL_B_TEMPis unusual; treat ROW_ID as the operational key. - ORG_ID — the operating unit, the primary partitioning dimension for multi-org reporting.
- SUPPLIER_ID — the supplier business key candidate; drives supplier-level aggregation.
- TIME_ID — the period or effective-date key linking each snapshot row to a reporting calendar.
- UNPAID_AMT_B / PRIM_UNPAID_AMT / SEC_UNPAID_AMT — total open liability in base, primary, and secondary currencies.
- PAST_DUE_AMT_B and UNPAID_COUNT / DUE_COUNT / PAST_DUE_COUNT — overdue exposure and invoice counts.
- DISCOUNT_OFFERED_B, DISCOUNT_TAKEN_B, DISCOUNT_LOST_B, DISCOUNT_REMAINING_B — discount-capture performance.
- DUE_BUCKET1_B through DUE_BUCKET3_COUNT — current aging buckets with counts.
- PAST_DUE_BUCKET1_B through PAST_DUE_BUCKET3_COUNT — overdue aging buckets.
- ON_TIME_PAYMENT_AMT_B and LATE_PAYMENT_AMT_B — payment-timeliness KPIs.
- WT_OPEN_DUE_AMT_B and related WT_ columns — withholding-tax open balances.
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_BthroughPAST_DUE_BUCKET3_COUNTfor 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
- CS_SYSTEMS_ALL_B_TEMP — referenced by the documented FK on
ROW_ID, providing system/instance context. - AP_SUPPLIERS — join on
SUPPLIER_IDto resolve supplier names and sites. - ORG_ORGANIZATION_DEFINITIONS — join on
ORG_IDfor operating-unit attributes. - AP_INVOICES_ALL / AP_INVOICE_PAYMENTS_ALL — upstream sources whose balances are aggregated into this table.
- FND_CURRENCIES — resolves currency codes for the _B/_PRIM/_SEC measure families.
- GL_PERIODS / FII_TIME — resolves
TIME_IDto accounting periods.
-
View: FII_AP_SCH_PAYMTS_FCV 12.1.1
None. Internal Table.
APPS.FII_AP_SCH_PAYMTS_FCV·↳ EDW_CURRENCY·↳ FIIBV_AP_SCH_PAYMTS_FCV·↳ FII_FLEX_MAPPING·Explore FII module →
-
Table: FII_AP_SCH_PAYMTS_F 12.1.1
AP scheduled payments fact table
-
Interface table for AP invoice payments fact.
-
View: FII_AP_INV_PAYMTS_FCV 12.1.1
Internal view used for warehouse data extraction.
APPS.FII_AP_INV_PAYMTS_FCV·↳ EDW_CURRENCY·↳ FIIBV_AP_INV_PAYMTS_FCV·↳ FII_FLEX_MAPPING·Explore FII module →
-
FIIBV_AP_SCH_PAYMTS_FCV is the base view for FII_AP_SCH_PAYMTS_F fact
APPS.FIIBV_AP_SCH_PAYMTS_FCV·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS_ALL·↳ AP_PAYMENT_SCHEDULES_ALL·Explore FII module →
-
None. Internal Table.
APPS.FIIBV_AP_INV_PAYMTS_FCV·↳ AP_CHECKS_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS_ALL·Explore FII module →
-
Table: FII_AP_INV_PAYMTS_F 12.1.1
AP invoice payments fact table
-
Interface table for AP scheduled payments fact.
-
View: FII_AP_INV_PAYMTS_FCV 12.2.2
Internal view used for warehouse data extraction.
Not implemented in this database·Explore FII module →
-
View: FII_AP_SCH_PAYMTS_FCV 12.2.2
None. Internal Table.
Not implemented in this database·Explore FII module →
-
None. Internal Table.
Not implemented in this database·Explore FII module →
-
FIIBV_AP_SCH_PAYMTS_FCV is the base view for FII_AP_SCH_PAYMTS_F fact
Not implemented in this database·Explore FII module →
-
TABLE: APPS.FII_AP_LIA_B_MV 12.1.1
-
eTRM - FII Tables and Views 12.1.1
This table stores the mapping of leaf nodes from pruned dimension to nodes in the child value sets
-
eTRM - FND Tables and Views 12.1.1
No longer used