Oracle Fusion · OTBI subject area
Procurement - Purchasing Real Time
Free reference159 tables754 columnsSCM & Procurement
This is the OTBI subject area you select in Reports & Analytics to report on procurement data. It exposes the presentation columns mapped to the physical tables below.
OTBI limitation: you can't join two subject areas in a single analysis, and real-time queries hit the live transaction tables. The customer-owned warehouse removes both limits, every subject area is conformed on shared keys so you can join across them, and reporting runs off the warehouse, not production.
Physical tables in this subject area
- AP_INVOICE_LINES_ALL
- AP_TERMS_B
- AP_TERMS_TL
- EGP_CATEGORIES_B
- EGP_CATEGORIES_TL
- EGP_CATEGORIES_VL
- EGP_CATEGORY_SETS_B
- EGP_CATEGORY_SETS_TL
- EGP_ITEM_CLASSES_TL
- EGP_ITEM_STATUS_VL
- EGP_PHASES_VL
- EGP_SYSTEM_ITEMS_B
- EGP_SYSTEM_ITEMS_B_V
- EGP_SYSTEM_ITEMS_TL_V
- EGP_SYSTEM_ITEMS_VL
- FND_ATTACHED_DOCUMENTS
- FND_CAL_DAY
- FND_CAL_MONTH
- FND_CAL_QUARTER
- FND_CAL_WEEK
- FND_CAL_YEAR
- FND_DOCUMENTS_VL
- FND_KF_STR_INSTANCES_VL
- FND_LOOKUPS
- FND_LOOKUP_VALUES_TL
- FND_SETID_SETS_VL
- FND_TERRITORIES_TL
- FND_VS_TYPED_VALUES_VL
- FUN_ALL_BUSINESS_UNITS_V
- FUN_BU_USAGES_V
- GL_CALENDARS
- GL_CODE_COMBINATIONS
- GL_DAILY_RATES
- GL_FISCAL_DAY_V
- GL_FISCAL_PERIOD_V
- GL_FISCAL_QUARTER_V
- GL_FISCAL_YEAR_V
- GL_LEDGERS
- GL_SEG_VAL_HIER_CF
- GMS_AWARD_HEADERS_B
- GMS_AWARD_HEADERS_TL
- GMS_AWARD_HEADERS_VL
- GMS_COST_SHARE_AWARDS_V
- GMS_FUNDING_SOURCES_B
- GMS_FUNDING_SOURCES_TL
- GMS_INSTITUTIONS_VL
- GMS_LOOKUPS
- GMS_ORGANIZATIONS_ALL_V
- HR_ALL_ORGANIZATION_UNITS_F
- HR_ORGANIZATION_INFORMATION_F
- HR_ORGANIZATION_UNITS_F_TL
- HR_ORGANIZATION_V
- HR_ORG_UNIT_CLASSIFICATIONS_F
- HZ_ADDTNL_PARTY_NAMES
- HZ_LOCATIONS
- HZ_ORG_CONTACTS
- HZ_PARTIES
- HZ_PARTY_SITES
- INV_ACTIONS_VL
- INV_MATERIAL_STATUSES_TL
- INV_MATERIAL_STATUSES_VL
- INV_ORG_PARAMETERS
- INV_ORG_PARAMETERS_V
- INV_RULES_VL
- INV_SECONDARY_INVENTORIES_VL
- INV_UNITS_OF_MEASURE_TL
- INV_UNITS_OF_MEASURE_VL
- MSC_ANALYTIC_CALENDARS_V
- MSC_ANALYTIC_ITEMS
- MSC_ANALYTIC_ORG_FLAT_V_DYD
- MSC_ANALYTIC_SUP_FLAT_V_DYD
- MSC_GLOBAL_TRADING_PARTNERS
- MSC_PLANNERS_WITH_PIMID_V
- MSC_TRADING_PARTNER_SITES
- OKC_CONTRACT_TYPES_VL
- OKC_K_HEADERS_ALL_B
- OKC_K_HEADERS_TL
- PER_ADDRESSES_F
- PER_ALL_ASSIGNMENTS_M
- PER_EMAIL_ADDRESSES
- PER_LOCATIONS
- PER_LOCATION_DETAILS_F_TL
- PER_LOCATION_DETAILS_F_VL
- PER_PERSON_NAMES_F_V
- PER_PHONES
- PER_USERS
- PJF_CLASS_CATEGORIES_VL
- PJF_CLASS_CODES_VL
- PJF_EXP_CATEGORIES_B
- PJF_EXP_CATEGORIES_TL
- PJF_EXP_TYPES_B
- PJF_EXP_TYPES_TL
- PJF_IND_RATE_SCH_VL
- PJF_PROJECTS_ALL_B
- PJF_PROJECTS_ALL_TL
- PJF_PROJECTS_ALL_VL
- PJF_PROJECT_STATUSES_VL
- PJF_PROJECT_TYPES_B
- PJF_PROJECT_TYPES_TL
- PJF_PROJECT_TYPES_VL
- PJF_PROJ_ELEMENTS_B
- PJF_PROJ_ELEMENTS_TL
- PJF_PROJ_ELEMENTS_VL
- PJF_UNITS_OF_MEASURE_V
- PJF_WORK_TYPES_B
- PJF_WORK_TYPES_TL
- PJF_WORK_TYPES_VL
- PJO_PROJECT_PROGRESS
- PJT_COLUMN_LKP_VALUES_VL
- POI_TAXONOMY_DATA
- POI_TXNMY_SEG_LOOKUP
- PON_AUCTION_ITEM_PRICES_ALL
- PON_BID_ITEM_PRICES
- POQ_INITIATIVES
- POR_APPROVAL_TASK_COMMENTS
- POR_BROWSE_CATEGORIES_TL
- POR_ITEM_CAT_PARENT_LEVELS
- POR_REQUISITION_HEADERS_ALL
- POR_REQUISITION_LINES_ALL
- POR_REQ_DISTRIBUTIONS_ALL
- POZ_BUS_CLASSIFICATIONS
- POZ_SUPPLIERS
- POZ_SUPPLIER_SITES_ALL_M
- PO_ACTION_HISTORY
- PO_AGENTS_V
- PO_DISTRIBUTIONS_ALL
- PO_DOCUMENT_TYPES_VL
- PO_DOC_STYLE_HEADERS
- PO_DOC_STYLE_LINES_B
- PO_DOC_STYLE_LINES_TL
- PO_DOC_STYLE_LINES_VL
- PO_HAZARD_CLASSES_TL
- PO_HAZARD_CLASSES_VL
- PO_HEADERS_ALL
- PO_HEADERS_DRAFT_ALL
- PO_LINES_ALL
- PO_LINES_DRAFT_ALL
- PO_LINE_LOCATIONS_ALL
- PO_LINE_LOCATIONS_DRAFT_ALL
- PO_LINE_TYPES_B
- PO_LINE_TYPES_TL
- PO_LOOKUP_CODES
- PO_SPCL_HANDLING_TYPES_B
- PO_SPCL_HANDLING_TYPES_TL
- PO_UN_NUMBERS_VL
- PO_VERSIONS
- PO_VERSIONS_INIT_SEQUENCE_V
- RA_RULES
- RA_TERMS_VL
- RCV_SHIPMENT_LINES
- RCV_TRANSACTIONS
- XLA_ACCTG_METHODS_TL
- XLE_ENTITY_PROFILES
- ZCA_BI_CRM_CALENDAR
- ZCA_BI_CRM_CAL_PERIOD
- ZCA_BI_CRM_CAL_QUARTER
- ZMM_SR_SCHEDULES_VL
- ZX_FC_DOCUMENT_FISCAL_V
- ZX_FC_INTENDED_USE_V
Need to join Procurement across other subject areas?
That's the warehouse build, conformed dimensions, reconciled to source, you own it.
Problems that run through this subject area