Analytics Catalog/Subject areas
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · OTBI × BICC

OTBI subject areas — PVO usage matrix

Every Oracle Fusion OTBI subject area mapped to its physical tables and the count of BICC PVOs that extract them — three lenses on one source. 221 subject areas across Financials and SCM/Procurement. Open any row to drill into its tables, columns, and the reports built on it.

Coverage by module

Subject areas, the BICC PVOs that extract them, the physical tables behind them, and the conformed stars we model. Module names link to the data model.

ModuleSubject areasBICC PVOsTablesStars
Cash Management59461
Fixed Assets819422
Fusion Accounting Hub281161
General Ledger417242
Intercompany14201
Other1076—
Payables11191244
Projects231342431
Receivables15601454
Other1511200965—

Cash Management / 5 subject areas

Subject areaTablesPVOs
Cash Management - Bank Statement Balances Real Time147
Cash Management - Bank Statement Line Charges Real Time146
Cash Management - External Cash Transactions Real Time276
Cash Management - Bank Statements Real Time145
Innovation Management - Product Proposals Cash Flow Real Time210

Fixed Assets / 8 subject areas

Subject areaTablesPVOs
Fixed Assets - Asset Transactions Real Time2613
Fixed Assets - Asset Assignments Real Time1412
Fixed Assets - Asset Financial Information Real Time2012
Fixed Assets - Asset Retirements and Reinstatements Real Time2212
Fixed Assets - Asset Transfer Real Time1511
Fixed Assets - Asset Balances Real Time1510
Fixed Assets - Asset Depreciation Real Time2110
Fixed Assets - Asset Source Lines Real Time147

Fusion Accounting Hub / 2 subject areas

Subject areaTablesPVOs
Subledger Accounting - Journals Real Time1154
Subledger Accounting - Supporting References Real Time132

General Ledger / 4 subject areas

Subject areaTablesPVOs
General Ledger - Journals Real Time2215
General Ledger - Balances Real Time79
General Ledger - Transactional Balances Real Time119
General Ledger - Period Status Real Time108

Intercompany / 1 subject areas

Subject areaTablesPVOs
Financials Common Module - Intercompany Transactions Real Time204

Other / 1 subject areas

Subject areaTablesPVOs
Budgetary Control - Transactions Real Time760

Payables / 11 subject areas

Subject areaTablesPVOs
Payables Invoices - Holds Real Time6817
Payables Invoices - Prepayment Applications Real Time8817
Payables Invoices - Transactions Real Time8917
Payables Invoices - Installments Real Time4515
Payables Invoices - Trial Balance Real Time4515
Payables Payments - Disbursements Real Time5913
Payables Payments - Payment History Real Time4413
Payables Invoices - Withholding Real Time1512
Subledger Accounting - Payables Summary Reconciliation Real Time1810
Expenses - Employee Expense Overview Real Time298
Expenses - Expense Transactions Real Time428

Projects / 23 subject areas

Subject areaTablesPVOs
Project Costing - Actual Costs Real Time11463
Project Costing - Commitments Real Time7763
Projects - Grants Management - Award Funding Real Time8962
Project Control - Budgets Real Time9061
Project Costing - Unprocessed Transactions Real Time8861
Project Billing - Invoices Real Time9260
Project Billing - Revenue Real Time9860
Projects - Cross Subject Area Analysis - Real Time6850
Projects - Grants Management - Award Analysis Real Time3650
Project Costing - Assets Real Time5349
Project Costing - Expenditure Item Performance - Real Time7149
Project Resource Management - Resource Management Real Time3949
Project Management - Project Hierarchy Real Time3147
Project Control - Forecasts Real Time6145
Project Management - Planning Real Time3245
Project Billing - Funding Real Time5142
Project Control - Progress Real Time3742
Project Management - Project Resources Real Time3041
Project Management - Task Management Real Time2838
Project Management - Project Work Items Real Time3937
Project Management - Requirements Real Time2237
Project Management - Change Management Real Time2430
Project Management - Opportunity Integration Real Time1825

Receivables / 15 subject areas

