NAME: Collect Defect Analysis Fact
SHORT CODE: OPI_EDW_COLLECT_DEF_ANALYSIS_F
MODULE: Oracle Operations Intelligence

Description:
Navigation: Oracle Operations Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_from_date : Collection Start Date
• p_to_date : Collection End Date
• p_fact_name : Fact Name
• p_staging_table : Staging Table Name

NAME: Collect Cost Variance Summary Fact
SHORT CODE: OPI_EDW_COLLECT_COSTVAR
MODULE: Oracle Operations Intelligence

Description:
Navigation: Oracle Operations Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_from_date : Collection Start Date
• p_to_date : Collection End Date
• p_fact_name : Fact Name
• p_staging_table : Staging Table Name

NAME: Collect COGS Shipment Fact
SHORT CODE: OPI_EDW_COLLECT_COGS_F
MODULE: Oracle Operations Intelligence

Description:
Navigation: Oracle Operations Intelligence Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_from_date : Collection Start Date
• p_to_date : Collection End Date
• p_fact_name : Fact Name
• p_staging_table : Staging Table Name