You are browsing the archive for Oracle Enterprise Performance Foundation.

Refresh Seeded Data Loader

 

NAME: Refresh Seeded Data Loader
SHORT CODE: FEM_RFSH_FNDLOAD
MODULE: Oracle Enterprise Performance Foundation

Description: Concurrent Program called by the Refresh Engine to load a particular seeded data file
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_upload : UPLOAD designation
  • p_lct : Location of the control file
  • p_ldt : Location of the data file

 

Program – Refresh Materialized Views

 

NAME: Program – Refresh Materialized Views
SHORT CODE: FEM_REFRESH_MV
MODULE: Oracle Enterprise Performance Foundation

Description:
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:

  • Base Table Name :

 

Purge Reporting Data on Disabled Dimension Members

 

NAME: Purge Reporting Data on Disabled Dimension Members
SHORT CODE: FEM_PURGE_DIS_MBRS_REPORT
MODULE: Oracle Enterprise Performance Foundation

Description: Removes reporting data created by the program that reports Mapping Rules That Reference Disabled Dimension Members
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_EXEC _START_DATE : Execution Start Date
  • P_EXEC _END_DATE : Execution End Date
  • P_REQUEST_ID : Request ID