You are browsing the archive for FEM.

Oracle Enterprise Performance Foundation Tables

Oracle Enterprise Performance Foundation module – database tables

  • FEM_ACTIVITIES
  • FEM_ACTIVITIES_HIER
  • FEM_COLUMN_REQUIREMNT_TL
  • FEM_COST_OBJECTS
  • FEM_COST_OBJECTS_HIER
  • FEM_COST_OBJ_HIER_QTY
  • FEM_DB_LINKS_TL
  • FEM_FOLDERS_TL
  • FEM_INTG_AOL_VALSET_MAP
  • FEM_INTG_BAL_DEF_BSVS
  • FEM_INTG_BAL_DEF_BUDGTS
  • FEM_INTG_BAL_DEF_CURRS
  • FEM_INTG_BAL_DEF_ENCS
  • FEM_INTG_BAL_RULES
  • FEM_INTG_BAL_RULE_DEFS
  • FEM_INTG_BPI_CURR_GT
  • FEM_INTG_BUDGT_DS
  • FEM_INTG_CALENDAR_MAP
  • FEM_INTG_COA_GVSC_MAP
  • FEM_INTG_DELTA_LOADS
  • FEM_INTG_DIM_RULES
  • FEM_INTG_DIM_RULE_DEFS
  • FEM_INTG_ENC_TYPE_DS
  • FEM_INTG_HIER_DEF_SEGS
  • FEM_INTG_HIER_RULES
  • FEM_INTG_OGL_CCID_MAP
  • FEM_LD_CAL_PERIODS_GT
  • FEM_LD_DIM_REQUESTS_GT
  • FEM_LD_HIER_REQUESTS_GT
  • FEM_LD_INTERFACE_DATA_GT
  • FEM_OBJECT_CATALOG_TL
  • FEM_OBJECT_DEFINITION_TL
  • FEM_TABLES_TL
  • FEM_TAB_COLUMNS_GT
  • FEM_TAB_COLUMNS_TL

Enterprise Performance Foundation Profile Options

Oracle Enterprise Performance Foundation Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
FEM_NUM_OF_LOADERS FEM: Number of Detail Client Data Loader Requests
FEM_CCE_DEBUG_TRACE FEM: CCE Debug Trace
FEM_DATASET FEM: Dataset
FEM_EFFECTIVE_DATE FEM: Effective Date
FEM_PERIOD FEM: Period
FEM_SEC_FOLDER FEM: Security Folder
FEM_IO_DATA_DEFINITION FEM: Data Set Group
FEM_INTF_ATTR_DATE_FORMAT_MASK FEM: Attribute Interface Table Date Format Mask
FEM_RULE_MIGRATION_ACCESS FEM: Rule Migration Access
FEM_DEFAULT_ACTUALS_DATASET FEM: Default Actuals Dataset
FEM_GL_ADV_MAPPING_FLAG FEM: GL Advanced Mapping Flag
FEM_LOADER_DIM_GRP_SIZE FEM: Loader Dimension Grouping Size
FEM_CURRENCY_TYPE FEM: Currency Type
FEM_TRACK_EVENT_CHAINS FEM: Track Event Chains
FEM_CURRENCY_CONVERSION_TYPE FEM: Currency Conversion Type
FEM_RULE_SET_DEPTH FEM: Rule Set Depth Limit
FEM_FEMTOP FEM: FEM Top
FEM_APPLICATION_CODE FEM: Application Code
FEM_LEDGER FEM: Ledger
FEM_EFFECTIVE_END_DATE FEM: Default Effective End Date
FEM_EFFECTIVE_START_DATE FEM: Default Effective Start Date
FEM_SIGNAGE_METHOD FEM: Signage Methodology
FEM_RESULT_ROUNDING_FLAG FEM: Result Rounding Flag

Enterprise Performance Foundation Concurrent Programs

