NAME: Collect Job Details Fact
SHORT CODE: OPI_EDW_COLLECT_JOB_DETAIL_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 Job Resource Fact
SHORT CODE: OPI_EDW_COLLECT_JOBRSRC_FACT
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 Inventory Daily Status Fact
SHORT CODE: OPI_EDW_COLLECT_IDS_FACT
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