NAME: Purge Fact Interface Tables
SHORT CODE: EDW_FACT_DEL
MODULE: Oracle Application BIS

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

Report Parameters:

• Fact List : Name of the fact table
• p_purge_option : Select mode to delete loaded records or all records

NAME: Delete Fact Duplicate Data
SHORT CODE: EDW_DEL_FACT_DUP_DATA
MODULE: Oracle Application BIS

Description: Deletes duplicate entries from a fact
Navigation: Oracle Application BIS Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• Fact Name : Fact Name

NAME: Delete Dimension Duplicate Data
SHORT CODE: EDW_DEL_DIM_DUP_DATA
MODULE: Oracle Application BIS

Description: Deletes duplicate entries from a dimension or level tables
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 Name