Oracle Fusion · OTBI subject area
Procurement - Purchasing Agreements Real Time
Free reference100 tables499 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 limit: an analysis can combine subject areas only through the dimensions they share, with a measure from each, or by stacking results with set operators such as union, and only inside one Oracle Cloud application. Real Time subject areas read the live application tables when the report runs. The warehouse you own joins across modules and systems on conformed keys, and reports run there, not on 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
- FUN_ALL_BUSINESS_UNITS_V
- GL_CODE_COMBINATIONS
- GL_LEDGERS
- HR_ALL_ORGANIZATION_UNITS_F
- HR_ORGANIZATION_INFORMATION_F
- HR_ORGANIZATION_UNITS_F_TL
- HR_ORG_UNIT_CLASSIFICATIONS_F
- HZ_LOCATIONS
- HZ_ORG_CONTACTS
- HZ_PARTIES
- HZ_PARTY_SITES
- INV_ACTIONS_VL
- INV_MATERIAL_STATUSES_VL
- INV_ORG_PARAMETERS
- INV_ORG_PARAMETERS_V
- INV_RULES_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_K_HEADERS_ALL_B
- PER_ADDRESSES_F
- 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_EXP_TYPES_TL
- 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_LINES_ALL
- POZ_BUS_CLASSIFICATIONS
- POZ_SUPPLIERS
- POZ_SUPPLIER_SITES_ALL_M
- PO_ACTION_HISTORY
- PO_AGENTS_V
- PO_ATTRIBUTE_VALUES
- PO_ATTRIBUTE_VALUES_TLP
- PO_DOC_STYLE_HEADERS
- PO_DOC_STYLE_LINES_B
- PO_DOC_STYLE_LINES_TL
- PO_GA_ORG_ASSIGNMENTS
- 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_TYPES_B
- PO_LINE_TYPES_TL
- PO_LOOKUP_CODES
- PO_NOTIFICATION_CONTROLS
- PO_UN_NUMBERS_VL
- PO_VERSIONS
- RA_RULES
- RA_TERMS_VL
- RCV_SHIPMENT_LINES
- RCV_TRANSACTIONS
- XLE_ENTITY_PROFILES
- ZCA_BI_CRM_CALENDAR
- ZMM_SR_SCHEDULES_VL
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