Subject areaTablesPVOs
Receivables - Transactions Real Time7847
Receivables - Adjustments Real Time5742
Receivables - Customer Real Time3941
Receivables - Payment Schedules Real Time3941
Receivables - Miscellaneous Receipts Real Time5640
Receivables - Standard Receipts Application Details Real Time6140
Receivables - Credit Memo Applications Real Time5139
Receivables - Receipts Details Real Time5038
Receivables - Revenue Adjustments Real Time5537
Receivables - Bills Receivable Real Time5436
Receivables - Credit Memo Requests Real Time3336
Receivables - Receipt Conversion Rate Adjustments Real Time3735
Receivables - Customer Account Site Tax Profile Real Time2828
Receivables - Customer Tax Profile Real Time2326
Subledger Accounting - Receivables Summary Reconciliation Real Time1818

Other / 151 subject areas

Subject areaTablesPVOs
Manufacturing - Resource Usage Real Time118624
Maintenance Management - Resource Usage Real Time114587
Costing - Cost Accounting Real Time184585
Procurement - Purchasing Real Time159570
Procurement - Procure To Pay Real Time134555
Costing - Receipt Accounting Real Time130541
Distributed Order Orchestration - Fulfillment Lines Real Time149540
Procurement - Requisitions Real Time130537
Product Management - Change Order Real Time113525
Fiscal Document Capture Transactions Real Time119520
Sourcing - Supplier Awards Real Time84518
Procurement - Purchasing Agreements Real Time100515
Manufacturing - Work Definitions Real Time77514
Manufacturing - Work Order Performance Real Time119508
Procurement - Pending Change Orders Real Time95502
Sourcing - Supplier Negotiations Real Time81502
Manufacturing - Workstation Supervision Real Time76497
Enterprise Quality Actions Real Time101496
Enterprise Quality Issues Real Time101496
Procurement - Spend Real Time127491
Costing - Work Order Costs Real Time132490
Manufacturing - Material Usage Real Time112489
Receiving - Transactions Real Time103486
Inventory - Inventory Transactions Real Time105485
Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time73482
Supply Chain Financial Orchestration Real Time112482
Product Genealogy - Genealogy Instance Real Time88480
Inventory - Inventory Supply Real Time75478
Manufacturing - Production Exceptions Real Time81476
Sourcing - Supplier Responses Real Time73476
Product Management - Change Order Approvals Real Time75472
Maintenance Management - Purchased Item Usage Real Time117469
Manufacturing - Purchased Item Usage Real Time113469
Product Management - New Item Request Approvals Real Time73469
Costing - New COGS and Gross Margin Details Real Time84467
Fiscal Document Holds Real Time81466
Fiscal Document Item Deliveries Real Time81466
Product Management - New Item Request Real Time66464
Enterprise Contracts - Contracts Real Time77463
Product Management - New Item Request Line Real Time63459
Receiving - Purchase Receipts Real Time61459
Product Management - Trading Partner Item Real Time64456
Receiving - Receipts Real Time60455
Receiving - Unordered Receipts Real Time59453
Maintenance Management - Maintenance Exception Real Time77451
Inventory - Inventory Transfer Order Real Time89449
Receiving - In-Transit Shipments Real Time80449
Distributed Order Orchestration - Order Holds Real Time52446
Procurement - Implemented Change Orders Real Time47446
Product Management - Cross Reference Item Real Time63446
Product Management - Related Item Real Time62446
Distributed Order Orchestration - Price Adjustments Real Time50444
Distributed Order Orchestration - Order Lines Real Time49441
Receiving - In-Transit Advanced Shipment Notifications Real Time66437
Installed Base - Customer Asset Real Time82435
Receiving - Interorganization Receipts Real Time51434
Costing - Landed Costs Real Time61432
Costing - Transfer Order Receipt Landed Cost Charges Real Time66432
Product Management - Change Order Line Real Time62431
Interfaced Fiscal Document Real Time74430
Manufacturing - Actual Production Real Time110430
Innovation Management - Ideas Real Time38427
Product Genealogy - Genealogy Object Composition Real Time81426
Product Genealogy - Genealogy Object Where Used Real Time81426
Product Genealogy - Genealogy Transaction Real Time81425
Supplier Qualification - Qualifications and Assessments Real Time56424
Distributed Order Orchestration - Order Headers Real Time50423
Shipping Real Time94423
Supplier Warranty - Asset Real Time60422
Product Management - Source System Item Real Time63420
Costing - Standard Cost Real Time75417
Maintenance Management - Material Usage Real Time97416
Maintenance Management - Work Order Performance Real Time102414
Installed Base - Customer Asset History Real Time55413
Product Management - Item Supplier Uploads Real Time49412
Receiving - In-Transit Interorganization Inventory Transfers Real Time53412
Product Management - Item Supplier Associations Real Time56411
Inventory - Kanban Activity Real Time57410
Inventory - Inventory Cycle Count Real Time63409
Costing - Cost Rollup Details Real Time72400
Supplier - Supplier Real Time59400
Costing - Where Used Details Real Time70399
Revenue Management - Revenue Recognition Real Time60399
Inventory - Inventory Balance Real Time71397
Revenue Management - Revenue Compliance Fair Market Value Real Time50396
Revenue Management - Revenue Compliance MEA Carve-out Real Time56396
Revenue Management - Source Documents Real Time41394
Maintenance Management - Asset Real Time76391
Product Management - Structures Real Time58390
Costing - Period Inventory Valuation Real Time74389
Quality Inspection Results Real Time68388
Maintenance Management - Asset Equipment Qualification Real Time59387
Costing - COGS and Gross Margin Real Time43386
Distributed Order Orchestration - Process Instances Real Time39379
Product Management - Item Revisions Real Time57378
Supplier Qualification - Question Responses Real Time42364
Manufacturing - Workstation Execution Activities Monitoring Real Time53363
Product Management - Components Real Time54360
Sourcing - Program Real Time31353
Costing - Period Intransit Inventory Valuation Real Time36342
Costing - Supply Chain Cost Rollup Real Time67341
Supply Chain Collaboration - Supply Planning Real Time36340
Product Management - Organization Hierarchy Real Time40335
Supplier Qualification - Supplier Eligibility History Real Time27335
Supplier Qualification - Supplier Eligibility Real Time27335
Costing - Receipt Accounting Period Close Real Time35332
Manufacturing - Workstation Checkin Activities Monitoring Real Time31331
Costing - Transaction Cost Real Time57328
Costing - Cost Accounting Period Close Real Time50325
Costing - Inventory Valuation Real Time41325
Product Genealogy - Genealogy Structure Real Time49321
Costing - Overhead Rates Real Time48315
Manufacturing - Workstation Performance Real Time32315
Enterprise Contracts - Contract Requests Real Time17313
Product Management - Item Catalog Category Hierarchy Real Time36304
Inventory - Inventory ABC Real Time36301
Supplier - Supplier Profile Change Request Real Time19301
Product Management - Structures and Components Real Time53298
Costing - Periodic Average Cost Real Time46296
Costing - Perpetual Average Cost Real Time47295
Product Management - Where Used Real Time45277
Maintenance Management - Asset History Real Time52251
Maintenance Management - Asset Failure Analysis Real Time52244
Installed Base - Meter Based Asset Usage Real Time38241
Supplier Import - Supplier Real Time35223
Supplier Portal - Invoice Real Time19217
Product Management - Approval Notification Archive Real Time16212
Supplier Portal - Purchasing Real Time15211
Supply Chain Planning Real Time33199
Maintenance Management - Forecast Real Time57182
Sustainability - Activities Real Time26178
Maintenance Management - Work Requirement Real Time52175
Supplier Registration - Real Time31165
Installed Base - Customer Asset Structure Real Time29150
Inventory Organization Real Time17136
Product Management - Manufacturer Real Time12133
Innovation Management - Product Proposals Real Time38132
Innovation Management - Requirements Real Time28108
Product Management - Teams Real Time10108
Costing - Item Cost Real Time29106
Innovation Management - Concepts Real Time27105
Innovation Management - Portfolio Resource Real Time2876
Innovation Management - Portfolio Cost Real Time2674
Innovation Management - Portfolio Revenue Real Time2674
Innovation Management - Product Portfolio Real Time2672
Innovation Management - Portfolios Real Time2071
Innovation Management - Portfolio Lifecycle Real Time1858
Innovation Management - Scenario Lifecycle Real Time2258
Costing - Resource Rates Real Time2643
OTBI Performance Real Time717
OTBI Usage Real Time717