You are browsing the archive for Oracle Enterprise Performance Foundation.

Fact Interface Table Dimension Member Error Report

 

NAME: Fact Interface Table Dimension Member Error Report
SHORT CODE: FEM_INTF_DIM_VALIDATION
MODULE: Oracle Enterprise Performance Foundation

Description: Fact Interface Table Dimension Member Error Report
Navigation: Oracle Enterprise Performance Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_OBJ_DEF_ID : Rule (Object Definition ID)
  • P_LEDGER_ID : Ledger ID
  • P_CAL_PERIOD_ID : Calendar Period ID
  • P_DATASET_CODE : Dataset Code
  • P_SOURCE_SYSTEM_CODE : Source System Code
  • P_NUM_ROWS : Number of rows to be validated
  • P_PRINT_REPORT_FLAG : Print Report
  • P_NUM_REC_TO_PRINT : Number of rows to print

 

Dimension Hierarchy Loader

 

NAME: Dimension Hierarchy Loader
SHORT CODE: FEM_HIER_LOADER
MODULE: Oracle Enterprise Performance Foundation

Description: For loading Dimension hierarchies from interface tables
Navigation: Oracle Enterprise Performance Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_object_definition_id : Dimension Hierarchy Loader Object Definition ID
  • p_execution_mode : Execution Mode
  • p_dimension_varchar_label : Dimension Varchar Label
  • p_hierarchy_object_name : Hierarchy Object Name
  • p_hier_obj_def_display_name : Hierarchy Version Name

 

Program – Enterprise Performance Foundation Discoverer Hierarchy Transformation Engine

 

NAME: Program – Enterprise Performance Foundation Discoverer Hierarchy Transformation Engine
SHORT CODE: FEM_DIS_HIER_TRANS
MODULE: Oracle Enterprise Performance Foundation

Description: Program – Enterprise Performance Foundation Discoverer Hierarchy Transformation Engine
Navigation: Oracle Enterprise Performance Foundation Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Dimension Name : Dimension Name