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

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.

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