You are browsing the archive for Concurrent Requests & Reports.

Purge Fact Interface Tables

 

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

 

Delete Fact Duplicate Data

 

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

 

Delete Dimension Duplicate Data

 

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