BICC · SCM & Procurement
SCM & Procurement BICC View Objects (PVOs) by module
Every SCM & Procurement BI View Object exposed by the Business Intelligence Cloud Connector, grouped by module and mapped to the physical tables it extracts from — plus the star schema each one feeds. 406 PVOs across 11 functional groups, with shared reference and setup objects called out separately. If you're configuring a BICC extract and searching for a PVO, jump to your area below.
Contracts / 15 PVOs
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| ContractApprovalHistoryPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.ContractApprovalHistoryPVO | OKC_K_APPROVAL_HISTORY_WF_V | reference / config |
| ContractBusinessDocumentTranslationPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.ContractBusinessDocumentTranslationPVO | OKC_BUS_DOC_TYPES_TL | reference / config |
| ContractKeyTermPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.ContractKeyTermPVO | OKC_KEY_TERMS, OKC_KEY_TERM_PROMPTS, OKC_K_KEY_TERMS | reference / config |
| ContractRequestPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.ContractRequestPVO | HZ_PARTIES, OKC_CONTRACT_REQUESTS, OKC_K_HEADERS_VL | reference / config |
| ContractRequestTypePVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.ContractRequestTypePVO | OKC_CONTRACT_REQ_TYPES | reference / config |
| ContractRiskPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.ContractRiskPVO | OKC_CONTRACT_RISKS, OKC_RISK_EVENTS_VL | reference / config |
| ContractStatusHistoryPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.ContractStatusHistoryPVO | HR_ALL_ORGANIZATION_UNITS_F_VL, HZ_PARTIES, OKC_K_STATUS_HISTORY_VL | reference / config |
| ContractTypesTLPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.ContractTypesTLPVO | OKC_CONTRACT_TYPES_TL | reference / config |
| RelatedContractPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.RelatedContractPVO | HZ_PARTIES, OKC_K_HEADERS_ALL_B, OKC_K_HEADERS_TL | reference / config |
| ResourceOrganizationPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.ResourceOrganizationPVO | OKC_RESOURCE_ORGANIZATIONS_V | reference / config |
| ResourcePVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.ResourcePVO | JTF_RS_RESOURCE_PROFILES | reference / config |
| SalesCreditPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.SalesCreditPVO | AR_SALES_CREDIT_TYPES, OKC_K_SALES_CREDITS, RA_SALESREPS | reference / config |
| TermsDeviationPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.TermsDeviationPVO | OKC_ARTICLES_ALL, OKC_TERMS_DEVIATIONS_T, OKC_XPRT_RULE_HDRS_ALL | reference / config |
| UserStatusPVO | oracle.apps.contracts.coreAuthoring.publicView.analytics.UserStatusPVO | OKC_USER_STATUSES_VL | reference / config |
| ContractEventPVO | oracle.apps.projects.billing.contracts.publicView.analytics.ContractEventPVO | PJB_CONTRACT_EVENTS_B, PJB_CONTRACT_EVENTS_TL, PJF_PROJ_ELEMENTS_B | reference / config |
Cost Management / 20 PVOs
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| CostingGrossMarginPVO | oracle.apps.scm.costing.cogs.cogsTransactions.publicView.analytics.CostingGrossMarginPVO | CST_GROSS_MARGIN_DETAILS | reference / config |
| CostOrgBookRefPVO | oracle.apps.scm.costing.coreSetup.costOrganizations.publicView.analytics.CostOrgBookRefPVO | CST_COST_BOOKS_B, CST_COST_BOOKS_TL, CST_COST_ORGS_V | reference / config |
| CostOrganizationPVO | oracle.apps.scm.costing.coreSetup.costOrganizations.publicView.analytics.CostOrganizationPVO | CST_COST_ORGS_V | reference / config |
| CostOrganizationRefPVO | oracle.apps.scm.costing.coreSetup.costOrganizations.publicView.analytics.CostOrganizationRefPVO | CST_COST_ORGS_V | reference / config |
| ValuationUnitRefPVO | oracle.apps.scm.costing.coreSetup.valuationUnits.publicView.analytics.ValuationUnitRefPVO | CST_COST_BOOKS_TL, CST_COST_ORGS_V, CST_VAL_STRUCTURES_B | reference / config |
| CostedPeriodIntransitValuationPVO | oracle.apps.scm.costing.costAccounting.reports.publicView.analytics.CostedPeriodIntransitValuationPVO | CST_INTR_ONHAND_VALUATIONS | reference / config |
| CostAccountingGLOverrideAccountsPVO | oracle.apps.scm.costing.costPreProcessor.costPreProcessorEng.publicView.analytics.CostAccountingGLOverrideAccountsPVO | CST_XLA_GL_OVERRIDE_ACCTS_VL | reference / config |
| CostAccountingTransactionsPVO | oracle.apps.scm.costing.costPreProcessor.costPreProcessorEng.publicView.analytics.CostAccountingTransactionsPVO | AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, CMR_AP_INVOICE_DTLS | reference / config |
| CstExpensePoolPVO | oracle.apps.scm.costing.costPreProcessor.costPreProcessorEng.publicView.analytics.CstExpensePoolPVO | CST_EXPENSE_POOLS_B, CST_EXPENSE_POOLS_TL | reference / config |
| CstPeriodicAverageCostPVO | oracle.apps.scm.costing.itemcosts.publicView.analytics.CstPeriodicAverageCostPVO | CST_PERIODIC_AVG_COSTS, CST_PERIOD_STATUSES | reference / config |
| CstPerpetualAverageCostPVO | oracle.apps.scm.costing.itemcosts.publicView.analytics.CstPerpetualAverageCostPVO | CST_COST_ELEMENTS_B, CST_PERPAVG_COST, CST_TRANSACTIONS | reference / config |
| CstStandardCostPVO | oracle.apps.scm.costing.itemcosts.publicView.analytics.CstStandardCostPVO | CST_COST_ELEMENTS_B, CST_OPEN_PO_AMOUNTS_OTBI_V, CST_STD_COSTS | reference / config |
| CstTransactionCostPVO | oracle.apps.scm.costing.itemcosts.publicView.analytics.CstTransactionCostPVO | CST_COST_ELEMENTS_B, CST_TRANSACTIONS, CST_TRANSACTION_COSTS | reference / config |
| CstPeriodCloseActionsPVO | oracle.apps.scm.costing.periodEnd.periodEndProcess.publicView.analytics.CstPeriodCloseActionsPVO | CST_PERIOD_CLOSE_ACTIONS | reference / config |
| CstTransactionsErrorsPVO | oracle.apps.scm.costing.periodEnd.periodEndProcess.publicView.analytics.CstTransactionsErrorsPVO | CST_ALL_COST_TRANSACTIONS_V, CST_ALL_INTF_TRANSACTIONS_V, CST_CP_ERRORS | reference / config |
| CstUncostedTxnErrorsPVO | oracle.apps.scm.costing.periodEnd.periodEndProcess.publicView.analytics.CstUncostedTxnErrorsPVO | CST_UNCOSTED_TXN_ERRORS_V | reference / config |
| CstUninterfacedTxnsPVO | oracle.apps.scm.costing.periodEnd.periodEndProcess.publicView.analytics.CstUninterfacedTxnsPVO | CST_UNINTF_TXNS_PIVOT_V | reference / config |
| PeriodStatusPVO | oracle.apps.scm.costing.periodEnd.periodEndProcess.publicView.analytics.PeriodStatusPVO | CST_PERIOD_STATUSES | reference / config |
| ChargesPVO | oracle.apps.scm.landedCost.coreSetup.landedCostCharge.publicView.analytics.ChargesPVO | CML_CHARGES_B, CML_CHARGES_TL | reference / config |
| LandedCostPVO | oracle.apps.scm.landedCost.landedCosts.reviewLandedCostCharge.publicView.analytics.LandedCostPVO | CML_LANDED_COST_CHARGES, PO_HEADERS_ALL, RCV_SHIPMENT_HEADERS | reference / config |
Customers & Parties / 18 PVOs
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| CustomerSecuredPVO | oracle.apps.cdm.foundation.parties.publicView.analytics.CustomerSecuredPVO | HZ_PARTIES | reference / config |
| PartySitePVO | oracle.apps.cdm.foundation.parties.publicView.analytics.PartySitePVO | HZ_PARTY_SITES | reference / config |
| PartyUsagePVO | oracle.apps.cdm.foundation.parties.publicView.analytics.PartyUsagePVO | HZ_PARTIES | reference / config |
| RelationshipPVO | oracle.apps.cdm.foundation.parties.publicView.analytics.RelationshipPVO | HZ_PARTIES, HZ_RELATIONSHIPS, HZ_RELATIONSHIP_TYPES | reference / config |
| PartyResourcePVO | oracle.apps.cdm.foundation.resources.publicView.analytics.PartyResourcePVO | HZ_PARTIES | reference / config |
| ResourceManagerPVO | oracle.apps.cdm.foundation.resources.publicView.analytics.ResourceManagerPVO | HZ_PARTIES | reference / config |
| ResourcePVO | oracle.apps.cdm.foundation.resources.publicView.analytics.ResourcePVO | HZ_PARTIES | reference / config |
| PersonDetailsRefPVO | oracle.apps.scm.commonWorkSetup.resources.publicView.analytics.PersonDetailsRefPVO | HZ_PARTIES, HZ_PARTY_USG_ASSIGNMENTS, WIS_PARTY_PERSON_DETAILS_V | reference / config |
| ResourceRefPVO | oracle.apps.scm.commonWorkSetup.resources.publicView.analytics.ResourceRefPVO | PJF_EXP_TYPES_TL, WIS_RESOURCES_B, WIS_RESOURCES_TL | reference / config |
| WDAlternateResourcesRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDAlternateResourcesRefPVO | WIS_RESOURCES_B, WIS_RESOURCES_TL, WIS_WD_OP_ALT_RESOURCES_V | reference / config |
| AssetHistoryIBPVO | oracle.apps.scm.installedBase.customerAssets.publicView.analytics.AssetHistoryIBPVO | CSE_ASSETS_HIST, CSE_TRANSACTIONS, WIE_WORK_ORDERS_VL | reference / config |
| CustomerAssetBuiltStructurePVO | oracle.apps.scm.installedBase.customerAssets.publicView.analytics.CustomerAssetBuiltStructurePVO | CSE_AS_BUILT_STRUCTURES_V | reference / config |
| CustomerAssetPVO | oracle.apps.scm.installedBase.customerAssets.publicView.analytics.CustomerAssetPVO | CSE_ASSETS_B, CSE_ASSETS_TL, CSE_GENEALOGY_OBJECTS | reference / config |
| CustomerAssetSoldStructurePVO | oracle.apps.scm.installedBase.customerAssets.publicView.analytics.CustomerAssetSoldStructurePVO | CSE_AS_SOLD_STRUCTURES_V | reference / config |
| OSSProductAssociationsPVO | oracle.apps.scm.installedBase.customerAssets.publicView.analytics.OSSProductAssociationsPVO | OSS_SUBSCRIPTIONS | reference / config |
| ProposalResourceMonthPVO | oracle.apps.scm.productConceptDesign.concepts.publicView.analytics.ProposalResourceMonthPVO | ACD_BUSINESS_DETAILS_VL, ACD_CONCEPT_TL, ACD_CONCEPT_VL | reference / config |
| ProductProposalResourceCapacityMonthPVO | oracle.apps.scm.productPortfolio.portfolios.publicView.analytics.ProductProposalResourceCapacityMonthPVO | ACE_RESOURCE_CAPACITY_MONTH_V | reference / config |
| ProductProposalResourceUtilMonthPVO | oracle.apps.scm.productPortfolio.portfolios.publicView.analytics.ProductProposalResourceUtilMonthPVO | ACE_RESOURCE_UTIL_MONTH_V | reference / config |
Inventory / 23 PVOs
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| CstOnhandValuationsPVO | oracle.apps.scm.costing.costAccounting.reports.publicView.analytics.CstOnhandValuationsPVO | CST_VU_ONHAND_VALUATIONS | reference / config |
| OnhandValuationCostedPeriodPVO | oracle.apps.scm.costing.costAccounting.reports.publicView.analytics.OnhandValuationCostedPeriodPVO | CST_ATTR_ONHAND_VALUATIONS | reference / config |
| InvItemLocatorPVO | oracle.apps.scm.inv.publicView.analytics.InvItemLocatorPVO | INV_ITEM_LOCATIONS, INV_SECONDARY_LOCATORS | reference / config |
| InvItemLocatorRefPVO | oracle.apps.scm.inv.publicView.analytics.InvItemLocatorRefPVO | INV_ITEM_LOCATIONS, INV_SECONDARY_LOCATORS | reference / config |
| InvItemSubinventoryPVO | oracle.apps.scm.inv.publicView.analytics.InvItemSubinventoryPVO | INV_ITEM_SUB_INVENTORIES | reference / config |
| InvItemSubinventoryRefPVO | oracle.apps.scm.inv.publicView.analytics.InvItemSubinventoryRefPVO | INV_ITEM_SUB_INVENTORIES | reference / config |
| AbcAssignmentPVO | oracle.apps.scm.inventory.publicView.analytics.AbcAssignmentPVO | INV_ABC_ASSIGNMENT_V, INV_ABC_COMPILES, INV_ABC_COMPILE_HEADERS | reference / config |
| AbcClassRefPVO | oracle.apps.scm.inventory.publicView.analytics.AbcClassRefPVO | INV_ABC_CLASSES | reference / config |
| AbcCompileHeaderPVO | oracle.apps.scm.inventory.publicView.analytics.AbcCompileHeaderPVO | INV_ABC_COMPILE_HEADERS | reference / config |
| AbcCompilePVO | oracle.apps.scm.inventory.publicView.analytics.AbcCompilePVO | INV_ABC_COMPILES, INV_ABC_COMPILE_HEADERS | reference / config |
| CycleCountApprovalOptionPVO | oracle.apps.scm.inventory.publicView.analytics.CycleCountApprovalOptionPVO | FND_LOOKUPS | reference / config |
| CycleCountApprovalTypePVO | oracle.apps.scm.inventory.publicView.analytics.CycleCountApprovalTypePVO | FND_LOOKUPS | reference / config |
| CycleCountEntryStatusPVO | oracle.apps.scm.inventory.publicView.analytics.CycleCountEntryStatusPVO | FND_LOOKUPS | reference / config |
| CycleCountHeaderPVO | oracle.apps.scm.inventory.publicView.analytics.CycleCountHeaderPVO | INV_ABC_ASSIGNMENT_GROUPS, INV_CYCLE_COUNT_HEADERS, ZMM_SR_SCHEDULES_VL | reference / config |
| CycleCountHistoryPVO | oracle.apps.scm.inventory.publicView.analytics.CycleCountHistoryPVO | INV_CC_ENTRIES_HISTORY | reference / config |
| CycleCountPVO | oracle.apps.scm.inventory.publicView.analytics.CycleCountPVO | EGP_SYSTEM_ITEMS_B_V, HZ_PARTIES, INV_ABC_ASSIGNMENT_GROUPS | reference / config |
| InvLotRefPVO | oracle.apps.scm.inventory.publicView.analytics.InvLotRefPVO | INV_GRADES_TL, INV_LOT_NUMBERS | reference / config |
| InventoryLicensePlateNumberPVO | oracle.apps.scm.inventory.publicView.analytics.InventoryLicensePlateNumberPVO | INV_LICENSE_PLATE_NUMBERS | reference / config |
| InventorySerialRefPVO | oracle.apps.scm.inventory.publicView.analytics.InventorySerialRefPVO | INV_SERIAL_NUMBERS | reference / config |
| InventoryTransactionDetailRefPVO | oracle.apps.scm.inventory.publicView.analytics.InventoryTransactionDetailRefPVO | INV_CYCLE_COUNT_HEADERS, INV_GENERIC_DISPOSITIONS, INV_MATERIAL_TXNS | reference / config |
| MovementRequestLinePVO | oracle.apps.scm.inventory.publicView.analytics.MovementRequestLinePVO | INV_TXN_REQUEST_HEADERS, INV_TXN_REQUEST_LINES | reference / config |
| TransferOrderDistributionPVO | oracle.apps.scm.inventory.publicView.analytics.TransferOrderDistributionPVO | INV_TRANSFER_ORDER_DISTRIBS, INV_TRANSFER_ORDER_HEADERS, INV_TRANSFER_ORDER_LINES | reference / config |
| TransferOrderLinePVO | oracle.apps.scm.inventory.publicView.analytics.TransferOrderLinePVO | INV_TRANSFER_ORDER_HEADERS, INV_TRANSFER_ORDER_LINES | reference / config |
Logistics & Shipping / 5 PVOs
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| ReceivingTransactionTypePVO | oracle.apps.scm.receiptAccounting.reviewAccounting.publicView.analytics.ReceivingTransactionTypePVO | CMR_TRANSACTION_TYPES_VL | reference / config |
| ReceivingReceiptP2PTransactionPVO | oracle.apps.scm.receiving.receipts.publicView.analytics.ReceivingReceiptP2PTransactionPVO | EGP_CATEGORIES_VL, EGP_SYSTEM_ITEMS_VL, POR_REQUISITION_LINES_ALL | reference / config |
| ReceivingReceiptsRefPVO | oracle.apps.scm.receiving.receipts.publicView.analytics.ReceivingReceiptsRefPVO | EGP_CATEGORIES_VL, PER_PERSON_NAMES_F_V, PO_HEADERS_ALL | reference / config |
| PackingUnitPVO | oracle.apps.scm.shipping.shipConfirm.deliveries.publicView.analytics.PackingUnitPVO | INV_LICENSE_PLATE_NUMBERS | reference / config |
| ShippingLPNPVO | oracle.apps.scm.shipping.shipConfirm.deliveries.publicView.analytics.ShippingLPNPVO | WSH_LPN_OTBI_V | reference / config |
Maintenance / 34 PVOs
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| FailureAnalysisPVO | oracle.apps.scm.assetTracking.failureAnalysis.publicView.analytics.FailureAnalysisPVO | CSE_ASSETS_B, CSE_FAILURE_EVENTS | reference / config |
| FailureEventRefPVO | oracle.apps.scm.assetTracking.failureAnalysis.publicView.analytics.FailureEventRefPVO | CSE_FAILURE_EVENTS | reference / config |
| FailureInstanceRefPVO | oracle.apps.scm.assetTracking.failureAnalysis.publicView.analytics.FailureInstanceRefPVO | CSE_CONDITION_EVENT_CODES_B, CSE_CONDITION_EVENT_CODES_TL, CSE_FAILURE_INSTANCES | reference / config |
| FailureSetPVO | oracle.apps.scm.assetTracking.failureAnalysis.publicView.analytics.FailureSetPVO | CSE_FAILURE_SETS_B, CSE_FAILURE_SETS_TL | reference / config |
| AssetQualificationsPVO | oracle.apps.scm.maintenanceManagement.equipmentQualification.publicView.analytics.AssetQualificationsPVO | CSE_ASSET_QUALIFICATIONS | reference / config |
| MntAssetEquipmentQualificationPVO | oracle.apps.scm.maintenanceManagement.equipmentQualification.publicView.analytics.MntAssetEquipmentQualificationPVO | CSE_ASSET_QUALIFICATIONS | reference / config |
| MntEqpQualProfilePVO | oracle.apps.scm.maintenanceManagement.equipmentQualification.publicView.analytics.MntEqpQualProfilePVO | FUSION.MNT_EQP_QUAL_PROFILES_TL, MNT_EQP_QUAL_PROFILES_B, MNT_EQP_QUAL_PROFILE_REQS | reference / config |
| MntEqpQualReqsPVO | oracle.apps.scm.maintenanceManagement.equipmentQualification.publicView.analytics.MntEqpQualReqsPVO | FUSION.MNT_EQP_QUAL_REQS_B, FUSION.MNT_EQP_QUAL_REQS_TL | reference / config |
| MntEqrInspectionPlansPVO | oracle.apps.scm.maintenanceManagement.equipmentQualification.publicView.analytics.MntEqrInspectionPlansPVO | INV_ORG_PARAMETERS, MNT_EQR_INSPECTION_PLANS, QA_INSPECTION_PLANS_B | reference / config |
| ConditionEventCodePVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.ConditionEventCodePVO | CSE_CONDITION_EVENT_CODES_TL | reference / config |
| MaintenanceConditionEventPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceConditionEventPVO | CSE_CONDITION_EVENT_CODES_B, CSE_CONDITION_EVENT_CODES_TL, MNT_WR_CONDITION_EVENTS | reference / config |
| MaintenanceForecastFactPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceForecastFactPVO | INV_ORG_PARAMETERS, MNT_FORECASTS, MNT_FORECAST_LINES | reference / config |
| MaintenanceForecastLinePVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceForecastLinePVO | MNT_FORECAST_LINES | reference / config |
| MaintenanceForecastLineRefPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceForecastLineRefPVO | MNT_FORECAST_LINES | reference / config |
| MaintenanceForecastPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceForecastPVO | INV_ORG_PARAMETERS, MNT_FORECASTS | reference / config |
| MaintenanceForecastRefPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceForecastRefPVO | MNT_FORECASTS | reference / config |
| MaintenanceMeterPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceMeterPVO | CSE_METERS, CSE_METER_DEFINITIONS_B, CSE_METER_DEFINITIONS_TL | reference / config |
| MaintenanceProgramPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceProgramPVO | MNT_PROGRAMS_B, MNT_PROGRAMS_TL | reference / config |
| MaintenanceProgramRefPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceProgramRefPVO | MNT_PROGRAMS_B, MNT_PROGRAMS_TL | reference / config |
| MaintenanceSchedulePatternPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceSchedulePatternPVO | MNT_SCHEDULE_PATTERNS_B, MNT_SCHEDULE_PATTERNS_TL | reference / config |
| MaintenanceSchedulePatternRefPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceSchedulePatternRefPVO | MNT_SCHEDULE_PATTERNS_B, MNT_SCHEDULE_PATTERNS_TL | reference / config |
| MaintenanceWRWorkDefinitionPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceWRWorkDefinitionPVO | MNT_WR_WORK_DEFINITIONS | reference / config |
| MaintenanceWorkRequirementFactPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceWorkRequirementFactPVO | CSE_HIERARCHIES_B, CSE_HIERARCHIES_TL, MNT_WORK_REQUIREMENTS_FACT_V | reference / config |
| MaintenanceWorkRequirementPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceWorkRequirementPVO | CSE_HIERARCHIES_B, CSE_HIERARCHIES_TL, MNT_WORK_REQUIREMENTS_B | reference / config |
| MaintenanceWorkRequirementRefPVO | oracle.apps.scm.maintenanceManagement.maintProgram.publicView.analytics.MaintenanceWorkRequirementRefPVO | CSE_HIERARCHIES_B, CSE_HIERARCHIES_TL, MNT_WORK_REQUIREMENTS_B | reference / config |
| WarrantyClaimPVO | oracle.apps.scm.supplierWarranty.publicView.analytics.WarrantyClaimPVO | CSE_CONDITION_EVENT_CODES_B, CSE_W_CLAIMS_B | reference / config |
| WarrantyContractMeterPVO | oracle.apps.scm.supplierWarranty.publicView.analytics.WarrantyContractMeterPVO | CSE_METERS, CSE_METER_DEFINITIONS_B, CSE_METER_DEFINITIONS_TL | reference / config |
| WarrantyContractPVO | oracle.apps.scm.supplierWarranty.publicView.analytics.WarrantyContractPVO | CSE_W_CONTRACTS | reference / config |
| WarrantyCoverageApplicabilityPVO | oracle.apps.scm.supplierWarranty.publicView.analytics.WarrantyCoverageApplicabilityPVO | CSE_W_COVERAGE_APPLICABILITIES, EGP_SYSTEM_ITEMS_B_V, HR_ORGANIZATION_UNITS_F_TL | reference / config |
| WarrantyCoverageContractAssetPVO | oracle.apps.scm.supplierWarranty.publicView.analytics.WarrantyCoverageContractAssetPVO | CSE_W_CLAIMS_B, CSE_W_CONTRACTS, CSE_W_COVERAGES_B | reference / config |
| WarrantyCoverageMeterPVO | oracle.apps.scm.supplierWarranty.publicView.analytics.WarrantyCoverageMeterPVO | CSE_METER_DEFINITIONS_TL, CSE_METER_DEFINITIONS_VL, CSE_W_COVERAGE_METERS | reference / config |
| WarrantyCoveragePVO | oracle.apps.scm.supplierWarranty.publicView.analytics.WarrantyCoveragePVO | CSE_W_COVERAGES_B, CSE_W_COVERAGES_TL, HZ_PARTIES | reference / config |
| WarrantyCoverageTxnCodePVO | oracle.apps.scm.supplierWarranty.publicView.analytics.WarrantyCoverageTxnCodePVO | CSE_CONDITION_EVENT_CODES_B, CSE_CONDITION_EVENT_CODES_TL, CSE_W_COVERAGE_TXN_CODES | reference / config |
| WarrantyEntitlementPVO | oracle.apps.scm.supplierWarranty.publicView.analytics.WarrantyEntitlementPVO | CSE_CONDITION_EVENT_CODES_B, CSE_W_ENTITLEMENTS | reference / config |
Manufacturing / 52 PVOs
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| PlanningSalesOperationsPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanningSalesOperationsPVO | MSC_ANALYTIC_FACT_SOP_V | reference / config |
| GenealogyCompositionPVO | oracle.apps.scm.assetTracking.productGenealogy.publicView.analytics.GenealogyCompositionPVO | CSE_GENEALOGY_COMPOSITION_V | reference / config |
| GenealogyObjectPVO | oracle.apps.scm.assetTracking.productGenealogy.publicView.analytics.GenealogyObjectPVO | CSE_GENEALOGY_OBJECTS | reference / config |
| GenealogyWhereUsedPVO | oracle.apps.scm.assetTracking.productGenealogy.publicView.analytics.GenealogyWhereUsedPVO | CSE_GENEALOGY_WHERE_USED_V | reference / config |
| TrackedObjectRefPVO | oracle.apps.scm.assetTracking.productGenealogy.publicView.analytics.TrackedObjectRefPVO | CSE_TRACKED_OBJECT_REFS | reference / config |
| TransactedAssetPVO | oracle.apps.scm.assetTracking.productGenealogy.publicView.analytics.TransactedAssetPVO | CSE_TRANSACTED_ASSETS, CSE_TRANSACTIONS | reference / config |
| MaterialTransactionDetailPVO | oracle.apps.scm.commonWorkExecution.workOrderMaterialTransactions.publicView.analytics.MaterialTransactionDetailPVO | WIE_WO_OPERATION_MATERIALS, WIE_WO_OPERATION_OUTPUTS | reference / config |
| AssetHistoryMntPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.AssetHistoryMntPVO | CSE_ASSETS_B, CSE_ASSETS_HIST, CSE_TRANSACTIONS | reference / config |
| AssetTransactionRelationHistoryPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.AssetTransactionRelationHistoryPVO | CSE_ASSETS_B, CSE_ASSET_RELATIONSHIPS_HIST, CSE_TRANSACTIONS | reference / config |
| LocationPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.LocationPVO | HR_LOCATIONS_ALL_F_VL | reference / config |
| MfgExceptionPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.MfgExceptionPVO | ENQ_AFFECTED_OBJECTS_B, ENQ_ISSUES_B, ENQ_WORKFLOW_OTBI_VL | reference / config |
| MntEquipmentQualificationProfileRefPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.MntEquipmentQualificationProfileRefPVO | FUSION.MNT_EQP_QUAL_PROFILES_TL, FUSION.MNT_EQP_QUAL_REQS_B, FUSION.MNT_EQP_QUAL_REQS_TL | reference / config |
| MntExceptionPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.MntExceptionPVO | ENQ_AFFECTED_OBJECTS_B, ENQ_ISSUES_B, ENQ_WORKFLOW_OTBI_VL | reference / config |
| ProductionLineRefPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.ProductionLineRefPVO | WIS_PRODUCTION_LINES_B, WIS_PRODUCTION_LINES_TL | reference / config |
| WOMaintenanceAssetDimPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOMaintenanceAssetDimPVO | CSE_ASSETS_VL, CSE_CONDITION_EVENT_CODES_B, CSE_CONDITION_EVENT_CODES_TL | reference / config |
| WOMaintenanceAssetFactPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOMaintenanceAssetFactPVO | CSE_ASSETS_VL, CSE_CONDITION_EVENT_CODES_B, CSE_CONDITION_EVENT_CODES_TL | reference / config |
| WOMntDocReferenceRefPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOMntDocReferenceRefPVO | MNT_WO_DOC_REFERENCES | reference / config |
| WOOperationMaterialSubstituteRefPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOOperationMaterialSubstituteRefPVO | EGP_SYSTEM_ITEMS_VL, WIE_WO_OP_SUB_MATERIALS | reference / config |
| WOOperationOutputDetailDimPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOOperationOutputDetailDimPVO | WIE_WO_OPERATION_OUTPUTS | reference / config |
| WOOperationOutputDetailDimRefPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOOperationOutputDetailDimRefPVO | WIE_WO_OPERATION_OUTPUTS | reference / config |
| WOOperationOutputDetailFactPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOOperationOutputDetailFactPVO | WIE_WO_OP_OUTPUT_DETAIL_V | reference / config |
| WOOperationStartStopDistinctPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOOperationStartStopDistinctPVO | WIE_WO_OPERATION_START_STOP_V | reference / config |
| WOOperationStartStopPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOOperationStartStopPVO | WIE_WO_OPERATION_START_STOP, WIE_WO_PRODUCT_SERIALS | reference / config |
| WOOperationStartStopRefPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOOperationStartStopRefPVO | WIE_WO_OPERATION_START_STOP, WIE_WO_PRODUCT_SERIALS | reference / config |
| WOOperationsResourceInstancesPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOOperationsResourceInstancesPVO | WIE_WO_OPERATION_RESOURCES, WIE_WO_OP_RESOURCE_INSTANCES | reference / config |
| WOProcurementPOPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOProcurementPOPVO | EGP_CATEGORIES_VL, EGP_SYSTEM_ITEMS_B_V, POR_REQUISITION_HEADERS_ALL | reference / config |
| WOProcurementReceiptPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOProcurementReceiptPVO | EGP_CATEGORIES_VL, EGP_SYSTEM_ITEMS_B_V, INV_TRANSACTION_LOT_NUMBERS | reference / config |
| WOProcurementReqPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOProcurementReqPVO | EGP_CATEGORIES_VL, EGP_SYSTEM_ITEMS_B_V, POR_REQUISITION_HEADERS_ALL | reference / config |
| WOSerialsRefPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WOSerialsRefPVO | INV_SERIAL_NUMBERS | reference / config |
| WorkOrderGroupRefPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WorkOrderGroupRefPVO | WIE_WORK_ORDER_GROUPS_TL | reference / config |
| WorkOrderProductSerialPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WorkOrderProductSerialPVO | WIE_WO_PRODUCT_SERIALS | reference / config |
| WorkOrderStatusHistoryPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WorkOrderStatusHistoryPVO | WIE_WO_STATUSES_TL, WIE_WO_STATUS_HISTORY | reference / config |
| WorkOrderStatusHistoryRefPVO | oracle.apps.scm.commonWorkExecution.workOrders.publicView.analytics.WorkOrderStatusHistoryRefPVO | WIE_WO_STATUSES_TL, WIE_WO_STATUS_HISTORY | reference / config |
| AssignedOperationsPVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.AssignedOperationsPVO | WIE_WS_OPERATION_ASSIGNMENTS | reference / config |
| WorkstationCheckinActivitiesPVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.WorkstationCheckinActivitiesPVO | PER_USERS, WIE_WS_CHECKIN_ACTIVITIES | reference / config |
| WorkstationExecActivitiesPVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.WorkstationExecActivitiesPVO | WIE_WS_EXEC_ACTIVITIES | reference / config |
| WorkstationReasonCodePVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.WorkstationReasonCodePVO | WIE_WS_REASON_CODES_B, WIE_WS_REASON_CODES_TL | reference / config |
| WorkstationRefPVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.WorkstationRefPVO | WIS_WORKSTATIONS_B, WIS_WORKSTATIONS_TL, WIS_WORKSTATIONS_VL | reference / config |
| WorkstationStatusHistoryPVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.WorkstationStatusHistoryPVO | WIE_WS_STATUS_HISTORY | reference / config |
| WorkstationSupervisorPVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.WorkstationSupervisorPVO | WIE_WS_OPERATION_ASSIGNMENTS, WIE_WS_OPERATOR_ASSIGNMENTS | reference / config |
| WDOperationItemsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDOperationItemsRefPVO | WIS_WD_OPERATION_MATERIALS_V | reference / config |
| WDOperationMaterialSubstituteRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDOperationMaterialSubstituteRefPVO | WIS_WD_OP_SUB_MATERIALS | reference / config |
| WDOperationOutputsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDOperationOutputsRefPVO | WIS_WD_OPERATION_OUTPUTS_V | reference / config |
| WDOperationRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDOperationRefPVO | WIS_WD_OPERATIONS_V | reference / config |
| WDOperationResourcesRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDOperationResourcesRefPVO | WIS_WD_OPERATION_RESOURCES_V | reference / config |
| WDProductionLineRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDProductionLineRefPVO | WIS_PRODUCTION_LINES_B, WIS_PRODUCTION_LINES_TL | reference / config |
| WDWorkDefinitionOperationsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDWorkDefinitionOperationsRefPVO | POZ_SUPPLIERS_V, POZ_SUPPLIER_SITES_ALL_M, WIS_STANDARD_OPERATIONS_B | reference / config |
| CstWOCostVarianceDetailsPVO | oracle.apps.scm.costing.workOrderCosts.publicView.analytics.CstWOCostVarianceDetailsPVO | CST_ALL_COST_TRANSACTIONS_V, CST_WORK_ORDERS, CST_WORK_ORDER_COSTS | reference / config |
| CstWOUpdateEventsPVO | oracle.apps.scm.costing.workOrderCosts.publicView.analytics.CstWOUpdateEventsPVO | CST_WO_UPDATE_EVENTS_V | reference / config |
| CstWorkOrderCostsPVO | oracle.apps.scm.costing.workOrderCosts.publicView.analytics.CstWorkOrderCostsPVO | CST_ALL_COST_TRANSACTIONS_V, CST_WORK_ORDERS, CST_WORK_ORDER_COSTS | reference / config |
| TradeOperationPVO | oracle.apps.scm.landedCost.tradeOperation.manageTradeOperation.publicView.analytics.TradeOperationPVO | CML_TRADE_OPERATIONS | reference / config |
| ManufacturerPVO | oracle.apps.scm.productModel.manufacturer.publicView.analytics.ManufacturerPVO | EGP_MANUFACTURER, HZ_ORGANIZATION_PROFILES, HZ_PARTIES | reference / config |
Order Management / 21 PVOs
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| OrdersPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.OrdersPVO | MSC_ANALYTIC_FACT_ORD_V | reference / config |
| WDChangeOrderDetailsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDChangeOrderDetailsRefPVO | EGO_CHANGE_TYPES_TL, EGO_ENGINEERING_CHANGES_B, EGO_ENGINEERING_CHANGES_TL | reference / config |
| WDChangeOrderLineDetailsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDChangeOrderLineDetailsRefPVO | EGO_CHANGE_LINES_B, EGO_CHANGE_LINES_TL | reference / config |
| BillingPlanPVO | oracle.apps.scm.doo.publicView.analytics.BillingPlanPVO | DOO_BILLING_PLANS, DOO_DOCUMENT_REFERENCES, DOO_DOC_REFERENCES_DROPSHIP_V | reference / config |
| ChargeDefinitionPVO | oracle.apps.scm.doo.publicView.analytics.ChargeDefinitionPVO | QP_CHARGE_DEFINITIONS_VL | reference / config |
| FulfillLineStatusCurrentLangPVO | oracle.apps.scm.doo.publicView.analytics.FulfillLineStatusCurrentLangPVO | DOO_STATUSES_TL | reference / config |
| GlobalTradingPartnerPVO | oracle.apps.scm.doo.publicView.analytics.GlobalTradingPartnerPVO | MSC_GLOBAL_TRADING_PARTNERS | reference / config |
| ManualPriceAdjustmentPVO | oracle.apps.scm.doo.publicView.analytics.ManualPriceAdjustmentPVO | DOO_DOCUMENT_REFERENCES, DOO_DOC_REFERENCES_DROPSHIP_V, DOO_DOC_REFERENCES_SUPPLY_V | reference / config |
| OrderAddressBillTo | oracle.apps.scm.doo.publicView.analytics.OrderAddressBillTo | DOO_ORDER_ADDRESSES | reference / config |
| OrderChargeComponentPVO | oracle.apps.scm.doo.publicView.analytics.OrderChargeComponentPVO | DOO_DOCUMENT_REFERENCES, DOO_DOC_REFERENCES_DROPSHIP_V, DOO_DOC_REFERENCES_SUPPLY_V | reference / config |
| OrderSubscriptionChargeTierPVO | oracle.apps.scm.doo.publicView.analytics.OrderSubscriptionChargeTierPVO | DOO_ORDER_CHARGE_TIERS | reference / config |
| OrderTotalPVO | oracle.apps.scm.doo.publicView.analytics.OrderTotalPVO | DOO_HEADERS_ALL, DOO_ORDER_TOTALS | reference / config |
| PriceElementPVO | oracle.apps.scm.doo.publicView.analytics.PriceElementPVO | QP_PRICE_ELEMENTS_VL | reference / config |
| PromotionCodePVO | oracle.apps.scm.doo.publicView.analytics.PromotionCodePVO | DOO_ORDER_PROMOTION_CODES | reference / config |
| PromotionPVO | oracle.apps.scm.doo.publicView.analytics.PromotionPVO | QP_PROMOTIONS_VL | reference / config |
| SalesCreditPVO | oracle.apps.scm.doo.publicView.analytics.SalesCreditPVO | DOO_SALES_CREDITS, MSC_SALES_CREDIT_TYPES | reference / config |
| StatusCurrentLangPVO | oracle.apps.scm.doo.publicView.analytics.StatusCurrentLangPVO | DOO_STATUSES_B, DOO_STATUSES_TL | reference / config |
| TotalDefinitionPVO | oracle.apps.scm.doo.publicView.analytics.TotalDefinitionPVO | QP_TOTAL_DEFINITIONS_VL | reference / config |
| TradingPartnerSitePVO | oracle.apps.scm.doo.publicView.analytics.TradingPartnerSitePVO | MSC_TRADING_PARTNER_SITES | reference / config |
| TransferOrderLandedCostChargesPVO | oracle.apps.scm.landedCost.landedCosts.reviewLandedCostCharge.publicView.analytics.TransferOrderLandedCostChargesPVO | CML_TO_LANDED_COST_CHARGES, CMR_RCV_TRANSACTIONS, RCV_SHIPMENT_HEADERS | reference / config |
| ChangeOrderTranslatePVO | oracle.apps.scm.productCollaboration.common.publicView.analytics.ChangeOrderTranslatePVO | EGO_ENGINEERING_CHANGES_TL | reference / config |
Procurement / 37 PVOs
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| PurchasingHazardClassPVO | oracle.apps.prc.po.hazardClasses.publicView.analytics.PurchasingHazardClassPVO | PO_HAZARD_CLASSES_TL | reference / config |
| ApprovalCommentsPVO | oracle.apps.prc.po.publicView.analytics.ApprovalCommentsPVO | POR_APPROVAL_TASK_COMMENTS | reference / config |
| PurchasingDocumentActionHistoryPVO | oracle.apps.prc.po.publicView.analytics.PurchasingDocumentActionHistoryPVO | HZ_PARTIES, PER_PERSON_NAMES_F_V, PO_ACTION_HISTORY | reference / config |
| PurchasingDocumentChecklistPVO | oracle.apps.prc.po.publicView.analytics.PurchasingDocumentChecklistPVO | PER_PERSON_NAMES_F_V, POQ_INITIATIVES | reference / config |
| PurchasingLineTypeTranslationPVO | oracle.apps.prc.po.publicView.analytics.PurchasingLineTypeTranslationPVO | PO_LINE_TYPES_TL | reference / config |
| PurchasingSpecialHandlingTypeBPVO | oracle.apps.prc.po.publicView.analytics.PurchasingSpecialHandlingTypeBPVO | PO_SPCL_HANDLING_TYPES_B, PO_SPCL_HANDLING_TYPES_TL | reference / config |
| POITaxonomyDataPVO | oracle.apps.prc.poi.publicView.analytics.POITaxonomyDataPVO | POI_TAXONOMY_DATA | reference / config |
| NegotiationResponseCostFactorPVO | oracle.apps.prc.pon.publicView.analytics.NegotiationResponseCostFactorPVO | PON_BID_PRICE_ELEMENTS, PON_PRICE_ELEMENTS, PON_PRICE_ELEMENT_TYPES_VL | reference / config |
| NegotiationSupplierActivityPVO | oracle.apps.prc.pon.publicView.analytics.NegotiationSupplierActivityPVO | HZ_PARTIES, PON_SUPPLIER_ACTIVITIES, POZ_SUPPLIERS_V | reference / config |
| SourcingCostFactorPVO | oracle.apps.prc.pon.publicView.analytics.SourcingCostFactorPVO | PON_PRICE_ELEMENTS, PON_PRICE_ELEMENT_TYPES_VL | reference / config |
| SourcingObjectiveNegotiationPVO | oracle.apps.prc.pon.publicView.analytics.SourcingObjectiveNegotiationPVO | EGP_CATEGORIES_VL, FND_LOOKUPS, GL_DAILY_CONVERSION_TYPES | reference / config |
| SourcingProgramHeaderPVO | oracle.apps.prc.pon.publicView.analytics.SourcingProgramHeaderPVO | EGP_CATEGORIES_VL, FND_LOOKUPS, GL_DAILY_CONVERSION_TYPES | reference / config |
| SourcingProgramObjectivePVO | oracle.apps.prc.pon.publicView.analytics.SourcingProgramObjectivePVO | EGP_CATEGORIES_VL, FND_LOOKUPS, GL_DAILY_CONVERSION_TYPES | reference / config |
| SourcingProgramTeamMemberPVO | oracle.apps.prc.pon.publicView.analytics.SourcingProgramTeamMemberPVO | PER_PERSON_NAMES_F_V, PON_PROGRAM_TEAM_MEMBERS | reference / config |
| AssessmentQualPVO | oracle.apps.prc.poq.publicView.analytics.AssessmentQualPVO | POQ_ASSESSMENT_QUALS | reference / config |
| QuestionScorePVO | oracle.apps.prc.poq.publicView.analytics.QuestionScorePVO | POQ_QUESTION_SCORES | reference / config |
| RespRepositorySurveyValuesPVO | oracle.apps.prc.poq.publicView.analytics.RespRepositorySurveyValuesPVO | PER_PERSON_NAMES_F_V, POQ_ALL_SURVEY_RESPONSES_V, POQ_QUESTIONS_VL | reference / config |
| SupplierEligibilityHistoryPVO | oracle.apps.prc.poq.publicView.analytics.SupplierEligibilityHistoryPVO | POQ_SUPPLIER_ELIG_HISTORY | reference / config |
| SupplierEligibilityPVO | oracle.apps.prc.poq.publicView.analytics.SupplierEligibilityPVO | POQ_ALL_BU_SUPP_ELIGIBILITY_V | reference / config |
| SupplierQualificationModelOutcomesPVO | oracle.apps.prc.poq.publicView.analytics.SupplierQualificationModelOutcomesPVO | POQ_QUAL_MODEL_OUTCOMES | reference / config |
| DataFoxScoringCriteriaPVO | oracle.apps.prc.poz.publicView.analytics.DataFoxScoringCriteriaPVO | poz_df_scoring_criteria | reference / config |
| SupplierAccessibleSitePVO | oracle.apps.prc.poz.publicView.analytics.SupplierAccessibleSitePVO | POZ_SUPP_ACCESS_SITES_V | reference / config |
| SupplierDeniedPartiesPVO | oracle.apps.prc.poz.publicView.analytics.SupplierDeniedPartiesPVO | POZ_SUPPLIERS_DENIED_PARTIES | reference / config |
| SupplierProfileChangeApprovalHistoryPVO | oracle.apps.prc.poz.publicView.analytics.SupplierProfileChangeApprovalHistoryPVO | FND_LOOKUPS, HZ_PARTIES, PER_PERSON_NAMES_F_V | reference / config |
| SupplierProfileChangeRequestPVO | oracle.apps.prc.poz.publicView.analytics.SupplierProfileChangeRequestPVO | FND_LOOKUPS, HZ_PARTIES, PER_PERSON_NAMES_F_V | reference / config |
| SupplierRegDeniedPartiesPVO | oracle.apps.prc.poz.publicView.analytics.SupplierRegDeniedPartiesPVO | POZ_REG_DENIED_PARTIES | reference / config |
| ActValidationMessagePVO | oracle.apps.prc.sus.publicmodel.view.ActValidationMessagePVO | SUS_ACT_VALIDATION_MESSAGES_V | reference / config |
| ActivityPVO | oracle.apps.prc.sus.publicmodel.view.ActivityPVO | SUS_ACTIVITIES_V, SUS_PERIOD_STATUSES_V | reference / config |
| EmissionPVO | oracle.apps.prc.sus.publicmodel.view.EmissionPVO | SUS_ACTIVITIES_V, SUS_ACTIVITY_EMISSIONS_V, SUS_ACTIVITY_MEASURES_V | reference / config |
| MeasurePVO | oracle.apps.prc.sus.publicmodel.view.MeasurePVO | SUS_ACTIVITIES_V, SUS_ACTIVITY_MEASURES_V, SUS_PERIOD_STATUSES_V | reference / config |
| SustainabilityLedgerPVO | oracle.apps.prc.sus.publicmodel.view.SustainabilityLedgerPVO | GL_CALENDARS, SUS_LEDGERS | reference / config |
| ItemSupplierAttachmentsPVO | oracle.apps.scm.productHub.itemImport.batches.publicView.analytics.ItemSupplierAttachmentsPVO | EGP_ITEM_ATTACHMENTS_INTF | reference / config |
| ItemSupplierBatchPVO | oracle.apps.scm.productHub.itemImport.batches.publicView.analytics.ItemSupplierBatchPVO | EGP_SYSTEM_ITEMS_INTERFACE | reference / config |
| ItemSupplierStagePVO | oracle.apps.scm.productHub.itemImport.batches.publicView.analytics.ItemSupplierStagePVO | EGP_SYSTEM_ITEMS_INTERFACE | reference / config |
| ItemSupplierAssociationPVO | oracle.apps.scm.productModel.items.publicView.analytics.ItemSupplierAssociationPVO | EGO_ITEM_ASSOCIATIONS | reference / config |
| PurchaseOrderInfoPVO | oracle.apps.scm.receiptAccounting.reviewAccounting.publicView.analytics.PurchaseOrderInfoPVO | CMR_PURCHASE_ORDER_INFO_V | reference / config |
| SupplierReturnLinePVO | oracle.apps.scm.receiving.receipts.publicView.analytics.SupplierReturnLinePVO | RCV_SUPPLIER_RETURN_HEADERS, RCV_SUPPLIER_RETURN_LINES | reference / config |
Product & Items / 45 PVOs
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| ItemCategoriesPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.ItemCategoriesPVO | MSC_ANALYTIC_ITEMS | reference / config |
| ChangeActionsBIPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.ChangeActionsBIPVO | EGO_CHANGE_ACTIONS_VL, EGO_CHANGE_LINES_B, EGO_CHANGE_LINES_TL | reference / config |
| ChangeAuditPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.ChangeAuditPVO | EGO_CHANGE_AUDIT_ENTITIES, EGO_CHANGE_AUDIT_REDLINE_ATTRS, EGO_ENGINEERING_CHANGES_B | reference / config |
| ChangeObjectTLPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.ChangeObjectTLPVO | EGO_ENGINEERING_CHANGES_TL | reference / config |
| ChangeOrderApprovalsPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.ChangeOrderApprovalsPVO | EGO_CHANGE_LINES_B, EGO_CHANGE_LINES_TL, EGO_CHANGE_STATUSES_B | reference / config |
| ChangeRelationshipRulesPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.ChangeRelationshipRulesPVO | ACA_CS_REL_RULES | reference / config |
| ChangeRelationshipsPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.ChangeRelationshipsPVO | EGO_CHANGE_LINES_B, EGO_CHANGE_LINES_TL, EGO_CHANGE_RELATIONSHIPS_VL | reference / config |
| NIRWorkDefinitionDetailsPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.NIRWorkDefinitionDetailsPVO | EGO_CHANGE_LINES_B, EGO_CHANGE_LINES_TL, EGO_CHANGE_STATUSES_B | reference / config |
| SCMBpmApprovalTaskAttachmentPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.SCMBpmApprovalTaskAttachmentPVO | FND_BPM_TASK_ATTACHMENT | reference / config |
| SCMBpmApprovalTaskCommentsPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.SCMBpmApprovalTaskCommentsPVO | FND_BPM_TASK_COMMENT | reference / config |
| SCMBpmApprovalTaskDimPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.SCMBpmApprovalTaskDimPVO | EGO_ENGINEERING_CHANGES_B, EGO_ENGINEERING_CHANGES_TL | reference / config |
| SCMBpmApprovalTaskPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.SCMBpmApprovalTaskPVO | EGO_ENGINEERING_CHANGES_B, FND_BPM_TASK_ASSIGNEE, FND_BPM_TASK_HISTORY_VL | reference / config |
| UserRolesPVO | oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.publicView.analytics.UserRolesPVO | PER_ROLES_DN_VL | reference / config |
| EgoChangeTypesTLPVO | oracle.apps.scm.productCatalogManagement.changeManagement.types.publicView.analytics.EgoChangeTypesTLPVO | EGO_CHANGE_TYPES_TL | reference / config |
| CatalogCategoryItemPVO | oracle.apps.scm.productModel.catalogs.publicView.analytics.CatalogCategoryItemPVO | EGP_FLATTENED_VALID_CATS_VL, EGP_ITEM_CATEGORIES | reference / config |
| CategoryHierarchyPVO | oracle.apps.scm.productModel.catalogs.publicView.analytics.CategoryHierarchyPVO | EGP_FLATTENED_VALID_CATS_VL | reference / config |
| CategoryPVO | oracle.apps.scm.productModel.catalogs.publicView.analytics.CategoryPVO | EGP_CATEGORIES_B, EGP_CATEGORIES_TL | reference / config |
| CategorySetsPVO | oracle.apps.scm.productModel.catalogs.publicView.analytics.CategorySetsPVO | EGP_CATEGORY_SETS_B, EGP_CATEGORY_SETS_TL | reference / config |
| CategoryTLPVO | oracle.apps.scm.productModel.catalogs.publicView.analytics.CategoryTLPVO | EGP_CATEGORIES_TL | reference / config |
| CategoryTranslationPVO | oracle.apps.scm.productModel.catalogs.publicView.analytics.CategoryTranslationPVO | EGP_CATEGORIES_VL | reference / config |
| ItemCatalogTLPVO | oracle.apps.scm.productModel.catalogs.publicView.analytics.ItemCatalogTLPVO | EGP_CATEGORY_SETS_TL | reference / config |
| UNNumberHazardClassVO | oracle.apps.scm.productModel.items.protectedModel.common.view.UNNumberHazardClassVO | PO_UN_NUMBERS_VL | reference / config |
| ItemCostAttributesPVO | oracle.apps.scm.productModel.items.publicView.analytics.ItemCostAttributesPVO | ACA_PD_ITEM_COST | reference / config |
| ItemCostMasterOrgLevelAttributesPVO | oracle.apps.scm.productModel.items.publicView.analytics.ItemCostMasterOrgLevelAttributesPVO | ACA_PD_ITEM_COST | reference / config |
| ItemCostOrgLevelAttributesPVO | oracle.apps.scm.productModel.items.publicView.analytics.ItemCostOrgLevelAttributesPVO | ACA_PD_ITEM_COST | reference / config |
| ItemImageAttachmentsPVO | oracle.apps.scm.productModel.items.publicView.analytics.ItemImageAttachmentsPVO | FND_ATTACHED_DOCUMENTS, FND_DOCUMENTS_VL | reference / config |
| ItemRevisionPVO | oracle.apps.scm.productModel.items.publicView.analytics.ItemRevisionPVO | EGP_ITEM_REVISIONS_B_V, EGP_ITEM_REVISIONS_TL_V | reference / config |
| MpnRelationshipLinkagePVO | oracle.apps.scm.productModel.items.publicView.analytics.MpnRelationshipLinkagePVO | EGP_ITEM_RELATIONSHIPS_B_V, EGP_MPN_SPN_REL_LINKAGE, EGP_TRADING_PARTNER_ITEMS | reference / config |
| PartySitePVO | oracle.apps.scm.productModel.items.publicView.analytics.PartySitePVO | HZ_LOCATIONS, HZ_PARTY_SITES | reference / config |
| SpnRelationshipLinkagePVO | oracle.apps.scm.productModel.items.publicView.analytics.SpnRelationshipLinkagePVO | EGP_ITEM_RELATIONSHIPS_B_V, EGP_MPN_SPN_REL_LINKAGE, EGP_TRADING_PARTNER_ITEMS | reference / config |
| ConditionPVO | oracle.apps.scm.productModel.securityACL.publicView.analytics.ConditionPVO | HR_VBCS_LISTS | reference / config |
| PermissionSetPVO | oracle.apps.scm.productModel.securityACL.publicView.analytics.PermissionSetPVO | EGP_DS_PERMISSIONS, EGP_DS_PERMISSION_SETS_VL | reference / config |
| TeamFilteredListsPVO | oracle.apps.scm.productModel.securityACL.publicView.analytics.TeamFilteredListsPVO | HR_VBCS_LISTS | reference / config |
| TeamMemberPVO | oracle.apps.scm.productModel.securityACL.publicView.analytics.TeamMemberPVO | EGP_DS_TEAM_MEMBERS, PER_EMAIL_ADDRESSES, PER_USERS | reference / config |
| TeamPVO | oracle.apps.scm.productModel.securityACL.publicView.analytics.TeamPVO | EGP_DS_TEAMS_VL, PER_ROLES_DN_VL | reference / config |
| ChangeOrderPVO | oracle.apps.scm.productModel.structures.publicView.analytics.ChangeOrderPVO | EGO_ENGINEERING_CHANGES_B, EGO_ENGINEERING_CHANGES_TL, FND_LOOKUPS | reference / config |
| ItemAttachmentCategoriesPVO | oracle.apps.scm.productModel.structures.publicView.analytics.ItemAttachmentCategoriesPVO | FND_DOCUMENT_CATEGORIES_VL | reference / config |
| ItemAttachmentsPVO | oracle.apps.scm.productModel.structures.publicView.analytics.ItemAttachmentsPVO | FND_ATTACHED_DOCUMENTS, FND_DOCUMENTS_VL | reference / config |
| ItemRevisionAttachmentsPVO | oracle.apps.scm.productModel.structures.publicView.analytics.ItemRevisionAttachmentsPVO | FND_ATTACHED_DOCUMENTS, FND_DOCUMENTS_VL, FND_DOCUMENT_ENTITIES_VL | reference / config |
| PendingChangeOrderListPVO | oracle.apps.scm.productModel.structures.publicView.analytics.PendingChangeOrderListPVO | EGO_PENDING_CO_LIST_V | reference / config |
| ReleasedChangeOrderListPVO | oracle.apps.scm.productModel.structures.publicView.analytics.ReleasedChangeOrderListPVO | EGO_RELEASED_CO_LIST_V | reference / config |
| StructureExplosionStgPVO | oracle.apps.scm.productModel.structures.publicView.analytics.StructureExplosionStgPVO | ACA_STRUCTURE_EXPL_STAGING, EGP_COMPONENTS_B, EGP_STRUCTURES_B | reference / config |
| StructureImplosionStgPVO | oracle.apps.scm.productModel.structures.publicView.analytics.StructureImplosionStgPVO | ACA_STRUCTURE_IMPL_STAGING | reference / config |
| StructureRefDesignatorPVO | oracle.apps.scm.productModel.structures.publicView.analytics.StructureRefDesignatorPVO | ACA_STRUCTURE_REF_DESIGNATOR_V | reference / config |
| SubstituteComponentsPVO | oracle.apps.scm.productModel.structures.publicView.analytics.SubstituteComponentsPVO | EGP_SUBSTITUTE_COMPONENTS | reference / config |
Quality & Planning / 42 PVOs
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| PlanningConfigureToOrderPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanningConfigureToOrderPVO | MSC_ANALYTIC_FACT_CTO_V | reference / config |
| PlanningCustomerPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanningCustomerPVO | MSC_ANALYTIC_CUST_FLAT_V_DYD | reference / config |
| PlanningDatePVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanningDatePVO | MSC_ANALYTIC_CALENDARS_V | reference / config |
| PlanningDemandMangementPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanningDemandMangementPVO | MSC_ANALYTIC_FACT_DM_V | reference / config |
| PlanningExceptionPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanningExceptionPVO | MSC_ANALYTIC_FACT_EXP, MSC_EXCEPTION_VL | reference / config |
| PlanningInventoryAnalysisReplPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanningInventoryAnalysisReplPVO | MSC_ANALYTIC_FACT_INV_REPL_V | reference / config |
| PlanningOrganizationPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanningOrganizationPVO | MSC_ANALYTIC_ORG_FLAT_V_DYD | reference / config |
| PlanningPeggingPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanningPeggingPVO | MSC_ANALYTIC_FACT_PEG_V | reference / config |
| PlanningResourcePVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanningResourcePVO | MSC_ANALYTIC_RES_FLAT_V_DYD | reference / config |
| PlanningSupplierPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanningSupplierPVO | MSC_ANALYTIC_SUP_FLAT_V_DYD | reference / config |
| OverheadRateDetailsPVO | oracle.apps.scm.costing.costPlanning.resourceRatePlans.publicView.analytics.OverheadRateDetailsPVO | CST_STD_OVERHEAD_RATES, CST_STD_OVERHEAD_RATE_DETAILS | reference / config |
| ResourceRateDetailsPVO | oracle.apps.scm.costing.costPlanning.resourceRatePlans.publicView.analytics.ResourceRateDetailsPVO | CST_STD_RESOURCE_RATES, CST_STD_RESOURCE_RATE_DETAILS | reference / config |
| CstRollupReportsPVO | oracle.apps.scm.costing.costPlanning.scenarios.publicView.analytics.CstRollupReportsPVO | CST_ROLLUP_REPORTS, CST_ROLLUP_REPORT_KEYS, CST_STD_OVERHEAD_RATES | reference / config |
| CstScenariosPVO | oracle.apps.scm.costing.costPlanning.scenarios.publicView.analytics.CstScenariosPVO | CST_SCENARIOS | reference / config |
| CstSourcingRulesPVO | oracle.apps.scm.costing.costPlanning.scenarios.publicView.analytics.CstSourcingRulesPVO | CST_MSC_SOURCING_RULES, CST_SCENARIO_ROLLUP_SOURCES | reference / config |
| CstTransferChargeRuleSetsPVO | oracle.apps.scm.costing.costPlanning.scenarios.publicView.analytics.CstTransferChargeRuleSetsPVO | CST_STD_TXFR_COST_RULE_SETS | reference / config |
| IndentedRollupDetailPVO | oracle.apps.scm.costing.costPlanning.scenarios.publicView.analytics.IndentedRollupDetailPVO | CST_COSTED_VU_ONHAND_V, CST_INDENTED_ROLLUP_DETAILS_V, CST_ROLLUP_DET_OTBI_V | reference / config |
| ScenarioEventPVO | oracle.apps.scm.costing.costPlanning.scenarios.publicView.analytics.ScenarioEventPVO | CST_SCENARIO_EVENTS, CST_SCENARIO_EVENT_MESSAGES | reference / config |
| WhereUsedRollupDetailPVO | oracle.apps.scm.costing.costPlanning.scenarios.publicView.analytics.WhereUsedRollupDetailPVO | CST_COSTED_VU_ONHAND_V, CST_ROLLUP_DET_OTBI_V, CST_STD_OVERHEAD_RATES | reference / config |
| QualityActionRelationshipPVO | oracle.apps.scm.enterpriseQualityManagement.actions.publicView.analytics.QualityActionRelationshipPVO | ACA_CS_REL_RULES, ENQ_ACTIONS_VL, ENQ_ACTION_RELATIONSHIP_V | reference / config |
| QualityActionsRefPVO | oracle.apps.scm.enterpriseQualityManagement.actions.publicView.analytics.QualityActionsRefPVO | ENQ_ACTIONS_B, ENQ_ACTIONS_TL | reference / config |
| QualityAffectedObjectsActionsPVO | oracle.apps.scm.enterpriseQualityManagement.actions.publicView.analytics.QualityAffectedObjectsActionsPVO | ENQ_ACTIONS_B, ENQ_ACTIONS_TL, ENQ_AFFECTED_OBJECTS_B | reference / config |
| QualityTypePVO | oracle.apps.scm.enterpriseQualityManagement.common.publicView.analytics.QualityTypePVO | ENQ_QUALITY_TYPES_VL | reference / config |
| QualityTypeSubTypesPVO | oracle.apps.scm.enterpriseQualityManagement.common.publicView.analytics.QualityTypeSubTypesPVO | ENQ_QUALITY_TYPES_SUBTYPES_V | reference / config |
| WorkflowStatusPVO | oracle.apps.scm.enterpriseQualityManagement.common.publicView.analytics.WorkflowStatusPVO | ENQ_WORKFLOW_OTBI_VL | reference / config |
| QualityAffectedObjectsPVO | oracle.apps.scm.enterpriseQualityManagement.issues.publicView.analytics.QualityAffectedObjectsPVO | ENQ_AFFECTED_OBJECTS_B, ENQ_ISSUES_B, ENQ_ISSUES_TL | reference / config |
| QualityIssuesRefPVO | oracle.apps.scm.enterpriseQualityManagement.issues.publicView.analytics.QualityIssuesRefPVO | ENQ_ISSUES_B, ENQ_ISSUES_TL | reference / config |
| QualityRelationshipPVO | oracle.apps.scm.enterpriseQualityManagement.issues.publicView.analytics.QualityRelationshipPVO | ACA_CS_REL_RULES, ENQ_ISSUES_VL, ENQ_ISSUE_RELATIONSHIP_V | reference / config |
| InspectionLevelsPVO | oracle.apps.scm.qualityInspection.levels.model.publicView.analytics.InspectionLevelsPVO | QA_INSPECTION_LEVELS_B, QA_INSPECTION_LEVELS_TL | reference / config |
| CharactersticTLPVO | oracle.apps.scm.qualityInspection.requirements.plans.model.publicView.analytics.CharactersticTLPVO | QA_CHARACTERISTICS_TL | reference / config |
| InspectionPlansPVO | oracle.apps.scm.qualityInspection.requirements.plans.model.publicView.analytics.InspectionPlansPVO | QA_INSPECTION_PLANS_B, QA_INSPECTION_PLANS_TL | reference / config |
| IpSpecificationsPVO | oracle.apps.scm.qualityInspection.requirements.plans.model.publicView.analytics.IpSpecificationsPVO | QA_CHARACTERISTICS_TL, QA_IP_SPECIFICATIONS | reference / config |
| EventDispositionPVO | oracle.apps.scm.qualityInspection.results.model.publicView.analytics.EventDispositionPVO | PER_PERSON_NAMES_F_V, QA_IP_EVENTS, QA_IP_EVENT_DISPOSITIONS | reference / config |
| InspectionEventsPVO | oracle.apps.scm.qualityInspection.results.model.publicView.analytics.InspectionEventsPVO | PER_PERSON_NAMES_F_V, QA_IP_EVENTS | reference / config |
| ResultEvaluationPVO | oracle.apps.scm.qualityInspection.results.model.publicView.analytics.ResultEvaluationPVO | PER_PERSON_NAMES_F_V, QA_IP_EVENTS, QA_IP_EVENT_DISPOSITIONS | reference / config |
| SampleResultsPVO | oracle.apps.scm.qualityInspection.results.model.publicView.analytics.SampleResultsPVO | PER_PERSON_NAMES_F_V, QA_IP_EVENTS, QA_SAMPLES | reference / config |
| SampleResultsRefPVO | oracle.apps.scm.qualityInspection.results.model.publicView.analytics.SampleResultsRefPVO | PER_PERSON_NAMES_F_V, QA_IP_EVENTS, QA_SAMPLE_RESULTS | reference / config |
| SamplesPVO | oracle.apps.scm.qualityInspection.results.model.publicView.analytics.SamplesPVO | PER_PERSON_NAMES_F_V, QA_IP_EVENTS, QA_SAMPLES | reference / config |
| SCPlanningSchedDetailsCurrentPVO | oracle.apps.scm.supplyCollaboration.common.publicView.analytics.SCPlanningSchedDetailsCurrentPVO | VCS_BUCKETS, VCS_COLLAB_ENT, VCS_MNGD_EXCEPTIONS_V | reference / config |
| SCPlanningSchedDetailsHistPVO | oracle.apps.scm.supplyCollaboration.common.publicView.analytics.SCPlanningSchedDetailsHistPVO | VCS_BUCKETS, VCS_COLLAB_ENT_HIST, VCS_MNGD_EXCEPTIONS_HIST_V | reference / config |
| SCPreviousPlanningSchedDetailsCurrentPVO | oracle.apps.scm.supplyCollaboration.common.publicView.analytics.SCPreviousPlanningSchedDetailsCurrentPVO | VCS_PLANNING_SCH_DETAILS | reference / config |
| SCPreviousPlanningSchedDetailsHistPVO | oracle.apps.scm.supplyCollaboration.common.publicView.analytics.SCPreviousPlanningSchedDetailsHistPVO | VCS_PLANNING_SCH_DETAILS_HIST | reference / config |
Reference & setup data / 28 PVOs
Shared reference and setup objects — currencies, calendars, geographies, lookups, and flexfields — that feed conformed dimensions across every module. Extracted once and reused; not tied to a single fact, but needed to make the others join and label correctly.
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| CrmFiscalDayPVO | oracle.apps.crm.publicView.analytics.CrmFiscalDayPVO | ZCA_BI_CRM_CALENDAR | reference / config |
| CrmFiscalPeriodPVO | oracle.apps.crm.publicView.analytics.CrmFiscalPeriodPVO | ZCA_BI_CRM_CAL_PERIOD | reference / config |
| CrmFiscalQuarterPVO | oracle.apps.crm.publicView.analytics.CrmFiscalQuarterPVO | ZCA_BI_CRM_CAL_QUARTER | reference / config |
| FiscalQuarterPVO | oracle.apps.financials.generalLedger.calendars.accounting.publicView.analytics.FiscalQuarterPVO | GL_CALENDARS, GL_FISCAL_QUARTER_V, GL_FISCAL_YEAR_V | reference / config |
| FiscalYearPVO | oracle.apps.financials.generalLedger.calendars.accounting.publicView.analytics.FiscalYearPVO | GL_CALENDARS, GL_FISCAL_YEAR_V | reference / config |
| DailyRatePVO | oracle.apps.financials.generalLedger.currencies.manageRate.publicView.analytics.DailyRatePVO | GL_DAILY_RATES | reference / config |
| GlAcctFlexBICPVO | oracle.apps.financials.generalLedger.shared.flexfield.publicView.GlAcctFlexBICPVO | FND_VS_TYPED_VALUES_VL, GL_SEG_VAL_HIER_CF | reference / config |
| CurrenciesTLPVO | oracle.apps.fnd.applcore.analytics.model.publicView.CurrenciesTLPVO | FND_CURRENCIES_TL | reference / config |
| MessagesTLPVO | oracle.apps.fnd.applcore.analytics.model.publicView.MessagesTLPVO | FND_MESSAGES_TL | reference / config |
| TerritoriesPVO | oracle.apps.fnd.applcore.analytics.model.publicView.TerritoriesPVO | FND_TERRITORIES_B, FND_TERRITORIES_TL | reference / config |
| OrgTreeBICVO | oracle.apps.fnd.applcore.trees.bi.model.view.OrgTreeBICVO | FND_TREE_VERSION_VL, FND_TREE_VL | reference / config |
| OrgTreeBIRVO | oracle.apps.fnd.applcore.trees.bi.model.view.OrgTreeBIRVO | FND_TREE_VL, HR_ORGANIZATION_UNITS_F_TL, PER_ORG_TREE_NODE_RF | reference / config |
| SrLookupValuesTranslationPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.SrLookupValuesTranslationPVO | MSC_SR_LOOKUP_VALUES_TL | reference / config |
| RMCSFiscalDayPVO | oracle.apps.grc.GRC.Compliance.publicView.analytics.RMCSFiscalDayPVO | GL_CALENDARS, GL_FISCAL_DAY_V | reference / config |
| HRLocationsBasePVO | oracle.apps.hcm.location.publicView.analytics.HRLocationsBasePVO | PER_LOCATION_DETAILS_F_TL | reference / config |
| ManagerHrchyBottomUpPVO | oracle.apps.hcm.managerHierarchy.publicView.analytics.ManagerHrchyBottomUpPVO | PER_PERSON_NAMES_F_V | reference / config |
| EmailAddressesPVO | oracle.apps.hcm.person.publicView.analytics.EmailAddressesPVO | PER_EMAIL_ADDRESSES | reference / config |
| PersonNamePVO | oracle.apps.hcm.person.publicView.analytics.PersonNamePVO | PER_ALL_PEOPLE_F, PER_PERSON_NAMES_F_V | reference / config |
| PersonTypesTranslationPVO | oracle.apps.hcm.person.publicView.analytics.PersonTypesTranslationPVO | PER_PERSON_TYPES_TL | reference / config |
| PhonesPVO | oracle.apps.hcm.person.publicView.analytics.PhonesPVO | PER_PHONES | reference / config |
| POITxnmySegLookupPVO | oracle.apps.prc.poi.publicView.analytics.POITxnmySegLookupPVO | POI_TXNMY_SEG_LOOKUP | reference / config |
| NegotiationStyleDocumentTypeVLPVO | oracle.apps.prc.pon.publicView.analytics.NegotiationStyleDocumentTypeVLPVO | PON_DOCTYPE_STYLES_VL | reference / config |
| PonSupplierActivityNegotiationLookupPVO | oracle.apps.prc.pon.publicView.analytics.PonSupplierActivityNegotiationLookupPVO | FND_LOOKUPS | reference / config |
| WrkFlowLookupPVO | oracle.apps.scm.enterpriseQualityManagement.common.publicView.analytics.WrkFlowLookupPVO | ACA_WF_STATUS_VL | reference / config |
| MessageCategoryLookupPVO | oracle.apps.scm.fos.orchestrationProcesses.publicView.analytics.MessageCategoryLookupPVO | FND_LOOKUP_VALUES_TL | reference / config |
| TransactionEventMessagesPVO | oracle.apps.scm.fos.orchestrationProcesses.publicView.analytics.TransactionEventMessagesPVO | FOS_PROCESS_MESSAGES | reference / config |
| TransactionTaskMessagesPVO | oracle.apps.scm.fos.orchestrationProcesses.publicView.analytics.TransactionTaskMessagesPVO | FOS_PROCESS_MESSAGES | reference / config |
| PIMLookupsPVO | oracle.apps.scm.productHub.itemImport.batches.publicView.analytics.PIMLookupsPVO | FND_LOOKUPS | reference / config |
Other / 66 PVOs
Less common or cross-functional view objects that don't map cleanly to one module. Most extracts won't need these — listed for completeness.
| PVO | Fully-qualified name | Database tables | Feeds star |
|---|---|---|---|
| NotePVO | oracle.apps.crmCommon.notes.publicView.analytics.NotePVO | HZ_PARTIES, ZMM_NOTES | reference / config |
| InvoiceDistributionAppliedPVO | oracle.apps.financials.payables.invoices.transactions.publicView.analytics.InvoiceDistributionAppliedPVO | AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALL | reference / config |
| InvoiceLineAppliedPVO | oracle.apps.financials.payables.invoices.transactions.publicView.analytics.InvoiceLineAppliedPVO | AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, FA_BOOK_CONTROLS | reference / config |
| TransactionBizCategoriesPVO | oracle.apps.financials.receivables.publicView.analytics.TransactionBizCategoriesPVO | ZX_FC_BUSINESS_CATEGORIES_V | reference / config |
| EndDemandPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.EndDemandPVO | MSC_ANALYTIC_END_DEMANDS | reference / config |
| PlanPVO | oracle.apps.fscm.msc.common.analytics.publicModel.otbi.view.PlanPVO | MSC_ANALYTIC_PRIVATE_PLAN_V | reference / config |
| OrganizationRefPVO | oracle.apps.hcm.organization.publicView.analytics.OrganizationRefPVO | HR_ORGANIZATION_UNITS_F_TL | reference / config |
| OrganizationUnitPVO | oracle.apps.hcm.organization.publicView.analytics.OrganizationUnitPVO | HR_ALL_ORGANIZATION_UNITS_F, HR_ORGANIZATION_UNITS_F_TL | reference / config |
| RatingLevelFirstPVO | oracle.apps.hcm.profiles.contentLibrary.publicView.analytics.RatingLevelFirstPVO | HRT_RATING_LEVELS_TL | reference / config |
| RatingModelFirstPVO | oracle.apps.hcm.profiles.contentLibrary.publicView.analytics.RatingModelFirstPVO | HRT_RATING_MODELS_TL | reference / config |
| GenericProfilePVO | oracle.apps.hcm.profiles.core.publicView.analytics.GenericProfilePVO | HRT_PROFILES_B, HRT_PROFILES_TL, HRT_PROFILE_ITEMS | reference / config |
| ProfileTypePVO | oracle.apps.hcm.profiles.setup.publicView.analytics.ProfileTypePVO | HRT_PROFILE_TYPES_TL | reference / config |
| FundingSourcePVO | oracle.apps.projects.grantsManagement.setup.publicView.analytics.FundingSourcePVO | GMS_FUNDING_SOURCES_B, GMS_FUNDING_SOURCES_TL, GMS_LOOKUPS | reference / config |
| ProjectPlanIntegrationPVO | oracle.apps.projects.projectManagement.projectPlan.publicView.analytics.ProjectPlanIntegrationPVO | PJE_OBJECT_ASSOCIATIONS, PJF_PROJ_ELEMENTS_B, PJT_PROJ_PLAN_LINES | reference / config |
| AssetGroupMembersDetailPVO | oracle.apps.scm.assetTracking.assetGroups.publicView.analytics.AssetGroupMembersDetailPVO | CSE_GROUPING_VALUES, CSE_GROUPS_B, CSE_GROUPS_TL | reference / config |
| AssetGroupRulePVO | oracle.apps.scm.assetTracking.assetGroups.publicView.analytics.AssetGroupRulePVO | CSE_GROUP_RULES_B, CSE_GROUP_RULES_TL, CSE_GROUP_RULE_USAGES | reference / config |
| AssetGroupsDetailPVO | oracle.apps.scm.assetTracking.assetGroups.publicView.analytics.AssetGroupsDetailPVO | CSE_GROUPING_VALUES, CSE_GROUPS_B, CSE_GROUPS_TL | reference / config |
| MeterReadingPVO | oracle.apps.scm.assetTracking.meterManagement.publicView.analytics.MeterReadingPVO | CSE_METERS, CSE_METER_DEFINITIONS_B, CSE_METER_DEFINITIONS_TL | reference / config |
| KanbanActivityPVO | oracle.apps.scm.commonWorkExecution.kanbanActivity.publicView.analytics.KanbanActivityPVO | WIE_KANBAN_CARD_ACTIVITY, WIS_KANBAN_CARDS, WIS_KANBAN_PULL_SEQUENCES | reference / config |
| KanbanCardPVO | oracle.apps.scm.commonWorkExecution.kanbanActivity.publicView.analytics.KanbanCardPVO | WIS_KANBAN_CARDS, WIS_KANBAN_PULL_SEQUENCES | reference / config |
| KanbanPullSequencePVO | oracle.apps.scm.commonWorkExecution.kanbanActivity.publicView.analytics.KanbanPullSequencePVO | WIS_KANBAN_PULL_SEQUENCES | reference / config |
| AssignedOperatorsPVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.AssignedOperatorsPVO | HZ_PARTIES, WIE_WS_CHECKIN_ACTIVITIES, WIE_WS_OPERATOR_ASSIGNMENTS | reference / config |
| ShiftPVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.ShiftPVO | ZMM_SR_SHIFTS_B, ZMM_SR_SHIFTS_TL | reference / config |
| WorkAreaPVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.WorkAreaPVO | WIS_WORK_AREAS_B, WIS_WORK_AREAS_TL | reference / config |
| WorkAreaRefPVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.WorkAreaRefPVO | WIS_WORK_AREAS_B, WIS_WORK_AREAS_TL | reference / config |
| WorkCenterRefPVO | oracle.apps.scm.commonWorkSetup.workCenters.publicView.analytics.WorkCenterRefPVO | WIS_WC_SUB_INVENTORIES, WIS_WORK_AREAS_VL, WIS_WORK_CENTERS_B | reference / config |
| MntWorkDefinitionsPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.MntWorkDefinitionsPVO | WIS_WD_MAINTENANCE_NAMES_VL, WIS_WORK_DEFINITIONS | reference / config |
| MntWorkDefinitionsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.MntWorkDefinitionsRefPVO | WIS_WD_MAINTENANCE_NAMES_VL, WIS_WORK_DEFINITIONS | reference / config |
| WDMntEquipmentQualificationProfileRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDMntEquipmentQualificationProfileRefPVO | FUSION.MNT_EQP_QUAL_PROFILES_TL, FUSION.MNT_EQP_QUAL_REQS_B, FUSION.MNT_EQP_QUAL_REQS_TL | reference / config |
| WDStructureComponentDetailsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDStructureComponentDetailsRefPVO | EGP_COMPONENTS_B, EGP_SUBSTITUTE_COMPONENTS | reference / config |
| WDStructureDetailsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDStructureDetailsRefPVO | EGP_STRUCTURES_B | reference / config |
| WDWorkDefinitionVersionsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDWorkDefinitionVersionsRefPVO | WIS_WD_VERSIONS | reference / config |
| WDWorkDefinitionsPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDWorkDefinitionsPVO | WIS_WORK_DEFINITIONS | reference / config |
| WDWorkInstructionStepDetailsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDWorkInstructionStepDetailsRefPVO | WIS_WORK_INSTR_STEP_DETAILS_VL | reference / config |
| WDWorkInstructionStepsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WDWorkInstructionStepsRefPVO | WIS_WORK_INSTRUCTION_STEPS_VL | reference / config |
| WorkDefinitionsPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WorkDefinitionsPVO | WIS_WD_VERSIONS, WIS_WORK_DEFINITIONS, WIS_WORK_DEFINITION_NAMES_VL | reference / config |
| WorkDefinitionsRefPVO | oracle.apps.scm.commonWorkSetup.workDefinitions.publicView.analytics.WorkDefinitionsRefPVO | WIS_WD_VERSIONS, WIS_WORK_DEFINITIONS, WIS_WORK_DEFINITION_NAMES_VL | reference / config |
| FDInterfaceExceptionsPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocumentInterface.publicView.analytics.FDInterfaceExceptionsPVO | CMF_FD_EXCEPTIONS_INT, CMF_FD_HEADERS_INT, CMF_FD_LEGAL_PROCS_INT | reference / config |
| InterfaceFiscalDocumentPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocumentInterface.publicView.analytics.InterfaceFiscalDocumentPVO | CMF_FD_HEADERS_INT, CMF_FD_IN_CONVERT_CFOPS_V, CMF_FD_LEGAL_PROCS_INT | reference / config |
| FiscalDocAssoctnsPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocuments.publicView.analytics.FiscalDocAssoctnsPVO | CMF_FISCAL_DOC_ASSOCTNS_VL, CMF_FISCAL_PROC_OPTIONS | reference / config |
| FiscalDocEventLogPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocuments.publicView.analytics.FiscalDocEventLogPVO | CMF_FISCAL_DOC_EVENT_LOG, PER_PERSON_NAMES_F_V | reference / config |
| FiscalDocHeadersPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocuments.publicView.analytics.FiscalDocHeadersPVO | CMF_FD_LOC_INFO_PERSIST_OTBI_V, CMF_FISCAL_DOC_HEADERS, CMF_FISCAL_PROC_OPTIONS | reference / config |
| FiscalDocHoldsPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocuments.publicView.analytics.FiscalDocHoldsPVO | CMF_FD_IN_CONVERT_CFOPS_V, CMF_FD_LOC_INFO_PERSIST_OTBI_V, CMF_FD_OUT_ORIGIN_CFOPS_V | reference / config |
| FiscalDocReferenceAttrPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocuments.publicView.analytics.FiscalDocReferenceAttrPVO | CMF_FISCAL_DOC_HEADERS, CMF_FISCAL_DOC_REF_ATTRIBUTES, PER_PERSON_NAMES_F_V | reference / config |
| FiscalDocumentChargeAssocPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocuments.publicView.analytics.FiscalDocumentChargeAssocPVO | CMF_FD_IN_CONVERT_CFOPS_V, CMF_FD_LOC_INFO_PERSIST_OTBI_V, CMF_FD_OUT_ORIGIN_CFOPS_V | reference / config |
| FiscalDocumentLinesPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocuments.publicView.analytics.FiscalDocumentLinesPVO | CMF_FD_IN_CONVERT_CFOPS_V, CMF_FD_LOC_INFO_PERSIST_OTBI_V, CMF_FD_OUT_ORIGIN_CFOPS_V | reference / config |
| FiscalDocumentRcvChargeAllocsPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocuments.publicView.analytics.FiscalDocumentRcvChargeAllocsPVO | CMF_FD_IN_CONVERT_CFOPS_V, CMF_FD_LOC_INFO_PERSIST_OTBI_V, CMF_FD_OUT_ORIGIN_CFOPS_V | reference / config |
| FiscalDocumentSchedulesPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocuments.publicView.analytics.FiscalDocumentSchedulesPVO | CMF_FD_IN_CONVERT_CFOPS_V, CMF_FD_LOC_INFO_PERSIST_OTBI_V, CMF_FD_OUT_ORIGIN_CFOPS_V | reference / config |
| LegalDocumentAssocPVO | oracle.apps.scm.fiscalDocumentCapture.fiscalDocuments.publicView.analytics.LegalDocumentAssocPVO | CMF_LEGAL_DOC_ASSOCIATIONS, PER_PERSON_NAMES_F_V | reference / config |
| AgreementPVO | oracle.apps.scm.fos.orchestrationProcesses.publicView.analytics.AgreementPVO | FOS_AGREEMENT_DEFINITION_VL | reference / config |
| EventDefinitionPVO | oracle.apps.scm.fos.orchestrationProcesses.publicView.analytics.EventDefinitionPVO | FOS_EVENT_DEFINITIONS_VL | reference / config |
| OrchestrationPrimaryRoutePVO | oracle.apps.scm.fos.orchestrationProcesses.publicView.analytics.OrchestrationPrimaryRoutePVO | FOS_AGREEMENT_FTR_F, FOS_AGREEMENT_PTR_F, FUN_ALL_BUSINESS_UNITS_V | reference / config |
| QualifierRulePVO | oracle.apps.scm.fos.orchestrationProcesses.publicView.analytics.QualifierRulePVO | FOS_QUALIFIER_RULE_SET | reference / config |
| SourceTransactionEventPVO | oracle.apps.scm.fos.orchestrationProcesses.publicView.analytics.SourceTransactionEventPVO | FOS_SOURCE_EVENT_DOC_INFO, FOS_SOURCE_TXN_EVENTS, PJF_PROJECTS_ALL_VL | reference / config |
| TransactionEventPVO | oracle.apps.scm.fos.orchestrationProcesses.publicView.analytics.TransactionEventPVO | AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, FOS_DOC_FLOW_ASSIGNMENT | reference / config |
| TransferPricePVO | oracle.apps.scm.fos.orchestrationProcesses.publicView.analytics.TransferPricePVO | FOS_TRANSFER_PRICE_V | reference / config |
| SelProductsPortfolioPVO | oracle.apps.scm.productPortfolio.portfolios.publicView.analytics.SelProductsPortfolioPVO | ACE_PORTFOLIO_B, ACE_PORTFOLIO_TL | reference / config |
| AccrualClearingPVO | oracle.apps.scm.receiptAccounting.reviewAccounting.publicView.analytics.AccrualClearingPVO | CMR_ACCRUAL_CLEARING_INFO_V | reference / config |
| CmrAllPeriodCloseTxnsPVO | oracle.apps.scm.receiptAccounting.reviewAccounting.publicView.analytics.CmrAllPeriodCloseTxnsPVO | CMR_ALL_PERIOD_VALERR_TXNS_V, CMR_PERIOD_CLOSE_ACTIONS_V | reference / config |
| CmrApInvoiceDtlsPVO | oracle.apps.scm.receiptAccounting.reviewAccounting.publicView.analytics.CmrApInvoiceDtlsPVO | CMR_AP_INVOICE_DTLS | reference / config |
| CmrPeriodCloseActionsPVO | oracle.apps.scm.receiptAccounting.reviewAccounting.publicView.analytics.CmrPeriodCloseActionsPVO | CMR_PERIOD_CLOSE_ACTIONS_V | reference / config |
| CmrPoAccrualAmtsRptPVO | oracle.apps.scm.receiptAccounting.reviewAccounting.publicView.analytics.CmrPoAccrualAmtsRptPVO | CMR_PO_ACCRUAL_AMTS_RPT | reference / config |
| CmrTransactionsPVO | oracle.apps.scm.receiptAccounting.reviewAccounting.publicView.analytics.CmrTransactionsPVO | CMR_TRANSACTIONS | reference / config |
| ReceiptAccountingTxnPVO | oracle.apps.scm.receiptAccounting.reviewAccounting.publicView.analytics.ReceiptAccountingTxnPVO | AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALL | reference / config |
| SCCollaborationEntriesCurrentPVO | oracle.apps.scm.supplyCollaboration.common.publicView.analytics.SCCollaborationEntriesCurrentPVO | VCS_COLLAB_ENT, VCS_COLLAB_SOURCE, VCS_PLAN_SCENARIOS_TL | reference / config |
| SCCollaborationEntriesHistPVO | oracle.apps.scm.supplyCollaboration.common.publicView.analytics.SCCollaborationEntriesHistPVO | VCS_COLLAB_ENT_HIST, VCS_COLLAB_SOURCE, VCS_PLAN_SCENARIOS_TL | reference / config |