Oracle Enterprise Performance Foundation Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
FEM_TR_SVIEW_GEN Table Registration View Generator
FEM_TR_ALL_TBL_VIEW_GEN All Table View Generator
FEM_ADI_RELOAD_METADATA Maintain Web ADI MetaData for Table Integration
FEM_REFRESH_MV Program – Refresh Materialized Views
FEM_BI_DIM_ATTR_TRANS Program – Enterprise Performance Foundation Dimension Attribute Transformation Engine
FEM_BI_DIM_HIER_TRANS Program – Enterprise Performance Foundation Dimension Hierarchy Transformation Engine
FEMDICXML Generate XML based on selection sets in Data Inspector
FEMDICREPDEF Publish Custom XML report based on selection sets in Data Inspector
DHMHIDEL DHM: Delete Hierarchy
DHMHIDUP DHM: Duplicate Hierarchy
DHMHVADD DHM: Flatten Focus Node
DHMHVDEL DHM: Delete Hierarchy Version
DHMHVDFL DHM:Unflatten Focus Node
DHMHVDUP DHM: Duplicate Hierarchy Version
DHMHVFLW DHM:Flatten Hierarchy Version
DHMHVMFL DHM: Flatten Focus Node of Hierarchy Version
DHMHVMOV DHM: Flatten Focus Node Tree
FEM_DIM_MEMBER_LOADER Dimension Member Loader
FEM_HIER_LOADER Dimension Hierarchy Loader
FEM_MPSUBREQ Multi-Proc Sub-Request
FEM_OFA_GL_MAPPING FEM_OFA: Dimension Mapping
FEM_OFA_INIT FEM_OFA: Initialize OFA Link
FEM_OFA_REQUEST FEM_OFA: Run General Ledger Requests
FEM_SIGN_EXT_ACCT_TYPES Sign Extended Account Types
FEM_SUBMIT_UNDO_LISTS Historic Executed Rules Removal
FEM_UNDO_LIST Executed Rule Removal – All Object Executions
FEM_UNDO_OBJ_EXEC Executed Rule Removal
FEM_UNDO_REQUEST Executed Rule Request Removal
FEM_XGL_POST_ENGINE External General Ledger Data Loader
FEM_RFSH_FNDLOAD Refresh Seeded Data Loader
FEM_GENDEFAULTS Generate Default Members
FEM_POPULATE_MEM_ADI_METADATA Maintain Web ADI MetaData for Dimension Member Integration
FEM_DATA_LOADER Data and Ledger Loader
FEM_DIM_HIER_LOADER Dimension Member and Hierarchy Loader
FEM_INTG_UNDO_DIM_RULE Program – Enterprise Performance Foundation Executed General Ledger Dimension Rule Undo
FEM_DIS_HIER_TRANS Program – Enterprise Performance Foundation Discoverer Hierarchy Transformation Engine
FEM_MIGRATE_DIM_HIERARCHY Dimension Hierarchy Migration
FEM_MIGRATE_DIM_MEMBERS Dimension Member Migration
FEM_REFRESH Refresh Engine
FEM_RU_COUC_ROLLUP Cost Object Unit Cost Rollup Engine
FEM_RU_ACT_STAT_ROLLUP Activity Statistic Rollup Engine
FEM_RU_ACT_COST_ROLLUP Activity Cost Rollup Engine
FEM_INTG_CAL_RULE_ENGINE Program – Enterprise Performance Foundation General Ledger Calendar Rule Engine
FEM_INTG_DIM_RULE_ENGINE Program – Enterprise Performance Foundation General Ledger Dimension Rule Engine
FEM_INTG_HIER_RULE_ENGINE Program – Enterprise Performance Foundation General Ledger Hierarchy Rule Engine
FEM_INTG_BAL_RULE_ENGINE Program – Enterprise Performance Foundation General Ledger Balances Rule Engine
DHMHIFLA DHM: Flatten whole Hierarchy
FEM_SOURCE_DATA_LOADER Detail Client Data Loader
FEMCONDAPI FEM: Conditions API
FEM_CCE Enterprise Profitability Manager Common Calculation Engine
FEM_SUBMIT_MAPPING_RULE FEM: Single Rule Submission
FEMVALRULSET FEM: Validate Rule Set
FEMVALRUL FEM: Validate Rule
FEM_EXP_BUSINESS_RULE Export Business Rule
FEM_MIG_BUSINESS_RULE Migrate Business Rule
FEM_INTF_DIM_VALIDATION Fact Interface Table Dimension Member Error Report
FEMDIREPDEF Publish XML report based on selection sets in Data Inspector
FEM_INTG_DIM_RULE_WORKER Program – Enterprise Performance Foundation General Ledger Dimension Rule Worker
FEM_CHECK_BR_DIS_MBRS Report Mapping Rules That Reference Disabled Dimension Members
FEM_PURGE_DIS_MBRS_REPORT Purge Reporting Data on Disabled Dimension Members
FEM_UNDO_REPAIR Executed Rule Repair
FEM_UNDO_REQUEST_BY_RULE_SET Executed Rule Request Removal by Rule Set
FEM_INTG_OGL_WRITEBACK Program – Enterprise Performance Foundation General Ledger Writeback
FEM_DYNAMIC_INIT Program – Enterprise Performance Foundation General Ledger Writeback Initialization
PURGEIMPORTEDRULES Purge Imported Business Rules
FEM_INTG_DIM_HIER_RULE_ENGINE Program – Enterprise Performance Foundation General Ledger Dimension and Hierarchy Rules Engine