You are browsing the archive for Concurrent Requests & Reports.

Purge Dimension Interface Tables

 

NAME: Purge Dimension Interface Tables
SHORT CODE: EDW_DEL_DIM
MODULE: Oracle Application BIS

Description: Delete interface tables for the dimensions
Navigation: Oracle Application BIS Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Dimension Name : Dimension Logical Name (null to specify all dimensions)
  • p_purge_option : Select mode to delete loaded records or all records

 

Recompile Invalid Packages

 

NAME: Recompile Invalid Packages
SHORT CODE: EDW_COMPILE_PACKAGES
MODULE: Oracle Application BIS

Description: Recompile Invalid Packages
Navigation: Oracle Application BIS Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_expr : Recompile packages LIKE this parameter.

 

Check Fact Data Validity

 

NAME: Check Fact Data Validity
SHORT CODE: EDW_CDI_FACT_C_T
MODULE: Oracle Application BIS

Description: Check Fact Data Validity
Navigation: Oracle Application BIS Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_fact_string1 : Concatenated String of selected Facts
  • p_fact_string2 : Concatenated String of selected Facts
  • p_fact_string3 : Concatenated String of selected Facts
  • p_fact_string4 : Concatenated String of selected Facts
  • p_fact_string5 : Concatenated String of selected Facts
  • p_check_tot_recs : Option to check number of valid records