Oracle Fusion Transactional Business Intelligence supports descriptive flexfields for the dimensions shown below.
Table 12. Descriptive Flexfields Supported in Transactional Business Intelligence
Product Area | DFF Code | Fact Name |
|---|---|---|
Financials | AP_CHECKS | Dim - AP Disbursement Details |
Financials | AP_HOLDS | Dim - AP Hold Details |
Financials | AP_INVOICE_DISTRIBUTIONS | Dim - AP Transaction Details |
Financials | AP_INVOICE_LINES | Dim - AP Transaction Details |
Financials | AP_INVOICES | Dim - AP Transaction Details |
Financials | AP_PAYMENT_SCHEDULES | Dim - AP Payment Schedule Details |
Financials | AP_TERMS_B | Dim - AP Terms |
Financials | AR_ADJUSTMENTS | Dim - AR Adjustment Details |
Financials | AR_APPROVAL_ACTION_HISTORY | Dim - AR Adjustment Approval Action History Details |
Financials | AR_CASH_RECEIPTS | Dim - AR Standard Receipt Details |
Financials | AR_MISC_CASH_DISTRIBUTIONS | Dim - AR Miscellaneous Receipt Details |
Financials | AR_PAYMENT_SCHEDULES | Dim - AR Payment Schedule Details |
Financials | AR_RATE_ADJUSTMENTS | Dim - AR Receipt Rate Adjustment Details |
Financials | AR_RECEIPT_CLASSES | Dim - AR Receipt Method |
Financials | AR_RECEIPT_METHODS | Dim - AR Receipt Method |
Financials | AR_RECEIVABLE_APPLICATIONS | Dim - AR Standard Receipt Details |
Financials | AR_REVENUE_ADMUSTMENTS | Dim - AR Revenue Adjustment Details |
Financials | CE_BANK_ACCOUNTS | Dim - CE Bank Accounts |
Financials | CE_EXTERNAL_TRANSACTIONS | Dim - CE External Cash Transaction Details |
Financials | CE_STATEMENT_HEADERS | Dim - CE Bank Statement Details |
Financials | CE_STATEMENT_LINES | Dim - CE Bank Statement Details |
Financials | FA_ADDITIONS | Dim - Fixed Asset |
Financials | FA_ASSET_INVOICES | Dim - Asset Source Lines Details |
Financials | FA_BOOK_CONTROLS | Dim - Asset Book |
Financials | FA_CALENDAR_TYPES | Dim - Date Fixed Assets Calendar |
Financials | FA_CATEGORIES | Dim - Asset Category |
Financials | FA_CATEGORY_BOOKS | Dim - Asset Category Book |
Financials | FA_FISCAL_YEAR | Dim - Date Fixed Assets Calendar |
Financials | FA_LOCATIONS | Dim - Asset Location |
Financials | FA_RETIREMENTS | Dim - Asset Retirement Details |
Financials | FA_TRANSACTION_HEADERS | Dim - Asset Transaction History Details |
Financials | FUN_DIST_LINES | Dim - Intercompany Transaction Distribution Details |
Financials | FUN_TRX_BATCHES | Dim - Intercompany Transaction Distribution Details |
Financials | FUN_TRX_HEADERS | Dim - Intercompany Transaction Distribution Details |
Financials | GL_CODE_COMBINATIONS | Dim - GL Account |
Financials | GL_JE_BATCHES | Dim - GL Journal Details |
Financials | GL_JE_CATEGORIES | Dim - GL Journal Category |
Financials | GL_JE_HEADERS | Dim - GL Journal Details |
Financials | GL_JE_LINES | Dim - GL Journal Details |
Financials | GL_JE_SOURCES | Dim - GL Journal Source |
Financials | GL_LEDGERS | Dim - Ledger |
Financials | GL_PERIOD_STATUSES | Fact - Fins - GL Period Statuses |
Financials | GL_PERIODS | Dim - Date Fiscal Calendar |
Financials | RA_CUST_TRX_LINE_GL_DIST | Dim - AR Transaction Details |
Financials | RA_CUST_TRX_LINE_SALESREPS | Dim - AR Transaction Details |
Financials | RA_CUST_TRX_TYPES | Dim - AR Transaction Type |
Financials | RA_CUSTOMER_TRX | Dim - AR Transaction Details |
Financials | RA_CUSTOMER_TRX_LINES | Dim - AR Transaction Details |
Financials | RA_RULES | Dim - AR Accounting Rule |
Financials | RA_TERMS | Dim - AR Payment Terms |
Financials | RA_TERMS_LINES | Dim - AR Payment Terms |
Financials | XLA_AE_HEADERS | Dim - SLA Journal Details |
Financials | XLA_AE_LINES | Dim - SLA Journal Details |
Financials | XLE_ETB_INFO_DEV | Dim - Legal Entity |
Financials | XLE_LE_ADD_INFO | Dim - Legal Entity |
Financials | XLE_LE_INFO_DEV | Dim - Legal Entity |
Human Capital Management | HRA_DOC_TYPES_B | Dim - Document Type |
Human Capital Management | HRA_EVAL_ITEMS | Dim - Performance Document Section Item |
Human Capital Management | HRA_EVAL_RATINGS | Dim - Performance Rating |
Human Capital Management | HRA_EVALUATIONS | Dim - Performance Evaluation |
Human Capital Management | HRA_SECTION_DEFNS_B | Dim - Performance Document Section |
Human Capital Management | HRA_TMPL_DEFNS_B | Dim - Performance Template |
Human Capital Management | HRA_TMPL_SECTIONS | Dim - Performance Document |
Human Capital Management | HRG_GOAL_PLANS_B | Dim - Performance Goal Plan |
Human Capital Management | HRG_GOALS | Dim - Performance Goals |
Human Capital Management | HRR_MEETINGS | Dim - Talent Review Meeting |
Human Capital Management | HRT_CONTENT_ITEMS_B | Dim - Content Item |
Human Capital Management | HRT_PROFILE_ITEMS | Dim - Person Profile Details |
Human Capital Management | HRT_RATING_LEVELS_B | Dim - Potential |
Human Capital Management | HRT_RATING_MODELS_B | Dim - Rating Model |
Human Capital Management | PER_ABSENCE_DFF | Dim - Assignment Absences Details |
Human Capital Management | PER_ACT_DFF | Dim - HR Action |
Human Capital Management | PER_ACT_REASONS_DFF | Dim - HR Action Reason |
Human Capital Management | PER_ADDRESSES_DFF | Dim - Worker Location |
Human Capital Management | PER_ALL_PEOPLE_DFF | Dim - Person Details |
Human Capital Management | PER_ASG_DFF | Dim - Worker Assignment Details |
Human Capital Management | PER_ASG_WORK_MEASURES_DFF | Dim - Worker Measure Details |
Human Capital Management | PER_CITIZENSHIPS_DFF | Dim - Person Citizenship |
Human Capital Management | PER_CONTACT_RELSHIPS_DFF | Dim - Person Contact Relationship |
Human Capital Management | PER_CONTRACT_DFF | Dim - Employment Contract Details |
Human Capital Management | PER_DRIVERS_LICENSE_TYPES_DFF | Dim - Person Driver License |
Human Capital Management | PER_EMAIL_ADDRESSES_DFF | Dim - Person Email Addresses |
Human Capital Management | PER_ETHNICITIES_DFF | Dim - Person Ethnicity |
Human Capital Management | PER_EVALUATION_CRITERIA_DFF | Dim - Job |
Human Capital Management | PER_GRADES_DFF | Dim - HR Grade |
Human Capital Management | PER_JOB_FAMILY_DFF | Dim - Job |
Human Capital Management | PER_JOBS_DFF | Dim - Job |
Human Capital Management | PER_LOCATIONS_DF | Dim - Worker Location |
Human Capital Management | PER_NATIONAL_IDENTIFIERS_DFF | Dim - Person National Identifiers |
Human Capital Management | PER_ORGANIZATION_UNIT_DFF | Dim - Department |
Human Capital Management | PER_PERSON_ADDR_USG_DFF | Dim - Person Address |
Human Capital Management | PER_PERSON_DLVRY_METHODS_DFF | Dim - Person Delivery Methods |
Human Capital Management | PER_PERSON_LEGISLATIVE_DFF | Dim - Person Legislative Information |
Human Capital Management | PER_PERSON_NAME_DFF | Dim - Person Names |
Human Capital Management | PER_PERSON_TYPE_USG_DFF | Dim - Person Type |
Human Capital Management | PER_PERSONS_DFF | Fact - Person |
Human Capital Management | PER_PHONES_DFF | Dim - Person Phones |
Human Capital Management | PER_POSITIONS_DFF | Dim - HR Position |
Human Capital Management | PER_PPS_DFF | Dim - Work Relationship Details |
Human Capital Management | PER_RATE_VALUES_DFF | Fact - Grade Rate |
Human Capital Management | PER_RELIGIONS_DFF | Dim - Person Religion |
Human Capital Management | PER_VISA_PERMIT_DFF | Dim - Person Work Permit |
Incentive Compensation | CN_COMP_PLANS_DFF | Dim - Compensation Plan |
Incentive Compensation | CN_MEASURES_DFF | Dim - Performance Measure |
Incentive Compensation | CN_PARTICIPANT_DETAIL_DFF | Dim - Participant Details |
Incentive Compensation | CN_PLAN_COMPONENTS_DFF | Dim - Plan Component |
Incentive Compensation | CN_TP_BASETRANS_DFF | Dim - Participant Transaction Details |
Procurement | PO_DISTRIBUTIONS | Dim - Purchase Order Details |
Procurement | PO_DOCUMENT_TYPES | Dim - Purchase Order Transaction Type |
Procurement | PO_HEADERS | Dim - Purchase Order Details |
Procurement | PO_LINE_LOCATIONS | Dim - Purchase Order Details |
Procurement | PO_LINE_TYPES | Dim - Purchase Line Type |
Procurement | PO_LINES | Dim - Purchase Order Details |
Procurement | PON_AUCTION_HEADERS | Dim - Sourcing Negotiation Details |
Procurement | POR_REQ_DISTRIBUTIONS | Dim - Purchase Requisition Details |
Procurement | POR_REQUISITION_HEADERS | Dim - Purchase Requisition Details |
Procurement | POR_REQUISITION_LINES | Dim - Purchase Requisition Details |
Procurement | POZ_SUPPLIER_SITES_ALL_M | Dim - Supplier Sites |
Procurement | POZ_SUPPLIERS | Dim - Supplier |
Projects | ContractHeaderFlexfield | Dim - Project Contract |
Projects | OKC_LINES_DESC_FLEX | Dim - Project Contract |
Projects | PJB_BILLING_EVENTS_FLEX | Dim - Project Invoice Details |
Projects | PJB_INVOICE_HEADERS_FLEX | Dim - Project Invoice Details |
Projects | PJB_INVOICE_LINES_FLEX | Dim - Project Invoice Details |
Projects | PJC_EXP_ITEMS_DESC_FLEX | Dim - Project Costing Details |
Projects | PJC_TXN_XFACE_DESC_FLEX | Dim - Project Unprocessed Transaction Details |
Projects | PJF_CLASS_CATEGORIES_DESC_FLEX | Dim - Project |
Projects | PJF_CLASS_CODES_DESC_FLEX | Dim - Project |
Projects | PJF_EVENT_TYPES_DESC_FLEX | Fact Project ETL VOs - do not delete |
Projects | PJF_EXP_CATEGORIES_DESC_FLEX | Dim - Financial Resource |
Projects | PJF_EXP_TYPES_DESC_FLEX | Dim - Financial Resource |
Projects | PJF_NONLAB_RES_DESC_FLEX | Dim - Non Labor Resource |
Projects | PJF_PROJECT_CLASS_CODE_DESC_FLEX | Dim - Project |
Projects | PJF_PROJECT_TYPES_DESC_FLEX | Dim - Project |
Projects | PJF_PROJECTS_DESC_FLEX | Dim - Project |
Projects | PJF_TASK_STRUCTURE_DFF | Dim - Task |
Projects | PJF_WORK_TYPES_DESC_FLEX | Dim - Work Type |
Projects | PJO_PLAN_LINES_DFF | Dim - Project Budget Details |
Projects | PJO_PLANNING_OPTIONS_DFF | Dim - Project Budget Version |
Supply Chain Management | CARRIER_ORGANIZATION | Dim - Shipping Method |
Supply Chain Management | CST_ANALYSIS_CODES_B | Dim - Cost Analysis Group |
Supply Chain Management | CST_ANALYSIS_GROUPS_B | Dim - Cost Analysis Group |
Supply Chain Management | CST_COST_BOOKS_B | Dim - Cost Organization Book |
Supply Chain Management | CST_COST_ELEMENTS_B | Dim - Cost Element |
Supply Chain Management | CST_COST_ORG_BOOKS | Dim - Cost Organization Book |
Supply Chain Management | CST_ELEMENT_ANALYSIS_GROUPS | Dim - Cost Analysis Group |
Supply Chain Management | CST_VAL_STRUCTURES_B | Dim - Cost Valuation Unit |
Supply Chain Management | CST_VAL_UNITS_B | Dim - Cost Valuation Unit |
Supply Chain Management | DOO_PROCESS_DEFS_ADD_INFO | Dim - DOO Process |
Supply Chain Management | DOO_PROCESS_STEPS_ADD_INFO | Dim - Step |
Supply Chain Management | DOO_TASK_TYPES_ADD_INFO | Dim - Primary Task |
Supply Chain Management | EGO_CHANGE_LINE | Dim - New Item Request Line Details |
Supply Chain Management | EGO_ENGINEERING_CHANGES | Dim - New Item Request Details |
Supply Chain Management | EGP_CATEGORY_DFF | Dim - Item |
Supply Chain Management | EGP_CATEGORY_SETS_DFF | Dim - Item |
Supply Chain Management | EGP_COMPONENT_DFF | Dim - PIM - Components Details |
Supply Chain Management | EGP_ITEM_CLASS_DFF | Dim - PIM - Item Class |
Supply Chain Management | EGP_ITEM_RELATIONSHIPS_DFF | Dim - Cross Reference Item Details |
Supply Chain Management | EGP_ITEM_REVISIONS_DFF | Dim - PIM - Item and Revisions Details |
Supply Chain Management | EGP_REFERENCE_DESIGNATOR_DFF | Dim - PIM - Reference Designator |
Supply Chain Management | EGP_STRUCTURE_HEADER_DFF | Dim - PIM - Structure Details |
Supply Chain Management | EGP_SUBSTITUTE_COMPONENT_DFF | Dim - PIM - Substitute Component |
Supply Chain Management | EGP_SYSTEM_ITEMS_DFF | Dim - Item |
Supply Chain Management | EGP_TRADING_PARTNER_ITEMS_DFF | Dim - Trading Partner Item Details |
Supply Chain Management | INV_GRADES | Dim - Inventory Grade |
Supply Chain Management | INV_ITEM_LOCATIONS | Dim - Storage Location |
Supply Chain Management | INV_LOT_ATTRIBUTES | Dim - Inventory Lot |
Supply Chain Management | INV_LOT_NUMBERS | Dim - Inventory Lot |
Supply Chain Management | INV_MATERIAL_TXNS | Dim - Inventory Details |
Supply Chain Management | INV_ORG_PARAMETERS | Dim - Inventory Org |
Supply Chain Management | INV_SECONDARY_INVENTORIES | Dim - Storage Location |
Supply Chain Management | INV_TRANSACTION_REASONS | Dim - Receipt Transaction Reasons |
Supply Chain Management | INV_TRANSACTION_TYPES | Dim - Movement Types |
Supply Chain Management | INV_TXN_SOURCE_TYPES | Dim - Inventory Transaction Source Type |
Supply Chain Management | RCV_SHIPMENT_HEADERS | Dim - Inbound Shipment Details |
Supply Chain Management | RCV_SHIPMENT_LINES | Dim - Inbound Shipment Details |
Supply Chain Management | RCV_TRANSACTIONS | Dim - Receipt Details |
Supply Chain Management | WSH_CARRIERS | Dim - Carrier |
Supply Chain Management | WSH_DELIVERY_DETAILS | Dim - Sales Pick Details |
Supply Chain Management | WSH_NEW_DELIVERIES | Dim - Sales Pick Details |